I use RMAN for all database backups with HP DataProtector(Tape) as the MML. There is weekly full DB backups, daily DB incremental backup and daily 3 times archive log backup.
Backup Retention Period is 30 days. In HP DataProtector there is no concept as backupset, everything is a backup piece.
Out of all the databases, I took a small DB of size 10G. I ran the below statement and it runs for more than 12 hours and still doesn't finish. I dont see anything much on the Catalog Database. I verified it with Oracle Grid Control.
rman target / catalog oradevcat@rmancat
allocate channel 'dev_0' type 'sbt_tape' parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORADEV,OB2BARLIST=ORADEV)';
delete noprompt obsolete;
Qn/Issue: I am looking for the fastest way to clean up RMAN catalog metadata. Any suggestions ? Recommendations are welcome. The largest DB I have is 4.2 TB with 1800 datafiles. It generates 120-150 archive logs daily.
I also tried running the below and it still runs longer.
DELETE FORCE BACKUP COMPLETED BEFORE 'SYSDATE-40'.
DB versions are 126.96.36.199 and 188.8.131.52
OS: HP UX Itanium 11.31
MML version HP DataProtector 7 to Tape.
Any help is appreciated.