|
DB_KEY
|
NUMBER
|
The primary key for the target database. Use this column to form a join with almost any other catalog view. |
|
DBINC_KEY
|
NUMBER
|
The primary key for the incarnation of the target database. Use this column to form a join with RC_DATABASE_INCARNATION. |
|
DB_NAME
|
VARCHAR2(8)
|
The DB_NAME of the database incarnation to which this record belongs. |
|
RECID
|
NUMBER
|
The redo log history RECID from V$LOG_HISTORY. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. |
|
STAMP
|
NUMBER
|
The redo log history stamp from V$LOG_HISTORY. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. |
|
THREAD#
|
NUMBER
|
The thread number of the online redo log. |
|
SEQUENCE#
|
NUMBER
|
The log sequence number of the redo log. |
|
FIRST_CHANGE#
|
NUMBER
|
The SCN generated when switching into the redo log. |
|
FIRST_TIME
|
DATE
|
The time stamp when switching into the redo log. |
|
NEXT_CHANGE#
|
NUMBER
|
The first SCN of the next redo log in the thread. |
|
CLEARED
|
VARCHAR2(3)
|
YES if the redo log was cleared with the ALTER DATABASE CLEAR LOGFILE statement; otherwise, NULL. This statement allows a log to be dropped without archiving it first.
|
