Managing Oracle RMAN backups
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.