V$LOGFILE
V$LOGFILE
contains information about redo log files.
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 ) |
STATUS列正常时没有值,应该给个VALID值更好