ADSM-L

TDP Oracle backup/restore question

2003-08-21 16:11:39
Subject: TDP Oracle backup/restore question
From: Sambasiva Chebrolu <Sambasiva.Chebrolu AT FIRSTDATACORP DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 21 Aug 2003 14:55:52 -0500
Our environment:
   IBM AIX 4.3.3
   TDP- Oracle 2.2.0
   Oracle Database 8.1.7.4

Question:

We are using Oracle RMAN with Tivoli for our backups. In our RMAN scripts
we defined 5 Channels to use for backups. It takes about one and half hours
to complete the backups.
During the Database recovery process, we are using 5 channels. All the time
only one channel is active restoring files and rest of the channels will be
waiting on the current active channel to complete. It's taking about six to
seven hours for the database restore to complete.

Any one had previous experience with RMAN/Tivoli, waiting for allocating
channels during the restore process?

RMAN backup script:
===================
   run {
   sql 'alter system archive log current';
   allocate channel t1 type 'sbt_tape' parms
   'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
   allocate channel t2 type 'sbt_tape' parms
   'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
   allocate channel t3 type 'sbt_tape' parms
   'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
   allocate channel t4 type 'sbt_tape' parms
   'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
   allocate channel t5 type 'sbt_tape' parms
   'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
       backup tag='UFOM_20030731164207' filesperset 3
       format "dbase%d_%u"
       (database);
       backup current controlfile;
       sql 'alter system archive log current';
       backup filesperset 10 archivelog all delete input ;
       backup current controlfile;
   }

RMAN Restor script:
==================
   run {
         set until logseq 5029 thread 1;
        allocate channel t1 type 'sbt_tape' parms
   'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
        allocate channel t2 type 'sbt_tape' parms
   'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
        allocate channel t3 type 'sbt_tape' parms
   'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
        allocate channel t4 type 'sbt_tape' parms
   'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
        allocate channel t5 type 'sbt_tape' parms
   'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/ufom/tdpo.opt)';
        restore controlfile;
        alter database mount;
        restore database;
        recover database;
        alter database open resetlogs;
        release channel t1;
        release channel t2;
        release channel t3;
        release channel t4;
        release channel t5;
   }


   Thanks,
   Samba Chebrolu,
   Senior Oracle DBA,
   Technical Services
   FDC Enterprise Systems
   402-222-5662

<Prev in Thread] Current Thread [Next in Thread>