Recovery Catalog Views, 13 of 25

RC_DATABASE_INCARNATION

This view lists information about all database incarnations registered in the recovery catalog. Oracle creates a new incarnation whenever you open a database with the RESETLOGS option.

Column Datatype NULL Description

DB_KEY

NUMBER

NOT NULL

The primary key for the database. Use this column to form a join with almost any other catalog view.

DBID

NUMBER

NOT NULL

Unique identifier for the database.

DBINC_KEY

NUMBER

NOT NULL

The primary key for the incarnation.

NAME

VARCHAR2(8)

NOT NULL

The DB_NAME for the database at the time of the RESETLOGS operation.

RESETLOGS_CHANGE#

NUMBER

NOT NULL

The SCN of the RESETLOGS operation that created this incarnation.

RESETLOGS_TIME

DATE

NOT NULL

The timestamp of the RESETLOGS operation that created this incarnation.

CURRENT_INCARNATION

VARCHAR2(3)

YES if it is the current incarnation; NO if it is not.

PARENT_DBINC_KEY

NUMBER

The DBINC_KEY of the previous incarnation for this database. The value is NULL if it is the first incarnation recorded for the database.

Column	Datatype	NULL	Description
DB_KEY	NUMBER	NOT NULL	The primary key for the database. Use this column to form a join with almost any other catalog view.
DBID	NUMBER	NOT NULL	Unique identifier for the database.
DBINC_KEY	NUMBER	NOT NULL	The primary key for the incarnation.
NAME	VARCHAR2(8)	NOT NULL	The DB_NAME for the database at the time of the RESETLOGS operation.
RESETLOGS_CHANGE#	NUMBER	NOT NULL	The SCN of the RESETLOGS operation that created this incarnation.
RESETLOGS_TIME	DATE	NOT NULL	The timestamp of the RESETLOGS operation that created this incarnation.
CURRENT_INCARNATION	VARCHAR2(3)		YES if it is the current incarnation; NO if it is not.
PARENT_DBINC_KEY	NUMBER		The DBINC_KEY of the previous incarnation for this database. The value is NULL if it is the first incarnation recorded for the database.