Oracle9i Recovery Manager Reference
Release 1 (9.0.1)

Part Number A90136-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Recovery Catalog Views, 22 of 26


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  Description 

DB_KEY 

NUMBER 

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

DBINC_KEY 

NUMBER 

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) 

The DB_NAME of the database incarnation to which this record belongs. 

RESYNC_KEY 

NUMBER 

The primary key for the resynchronization. 

CONTROLFILE_CHANGE# 

NUMBER 

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

CONTROLFILE_TIME 

DATE 

The control file checkpoint time stamp from which the catalog was resynchronized. 

CONTROLFILE_SEQUENCE# 

NUMBER 

The control file sequence number. 

CONTROLFILE_VERSION 

DATE 

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

RESYNC_TYPE  

VARCHAR2(7) 

The type of resynchronization: FULL or PARTIAL

DB_STATUS  

VARCHAR2(7) 

The status of the target database: OPEN or MOUNTED

RESYNC_TIME 

DATE 

The time of the resynchronization. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback