This view contains log file information from the control files.
Column
Datatype
Description
GROUP#
NUMBER
Log group number
THREAD#
NUMBER
Log thread number
SEQUENCE#
NUMBER
Log sequence number
BYTES
NUMBER
Size of the log in bytes
MEMBERS
NUMBER
Number of members in the log group
ARCHIVED
VARCHAR2
Archive status: YES, NO
STATUS
VARCHAR2(16)
Log status:
UNUSED: The online redo log has never been written to. This is the state of a redo log that was just added, or just after a RESETLOGS, when it is not the current redo log.
CURRENT: This is the current redo log. This implies that the redo log is active. The redo log could be open or closed.
ACTIVE: The log is active but is not the current log. It is needed for crash recovery. It may be in use for block recovery. It might or might not be archived.
CLEARING: The log is being re-created as an empty log after an ALTER DATABASE CLEAR LOGFILE command. After the log is cleared, the status changes to UNUSED.
CLEARING_CURRENT: The current log is being cleared of a closed thread. The log can stay in this status if there is some failure in the switch such as an I/O error writing the new log header.
INACTIVE: The log is no longer needed for instance recovery. It may be in use for media recovery. It might or might not be archived.