Skip Headers

Oracle® Database Recovery Manager Reference
10g Release 1 (10.1)

Part Number B10770-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

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. Records about the current and immediately previous incarnation are also contained in 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.

DBID

NUMBER

Unique identifier for the database.

DBINC_KEY

NUMBER

The primary key for the incarnation.

NAME

VARCHAR2(8)

The DB_NAME for the database at the time of the RESETLOGS. The value is UNKNOWN if you have done at least one RESETLOGS before registering the target database with RMAN, because RMAN does not know the DB_NAME prior to the RESETLOGS.

RESETLOGS_CHANGE#

NUMBER

The SCN of the RESETLOGS operation that created this incarnation.

RESETLOGS_TIME

DATE

The time stamp of the RESETLOGS operation that created this incarnation.

CURRENT_INCARNATION

VARCHAR2(8)

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.

PRIOR_RESETLOGS_CHANGE#

NUMBER

The SCN of the RESETLOGS operation that created the parent of this incarnation.

PRIOR_RESETLOGS_TIME

DATE

The time stamp of the RESETLOGS operation that created the parent of this incarnation.