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 Datatype 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.