Recovery Catalog   «Prev 

Using Report Schema

RMAN Report of Database Schema

To find out which backups are not needed during the recovery process, namely those commands that are beyond the specified retention policy, use this command:
report obsolete  
For this, list backup of the database, show the current retention policy and do two backups of datafile 4:

RMAN> list backup;
 using target database control file instead of recovery catalog
 RMAN> show retention policy;
 RMAN configuration parameters are:
 configure retention policy to redundancy 1; # default
 RMAN> backup datafile 4;
 piece handle=../o1_mf_nnndf_tag20090901t164959_59t2m7n0_.bkp 
 RMAN> backup datafile 4;
 piece handle=../o1_mf_nnndf_tag20090901t165007_59t2mhj3_.bkp

This is the schema of orc1

This is an indication that your client's database has not been backed up for quite some time

This indicates that there are no obsolete backups, which you would expect after viewing the previous screenshot

This shows that all of your client's objects are recoverable