RC_SITE

5.56 RC_SITE

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.