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 ) |