I am trying to clean up our RMAN catalog. We have records since 2008 and our recovery window is set to 60 days. When I did "delete obsolete" it deleted a few records but again when I do 'list backup' I see records from 2008. There are 66242 objects when I do 'crosscheck backup'. Can I get some advice as to how to get rid of the older backups.
Crosschecked 66242 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 60 days
no obsolete backups found
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 60 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backups/xxx_rman/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/oracle/product/10.2.0/dbs/snapcf_xxx.f'; # default
Thanks for the quick response. I could delete based on a date but how come 'delete obsolete' does not delete records older than "recovery window". Is it possible that my last 60 days of backups are not valid for some reason and it needs to keep the older ones? If the old stuff is not in the catalog then when I do 'list backup' where is it showing the older records from?
We take nightly hotbackup on this database.
Apologize for too many questions.... trying to get an understanding of what's happening.
See if you can determine what those older backups are ?
Were they backups taken with a KEEP UNTIL TIME clause (meaning that they cannot be obsoleted until the keep time has elapsed) or KEEP FOREVER ?
Are those backups of a particular tablespace which happens to be excluded from subsequent backups (thus requiring that oracle keep those backups as not obsolete as they would be required to restore that tablespace) ?
Thanks Hemant for the suggestions. None of the backups have KEEP Clause set. And they are all full backups taken nightly. I had opened an SR and Oracle is working on it. Will update the post once I get a resolution.
Could not get a whole lot of help from support but figured out that since we delete the backup files from the disk after nightly backup to tape, When I run a crosscheck backup command, it cannot find enough backups to satisy the recovery window of 60 days. Thus when I run 'delete obsolete' command, it doesn't delete older records. I cleaned up the catalog using 'delete noprompt backupset completed before 'SYSDATE - 100'.