Recovery Catalog Views, 22 of 25

RC_RESYNC

This view lists information about recovery catalog resynchronizations. Every full resynchronization takes a snapshot of the target database control file and resynchronizes the recovery catalog from the snapshot.

Column Datatype NULL Description

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.

RESYNC_KEY

NUMBER

NOT NULL

The primary key for the resynchronization.

CONTROLFILE_CHANGE#

NUMBER

NOT NULL

The control file checkpoint SCN from which the catalog was resynchronized.

CONTROLFILE_TIME

DATE

The control file checkpoint timestamp from which the catalog was resynchronized.

CONTROLFILE_SEQUENCE#

NUMBER

NOT NULL

The control file sequence number.

CONTROLFILE_VERSION

DATE

NOT NULL

The creation time for the version of the control file from which the catalog was resynchronized.

RESYNC_TYPE

VARCHAR2(7)

NOT NULL

The type of resynchronization: FULL or PARTIAL.

DB_STATUS

VARCHAR2(7)

The status of the target database: OPEN or MOUNTED.

RESYNC_TIME

DATE

NOT NULL

The time of the resynchronization.

Column	Datatype	NULL	Description
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.
RESYNC_KEY	NUMBER	NOT NULL	The primary key for the resynchronization.
CONTROLFILE_CHANGE#	NUMBER	NOT NULL	The control file checkpoint SCN from which the catalog was resynchronized.
CONTROLFILE_TIME	DATE		The control file checkpoint timestamp from which the catalog was resynchronized.
CONTROLFILE_SEQUENCE#	NUMBER	NOT NULL	The control file sequence number.
CONTROLFILE_VERSION	DATE	NOT NULL	The creation time for the version of the control file from which the catalog was resynchronized.
RESYNC_TYPE	VARCHAR2(7)	NOT NULL	The type of resynchronization: FULL or PARTIAL.
DB_STATUS	VARCHAR2(7)		The status of the target database: OPEN or MOUNTED.
RESYNC_TIME	DATE	NOT NULL	The time of the resynchronization.