Maintaining RMAN Backups and the Repository - RMAN Recipes for Oracle Database 12c - page 236

How It Works
The list backup command shows all backups and copies from the repository, irrespective of their status. Since you
can use the backups and copies only with the available status, it's a good idea to run the list recoverable backup
command instead when you want to know what usable backups you really do have.
Listing Restore Points
Problem
You want to list all restore points or a specified restore point in the target database.
Solution
Use the list restore point command to view a specific restore point in a database. You can use the all option to
view all the restore points in the database, as shown in the following example:
RMAN> list restore point all;
SCN RSP Time Type Time Name
---------------- --------- ---------- --------- ---------
2210949 21-SEP-12 RESTORE_1
RMAN>
The list restore point all command reports that you have a single restore point named restore_1 that covers
SCN 2210949.
How It Works
You can use the list restore point command to effectively manage any restore points you created in a database.
Any guaranteed restore points will never age out of the control file. You must manually delete a guaranteed
restore point by using the drop restore point command. Oracle retains the 2,048 most recent restore points,
no matter how old they are. In addition, Oracle saves all restore points more recent than the value of the
control_file_record_keep_time initialization parameter. All other normal restore points automatically age out of
the control file eventually.
Listing Database Incarnations
Problem
You want to find out what incarnations of a database are currently recorded in the RMAN repository so you can use
this information during potential restore and recovery operations.