Recovery Catalog Views, 9 of 25

RC_CHECKPOINT

This view lists recovery catalog resynchronization information. It does not give information about database checkpoints. In most cases, you should use the RC_RESYNC view instead.

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.

CKP_KEY

NUMBER

NOT NULL

The primary key for the checkpoint.

CKP_SCN

NUMBER

NOT NULL

The control file checkpoint SCN.

CKP_CF_SEQ

NUMBER

NOT NULL

The control file sequence number.

CKP_TIME

DATE

The time at which the catalog was checkpointed.

CKP_TYPE

VARCHAR2(7)

NOT NULL

The type of catalog resynchronization: FULL or PARTIAL.

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.
CKP_KEY	NUMBER	NOT NULL	The primary key for the checkpoint.
CKP_SCN	NUMBER	NOT NULL	The control file checkpoint SCN.
CKP_CF_SEQ	NUMBER	NOT NULL	The control file sequence number.
CKP_TIME	DATE		The time at which the catalog was checkpointed.
CKP_TYPE	VARCHAR2(7)	NOT NULL	The type of catalog resynchronization: FULL or PARTIAL.