My question is what is the best way to delete all expired backups and flag the repository without the use of change backupset xxxx delete?
Once a backup set has been marked as expired, you can use the DELETE EXPIRED command to remove these backups from your Recovery Catalog.
Upgrading to Oracle 9i or 10g will help you even more as you can define a retention period within RMAN and have RMAN automatically purge expired backup sets. Until you upgrade, you will have to handle this yourself as outlined above.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading