|
DB_KEY |
NUMBER |
NOT NULL |
The primary key for the target database. Use this column to form a join with almost any other catalog view. |
|
DBINC_KEY |
NUMBER |
NOT NULL |
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) |
NOT NULL |
The DB_NAME of the database incarnation to which this record belongs. |
|
RECID |
NUMBER |
NOT NULL |
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 |
NOT NULL |
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 |
NOT NULL |
The thread number of the online redo log. |
|
SEQUENCE# |
NUMBER |
NOT NULL |
The log sequence number of the redo log. |
|
FIRST_CHANGE# |
NUMBER |
NOT NULL |
The SCN generated when switching into the redo log. |
|
FIRST_TIME |
DATE |
NOT NULL |
The timestamp when switching into the redo log. |
|
NEXT_CHANGE# |
NUMBER |
NOT NULL |
The first SCN of the next redo log in the thread. |
|
CLEARED |
VARCHAR2(3) |
|
'?' 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. |
