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 all restore points for all incarnations of the database since the last catalog resynchronization. This view corresponds to V$RESTORE_POINT.

Column Data Type Description
DBINC_KEY NUMBER The primary key for the incarnation of the target database. Use this column to join with RC_DATABASE_INCARNATION.
RECID NUMBER The recid of the corresponding row in the control file.
STAMP NUMBER The timestamp of the row in the control file. (Because control file records are reused, you must combine the timestamp and recid to get a value unique across all records in RC_RMAN_STATUS.)
SITE_KEY NUMBER Primary key of the Data Guard database associated with this restore point. Each database in a Data Guard environment has a unique SITE_KEY value. You can use SITE_KEY in a join with the RC_SITE view to obtain the DB_UNIQUE_NAME of the database.
NAME VARCHAR2(128) The name of the restore point.
RESTORE_POINT_TIME DATE The database time associated with the restore point SCN.
CREATION_TIME DATE The date when the restore point was created.
SCN NUMBER The database SCN when the restore point was created
LONG_TERM VARCHAR2(3) YES if the restore point is associated with a backup created with the KEEP option specified; otherwise NO.
PRESERVED VARCHAR2(3) YES if the restore point must be explicitly deleted; otherwise NO.
GUARANTEE_FLASHBACK_DATABASE VARCHAR2(3) YES if the flashback logs must be retained to guarantee a flashback to this point; otherwise NO.