Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


DBA_HIST_LOG displays historical log file information from the control file. This view contains snapshots of V$LOG.

Column Datatype NULL Description
DBID NUMBER NOT NULL Database ID for the snapshot
INSTANCE_NUMBER NUMBER NOT NULL Instance number for the snapshot
GROUP# NUMBER NOT NULL Log group number
THREAD# NUMBER NOT NULL Log thread number
SEQUENCE# NUMBER NOT NULL Log sequence number
BYTES NUMBER   Size of the log (in bytes)
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.

  • INVALIDATED - Archived the current redo log without a log switch.

FIRST_CHANGE# NUMBER   Lowest system change number (SCN) in the log
FIRST_TIME DATE   Time of the first SCN in the log