GROUP# |
NUMBER |
Log group number |
THREAD# |
NUMBER |
Log thread number |
SEQUENCE# |
NUMBER |
Log sequence number |
BYTES |
NUMBER |
Size of the log (in bytes) |
BLOCKSIZE |
NUMBER |
Block size of the logfile (512 or 4096) |
MEMBERS |
NUMBER |
Number of members in the log group |
ARCHIVED |
VARCHAR2(3) |
Archive status (YES) or (NO) |
STATUS |
VARCHAR2(16) |
Log status:
-
UNUSED - 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 - Current redo log. This implies that the redo log is active. The redo log could be open or closed.
-
ACTIVE - Log is active but is not the current log. It is needed for crash recovery. It may be in use for block recovery. It may or may not be archived.
-
CLEARING - Log is being re-created as an empty log after an ALTER DATABASE CLEAR LOGFILE statement. After the log is cleared, the status changes to UNUSED.
-
CLEARING_CURRENT - 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 - Log is no longer needed for instance recovery. It may be in use for media recovery. It may or may not be archived.
|
FIRST_CHANGE# |
NUMBER |
Lowest system change number (SCN) in the log |
FIRST_TIME |
DATE |
Time of the first SCN in the log |
NEXT_CHANGE# |
NUMBER |
Highest change number (SCN) in the log. When STATUS=CURRENT, NEXT_CHANGE# is set to the highest possible SCN, 281474976710655. |
NEXT_TIME |
DATE |
Time of the highest SCN in the log. When STATUS=CURRENT, NEXT_TIME is set to NULL. |
