Oracle Recovery internal principles: restoring related v$ views

The v$ view contains information about the data structure that the kernel maintains in memory and can be accessed through a DBA account with SYS privileges. Here is a summary of these v$ views related to recovery:

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 archived log information that needs to be used to complete media recovery (from the log history information in the control file)

thread#

sequence#

Low_scn_time

Archived_name

9.5 V$recover_file

Contains data files that require media recovery and their status

file#

Online_flag

reason_media_recovery_needed

Recovery_start_scn

Recovery_start_scn_time

9.6 V$backup

Contains data file status information in a hot backup

file#

File_status (no-backup-active, backup-active, Offline-normal, error)

Begin_backup_scn

Begin_backup_time

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/