The V $ view contains information about the data structure maintained by the kernel in the memory, which can be accessed through a DBA account with the SYS permission. The following is a summary of these recovery-related views.
The V $ view contains information about the data structure maintained by the kernel in the memory, which can be accessed through a DBA account with the SYS permission. The following is a summary of these recovery-related views.
The V $ view contains information about the data structure maintained by the kernel in the memory, which can be accessed through a DBA account with the SYS permission. The following is a summary of the recovery-related views:
Series of articles: Oracle internal recovery principles? Where = nkey & keyword = 19824
9.1 V $ LOG
Contains the log group information in the control file:
GROUP #
THREAD #
SEQUENCE #
SIZE_IN_BYTES
MEMBERS_IN_GROUP
ARCHIVED_FLAG
STATUS_OF _ GROUP (unused, current, active, inactive)
LOW_SCN
LOW_SCN_TIME
9.2 V $ LOGFILE
Contains the log member information in the control file:
GROUP #
STATUS_OF_MEMBER (invalid, stale, deleted)
NAME_OF_MEMBER
9.3 V $ LOG_HISTORY
Contains the log history information in the control file:
THREAD #
SEQUENCE #
LOW_SCN
LOW_SCN_TIME
NEXT_SCN
9.4 V $ RECOVERY_LOG
Contains the archived log information to be used for media recovery (taken from the log history information in the control file)
THREAD #
SEQUENCE #
LOW_SCN_TIME
ARCHIVED_NAME
9.5 V $ RECOVER_FILE
Contains the data files that need to be restored by media and their statuses.
FILE #
ONLINE_FLAG
REASON_MEDIA_RECOVERY_NEEDED
RECOVERY_START_SCN
RECOVERY_START_SCN_TIME
9.6 V $ BACKUP
Contains the status information of data files in Hot Backup
FILE #
FILE_STATUS (no-backup-active, backup-active, offline-normal, error)
BEGIN_BACKUP_SCN
BEGIN_BACKUP_TIME
,