RC_DATABASE

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

Column Data Type Description
DB_KEY NUMBER The primary key for the database. Use this column to join with almost any other catalog view.
DBINC_KEY NUMBER The primary key for the current incarnation. Use this column to 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 RESETLOGS of the current database incarnation.
RESETLOGS_TIME DATE The timestamp of the RESETLOGS of the current database incarnation.
FINAL_CHANGE# NUMBER The highest SCN to which a database can be recovered when using backups and redo logs available on Zero Data Loss Recovery Appliance (Recovery Appliance).

Use this value in the SET UNTIL SCN clause while recovering a database after the loss of all data files and online redo log files.

See Also: Zero Data Loss Recovery Appliance Protected Database Configuration Guide