ADSM-L

Re: TDP Oracle backup/restore question

2003-08-21 19:43:56
Subject: Re: TDP Oracle backup/restore question
From: David Longo <David.Longo AT HEALTH-FIRST DOT ORG>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 21 Aug 2003 19:43:13 -0400
Most likely the backed up data is all on one tape, and could therefore
be considered a "single threaded" process (my analogy).

To be able to multiple simultaneous restore sessions, the client
must be sent to a storage pool with collocation, or in the case of
RMAN which is just ONE filespace to TSM server, go directly to
tape - and you must have enough tape drives etc to do this.

Quick answer.



David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH      321.434.5536
Pager  321.634.8230
Fax:    321.434.5509
david.longo AT health-first DOT org


>>> Sambasiva.Chebrolu AT FIRSTDATACORP DOT COM 08/21/03 03:55PM >>>
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

##############################################################
This message is for the named person's use only.  It may 
contain confidential, proprietary, or legally privileged 
information.  No confidentiality or privilege is waived or 
lost by any mistransmission.  If you receive this message 
in error, please immediately delete it and all copies of it 
from your system, destroy any hard copies of it, and notify 
the sender.  You must not, directly or indirectly, use, 
disclose, distribute, print, or copy any part of this message
if you are not the intended recipient.  Health First reserves
the right to monitor all e-mail communications through its
networks.  Any views or opinions expressed in this message
are solely those of the individual sender, except (1) where
the message states such views or opinions are on behalf of 
a particular entity;  and (2) the sender is authorized by 
the entity to give such views or opinions.
##############################################################

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