This view lists all restore points for all incarnations of the database since the last catalog resynchronization. This view corresponds to V$RESTORE_POINT.
The primary key for the incarnation of the target database. Use this column to join with RC_DATABASE_INCARNATION.
The recid of the corresponding row in the control file.
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.)
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.
The name of the restore point.
The database time associated with the restore point SCN.
The date when the restore point was created.
The database SCN when the restore point was created
YES if the restore point is associated with a backup created with the KEEP option specified; otherwise NO.
YES if the restore point must be explicitly deleted; otherwise NO.
YES if the flashback logs must be retained to guarantee a flashback to this point; otherwise NO.