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

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

    Cherrish

      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

      run{

      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.

      DELETE FORCE BACKUP COMPLETED BEFORE 'SYSDATE-40'.

       

      DB versions are 11.2.0.2 and 11.2.0.3

      OS: HP UX Itanium 11.31

      MML version HP DataProtector 7 to Tape.

       

      Any help is appreciated.

       

      Thanks

      Cherrish Vaidiyan