This view contains information about redo log files.
The most relevant view fields are as follows:
GROUP#
: The redo log group identification numberSTATUS
: The status of the log member; it can beINVALID
,STALE
,DELETED
, orNULL
when the file is in useTYPE
: The type of the log file, it can beONLINE
orSTANDBY
MEMBER
: The redo log member nameIS_RECOVERY_DEST_FILE
: This indicates whether the file was created in the fast recovery area (YES
) or not (NO
)