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