Databases Reference
In-Depth Information
The following execution of the
report obsolete
command shows that there are both obsolete backup sets and
obsolete backup copies. Again, run the
crosscheck
command before issuing the
report obsolete
command.
RMAN> crosscheck backup;
RMAN> report obsolete;
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Datafile Copy 1 06-AUG-12 /u01/app/oracle/backup/users_ts01.dbf
Control File Copy 5 11-SEP-12 /u01/app/cf_back.ctl
Datafile Copy 6 11-SEP-12 /u01/app/oracle/backup/users01.dbf
Backup Set 152 12-SEP-12
Backup Piece 163 12-SEP-12 /u01/app/oracle/fast_recovery_area/ORCL/
backupset/2012_09_12/o1_mf_nnnd1_TAG20120912T105000_851csrct_.bkp
Backup Set 156 12-SEP-12
Backup Piece 167 12-SEP-12 /u01/app/oracle/fast_recovery_area/ORCL/
backupset/2012_09_12/o1_mf_nnnd1_TAG20120912T105238_851cypr7_.bkp
Backup Set 161 12-SEP-12
Backup Piece 172 12-SEP-12 /u01/app/oracle/fast_recovery_area/ORCL/
backupset/2012_09_12/o1_mf_nnndf_TAG20120912T141028_851qkokn_.bkp
Backup Set 162 12-SEP-12
Backup Piece 173 12-SEP-12 /u01/app/oracle/fast_recovery_area/ORCL/
backupset/2012_09_12/o1_mf_nnndf_TAG20120912T141028_851qkpw2_.bkp
Backup Set 163 12-SEP-12
Backup Piece 174 12-SEP-12 /u01/app/oracle/fast_recovery_area/ORCL/
backupset/2012_09_12/o1_mf_nnndf_TAG20120912T141152_851qms4y_.bkp
Backup Set 168 12-SEP-12
Backup Piece 179 12-SEP-12 /u01/app/oracle/fast_recovery_area/ORCL/
autobackup/2012_09_12/o1_mf_n_793808776_851rgrk4_.bkp
Datafile Copy 9 12-SEP-12 /u01/app/oracle/fast_recovery_area/ORCL/
datafile/o1_mf_cattbs_851rqj92_.dbf
Datafile Copy 10 12-SEP-12 /u01/app/oracle/fast_recovery_area/ORCL/
datafile/o1_mf_example_851rrmdv_.dbf
RMAN>
The
report obsolete
command shows all backups sets, backup pieces, and data file copies that RMAN
considers obsolete since it doesn't need them to meet the specified backup retention policy.
How It Works
As in the case of the
report need backup
command, you must configure a retention policy, or at least not disable
the default retention policy that's preconfigured for you already, for the
report obsolete
command to run without
an error.
