V$LOGFILE
This view contains information about redo log files.
Fields
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
)
See also
- The
V$LOG
andV$LOG_HISTORY
recipes in this appendix
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.