V$LOGFILE

Oracle 11gR1

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: · INVALID - File is inaccessible · STALE - File's contents are incomplete · DELETED - File is no longer used · null - File is in use
TYPE	VARCHAR2(7)	Type of the logfile: · ONLINE · STANDBY
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)

Oracle dynamic performance views