Chapter 9 Oracle recovery Internal principles (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:

 

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

 

 

Chapter 10Oracle recovery internal principle (Various recovery features)

 

* ********* All content of this blog is original. If you have reposted the content, please indicate the author and source !!! **********
Name: guoyjoe

QQ: 252803295

Email: oracledba_cn@hotmail.com

Blog: http://blog.csdn.net/guoyJoe

Itpub: http://www.itpub.net/space-uid-28460966.html

Http://education.oracle.com/education/otn/YGuo.HTM
_____________________________________________________________
Group verification question: Which SGA structures are required and which are optional? Otherwise, your application is rejected !!!

The answer is:Http://blog.csdn.net/guoyjoe/article/details/8624392

DSI & core search (QQ group): 127149411