RMAN Crosscheck and DELETE EXPIRED taking a long time for large catalog entries
For our larger databases with many 100's or 1000s of backup pieces the admin operations of RMAN are very slow when interacting with Netbackup. Are there tools on the netbackup side to diagnose this? ...
- Indexing didnt make a difference. Promises of improvements in the move to mysql (?) repository. The real fix for us was to not bother with the crosscheck .. simple tell RMAN that the images are gone rahter then crosscheck and delete expired. With a 90 day netbackup retention, we just run this command. DELETE FORCE BACKUP COMPLETED BEFORE 'SYSDATE-90'; Daryl.
