allknowing
12 years agoLevel 3
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? We have verified with Oracle that RMAN catalog is not the issue. Its taking nearly 15minutes per delete backup piece operation. Any thoughts on this?
Is there an index or catalog operation for the media server catalogs that we should have the netbackup admins perform?
Thanks for your help.
- 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.