Database Oracle

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.