This view contains information about redo log files.
Column
Datatype
Description
GROUP#
NUMBER
Redo log group identifier number
STATUS
VARCHAR2
Status of this log member: INVALID (file is inaccessible), STALE (file's contents are incomplete), DELETED (file is no longer used), or blank (file is in use)