RE: help trying to clone database to remote server

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Wed, 13 Apr 2005 14:56:12 -0400
Message-ID: <E518A02B320C8D4E97D99A8C5464802109BD2804@dohsmailhq01.doh.ad.state.fl.us>

=20

I am getting the following error:

RMAN-00571: =


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-00569: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE = STACK FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-00571: =


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-03002: failure of Duplicate Db command at 04/13/2005 14:50:39 RMAN-03015: error occurred in stored script Memory Script ORA-19507: failed to retrieve sequential file, handle=3D"df_LEPROD_s1597_p1_htghnp
ds_1_1", parms=3D""
ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text:

   nwora_open_restore: Could not locate the NWORA save file 'df_LEPROD_s1597_p1_
ht
ghnpds_1_1' on server 'dohsbus01'.

Here is a sample of my script:

BACKS=3D/usr/oracle/tools/backups;export BACKS . /usr/oracle/tools/ids
umask 066;export umask
RSCRPT=3D$BACKS/storscripts;export RSCRPT #export NLS_LANG=3DAMERICAN_AMERICA.WE8ISO8859P1

NSR_CLIENT=3Ddohsdb10.test;export NSR_CLIENT
NSR_SERVER=3Ddohsbus01;export NSR_SERVER
ORATAB_LOC=3D/var/opt/oracle;export ORATAB_LOC

#$ORACLE_HOME/bin/rman msglog /dblogs/backups/dupleprod.txt<< EOD $ORACLE_HOME/bin/rman << EOD
connect rcvcat $RMANID
connect target $TARGET_at_leprod.doh.state.fl.us connect auxiliary $AUX_at_leprod_dup.doh.state.fl.us run {
allocate auxiliary channel d1 type 'SBT_TAPE' ;

set newname for datafile 1 to '/u01/oradata/leprod/system01.dbf';
set newname for datafile 2 to '/u01/oradata/leprod/undo01.dbf';
set newname for datafile 4 to '/u02/oradata/leprod/ax_le_small01.dbf';
set newname for datafile 5 to '/u01/oradata/leprod/users01.dbf';
set newname for datafile 3 to '/u02/oradata/leprod/at_le_small01.dbf';

#execute script archive_log_current;
#execute script backup_al_all;
duplicate target database to leprod

....................................

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 13 2005 - 15:00:33 CDT