Skip Headers
Oracle® Database Backup and Recovery Reference
11g Release 2 (11.2)

Part Number E10643-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


This view lists information about all databases in a Data Guard environment that are known to the recovery catalog. You can use this view to obtain the DB_UNIQUE_NAME value for views which do not have this column.

Column Data Type Description
SITE_KEY NUMBER The unique key of this database. You can join the RC_SITE.SITE_KEY column with the RC_SITE column of other views to determine which DB_UNIQUE_NAME is associated with a backup.
DB_KEY NUMBER The primary key for this database in the recovery catalog. Use this column to join with almost any other catalog view.
DATABASE_ROLE VARCHAR2(7) The role of the database in the Data Guard environment.
CF_CREATE_TIME DATE The creation date of the control file.
DB_UNIQUE_NAME VARCHAR2(30) The DB_UNIQUE_NAME of the database. All databases in a Data Guard environment share the same DBID but different DB_UNIQUE_NAME values.