V$LOG_HISTORY displays log history information from the control file.
| Column | Datatype | Description |
|---|---|---|
RECID |
NUMBER |
Control file record ID |
STAMP |
NUMBER |
Control file record stamp |
THREAD# |
NUMBER |
Thread number of the archived log |
SEQUENCE# |
NUMBER |
Sequence number of the archived log |
FIRST_CHANGE# |
NUMBER |
Lowest system change number (SCN) in the log |
FIRST_TIME |
DATE |
Time of the first entry (lowest SCN) in the log |
NEXT_CHANGE# |
NUMBER |
Highest SCN in the log |
RESETLOGS_CHANGE# |
NUMBER |
Resetlogs change number of the database when the log was written |
RESETLOGS_TIME |
DATE |
Resetlogs time of the database when the log was written |