V$LOG_HISTORY

This view shows the log history from the control file.

Fields

The most relevant view fields are:

• RECID: The control file record ID

• STAMP: The control file record stamp

• THREAD#: The thread number of the archived log

• SEQUENCE#: The sequence number of the archived log

• FIRST_CHANGE#: The lowest system change number in the log

• FIRST_TIME: The time of the first entry in the log

• NEXT_CHANGE#: The highest system change number in the log

• RESETLOGS_CHANGE#: The resetlogs change number of the database when the log was written

• RESETLOGS_TIME: The resetlogs time of the database when the log was written

See also

• The V$LOG and V$LOGFILE sections in this appendix