RC_DATABASE

This view gives information about the databases registered in the recovery catalog. It corresponds to the V$DATABASE view.

Column Datatype Description
DB_KEY NUMBER The primary key for the database. Use this column to form a join with almost any other catalog view.
DBINC_KEY NUMBER The primary key for the current incarnation. Use this column to form a join with RC_DATABASE_INCARNATION.
DBID NUMBER Unique identifier for the database obtained from V$DATABASE.
NAME VARCHAR2(8) The DB_NAME of the database for the current incarnation.
RESETLOGS_CHANGE# NUMBER The SCN of the most recent RESETLOGS operation when the record was created.
RESETLOGS_TIME DATE The time stamp of the most recent RESETLOGS operation when the record was created.