5.47 RC_RESTORE_RANGE

The RC_RESTORE_RANGE view contains details about the restore range of databases registered in the recovery catalog.

Because a database can have multiple restore ranges, this view can contain multiple rows for a single database. This view corresponds to the V$RESTORE_RANGE view.

Column Data Type Description

DB_KEY

NUMBER

The unique database identifier.

SITE_KEY

NUMBER

The primary key of the database site that is associated with this restore range. Each database in a Data Guard environment has a unique SITE_KEY value. You can use the SITE_KEY in join with the RC_SITE view to obtain the DB_UNIQUE_NAME of the database.

LOW_TIME

DATE

The earliest time to which the database can be restored.

HIGH_TIME

DATE

The latest time to which the database can be restored.

LOW_SCN

NUMBER

The lowest SCN to which the database can be restored.

HIGH_SCN

NUMBER

The highest SCN to which the database can be restored.

LOW_DBINC_KEY

NUMBER

The primary key for the incarnation of the database to which LOW_SCN belongs.

HIGH_DBINC_KEY

NUMBER

The primary key for the incarnation of the database to which HIGH_SCN belongs.