1.redo log相关数据字典
v$log:display the redo log file information from the control file
v$logfile:identifies redo log group# and members and memeber status
v$log_history:contains log history information
2.v$log
Column | Datatype | Description |
---|---|---|
GROUP# |
NUMBER |
Log group number |
THREAD# |
NUMBER |
Log thread number |
SEQUENCE# |
NUMBER |
Log sequence number |
BYTES |
NUMBER |
Size of the log (in bytes) |
MEMBERS |
NUMBER |
Number of members in the log group |
ARCHIVED |
VARCHAR2(3) |
Archive status (YES ) or (NO ) |
STATUS |
VARCHAR2(16) |
Log status:
|
FIRST_CHANGE# |
NUMBER |
Lowest system change number (SCN) in the log |
FIRST_TIME |
DATE |
Time of the first SCN in the log |
3.V$LOGFILE
Column | Datatype | Description |
---|---|---|
GROUP# |
NUMBER |
Redo log group identifier number |
STATUS |
VARCHAR2(7) |
Status of the log member:
|
TYPE |
VARCHAR2(7) |
Type of the logfile:
|
MEMBER |
VARCHAR2(513) |
Redo log member name |
IS_RECOVERY_DEST_FILE |
VARCHAR2(3) |
Indicates whether the file was created in the flash recovery area (YES ) or not (NO ) |