Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> RMAN restore and parallelism

RMAN restore and parallelism

From: <chloe.crowder_at_bl.uk>
Date: 20 Mar 2006 09:07:52 -0800
Message-ID: <1142874471.906452.23720@i40g2000cwc.googlegroups.com>


Hi

I'm trying to restore a database using RMAN from our NetBackup server with two tape drive attached. The restore works OK, but looking at the message RMAN returns and the alert log it only seems to be reading from one tape drive at a time. This is a potential problem because the database looks to take 10 hours to restore (roughly 900GB).

This is the rman command I'm using:-

RUN
{ ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
SEND 'NB_ORA_SERV=ils-bcksrv-bk,NB_ORA_CLIENT=ils-datasrv2-bk';

RESTORE DATABASE;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}

and the response look like:-

allocated channel: ch00
channel ch00: sid=13 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2005111306)

allocated channel: ch01
channel ch01: sid=14 devtype=SBT_TAPE
channel ch01: VERITAS NetBackup for Oracle - Release 5.0GA (2005111306)

sent command to channel: ch00
sent command to channel: ch01

Starting restore at 20-MAR-06

channel ch00: starting datafile backupset restore channel ch00: specifying datafile(s) to restore from backup set restoring datafile 00004 to
/exlibris11/oradata/aleph17/aleph17_ts0_01.dbf
restoring datafile 00008 to
/exlibris12/oradata/aleph17/aleph17_tslob_01.dbf
restoring datafile 00189 to
/exlibris12/oradata/aleph17/aleph17_ts4d_60.dbf
restoring datafile 00348 to
/exlibris11/oradata/aleph17/aleph17_gwicks_02.dbf
restoring datafile 00351 to
/exlibris10/oradata/aleph17/aleph17_users_01.dbf
channel ch01: starting datafile backupset restore channel ch01: specifying datafile(s) to restore from backup set restoring datafile 00005 to
/exlibris11/oradata/aleph17/aleph17_ts0_02.dbf
restoring datafile 00010 to
/exlibris11/oradata/aleph17/aleph17_ts1d_01.dbf
restoring datafile 00081 to
/exlibris10/oradata/aleph17/aleph17_ts4x_02.dbf
restoring datafile 00190 to
/exlibris12/oradata/aleph17/aleph17_ts4d_61.dbf
channel ch00: restored backup piece 1
piece handle=bk_u31he4dsr_s97_p1_dALEPH17_t585250715 tag=TAG20060316T173833 para
ms=NULL
channel ch00: restore complete

.
.
.

while the alert log shows:-

Mon Mar 20 09:49:19 2006
Full restore complete of datafile 8 to datafile copy
/exlibris12/oradata/aleph17/aleph17_tslob_01.dbf
  checkpoint is 267005697
Mon Mar 20 09:55:08 2006
Full restore complete of datafile 4 to datafile copy
/exlibris11/oradata/aleph17/aleph17_ts0_01.dbf
  checkpoint is 267005697
Full restore complete of datafile 348 to datafile copy
/exlibris11/oradata/aleph17/aleph17_gwicks_02.dbf
  checkpoint is 267005697
Mon Mar 20 09:58:17 2006
Full restore complete of datafile 189 to datafile copy
/exlibris12/oradata/aleph17/aleph17_ts4d_60.dbf
  checkpoint is 267005697
Full restore complete of datafile 351 to datafile copy
/exlibris10/oradata/aleph17/aleph17_users_01.dbf
  checkpoint is 267005697
Mon Mar 20 10:04:04 2006
Full restore complete of datafile 5 to datafile copy
/exlibris11/oradata/aleph17/aleph17_ts0_02.dbf
  checkpoint is 267005981
Full restore complete of datafile 10 to datafile copy
/exlibris11/oradata/aleph17/aleph17_ts1d_01.dbf
  checkpoint is 267005981
ORACLE9i>>tail -f alert*.log
Mon Mar 20 10:04:04 2006
Full restore complete of datafile 5 to datafile copy
/exlibris11/oradata/aleph17/aleph17_ts0_02.dbf
  checkpoint is 267005981
Full restore complete of datafile 10 to datafile copy
/exlibris11/oradata/aleph17/aleph17_ts1d_01.dbf
  checkpoint is 267005981
Mon Mar 20 10:07:11 2006
Full restore complete of datafile 81 to datafile copy
/exlibris10/oradata/aleph17/aleph17_ts4x_02.dbf
  checkpoint is 267005981
Full restore complete of datafile 190 to datafile copy
/exlibris12/oradata/aleph17/aleph17_ts4d_61.dbf
  checkpoint is 267005981

.
.
.

i.e. it processes the files of channel 00, then channel 01 alterating as it works through the database. Is there a way to get it to write from both tapes simultaenously?

Chloe Crowder
The British Library Received on Mon Mar 20 2006 - 11:07:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US