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 number

• STATUS: The status of the log member; it can be INVALID, STALE, DELETED, or NULL when the file is in use

• TYPE: The type of the log file, it can be ONLINE or STANDBY

• MEMBER: The redo log member name

• IS_RECOVERY_DEST_FILE: This indicates whether the file was created in the fast recovery area (YES) or not (NO)

See also

• The V$LOG and V$LOG_HISTORY recipes in this appendix