Oracle internal recovery principle (recovery-related V $ view)

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:

Articles: Oracle recovery Internal principles http://www.bkjia.com/search.aspx? 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