Every now and again something will go screwy with my automatic RMAN backups and I’ll to find any that are expired or obsolete and delete them manually.
This is how
-- Find and delete expired backups RMAN> CROSSCHECK BACKUP; RMAN> DELETE EXPIRED BACKUP; -- Find and delete obsolete backups RMAN> REPORT OBSOLETE; RMAN> DELETE OBSOLETE;
For more information goto http://www.adp-gmbh.ch/ora/admin/rman/commands.html or check your Oracle documentation.