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
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 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.
##############################################################
