2 Replies Latest reply: Aug 30, 2013 10:32 AM by Cherrish RSS

    RMAN 11g - Fastest way to clean up catalog database ?


      Dear friends,


      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


      HOST 'date';

      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;

      HOST 'time';



      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.



      DB versions are and

      OS: HP UX Itanium 11.31

      MML version HP DataProtector 7 to Tape.


      Any help is appreciated.



      Cherrish Vaidiyan