RE: help trying to clone database to remote server

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Thu, 14 Apr 2005 08:33:42 -0400
Message-ID: <E518A02B320C8D4E97D99A8C546480210C3EADD6@dohsmailhq01.doh.ad.state.fl.us>

Nope.

Even when I do the following I get the same error message:

NSR_SERVER=3Ddohsbus01;export NSR_SERVER ORATAB_LOC=3D/var/opt/oracle;export ORATAB_LOC $ORACLE_HOME/bin/rman debug msglog /dblogs/backups/dupleprod.txt<< EOD connect rcvcat $RMANID
connect target $TARGET_at_leprod
connect auxiliary user/pass_at_leprod_dup
run {
allocate auxiliary channel d1 type 'SBT_TAPE' parms 'ENV=3D(NSR_SERVER=3Dfully qualified backup server name)';=20

-----Original Message-----
From: Vitalis [mailto:vitalisman_at_gmail.com]=20 Sent: Thursday, April 14, 2005 3:52 AM
To: Stankus, Paula G
Cc: oracle-l_at_freelists.org
Subject: Re: help trying to clone database to remote server

On 4/13/05, Paula_Stankus_at_doh.state.fl.us <Paula_Stankus_at_doh.state.fl.us> wrote:
> =3D20
> I am getting the following error:

>=20

> RMAN-00571: =3D
> =

=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
> 3D=3D3D=3D=20
> =

=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
> 3D=3D3D=3D
> =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D
> RMAN-00569: =

=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D ERROR=20
> MESSAGE =3D STACK FOLLOWS =

=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D
> RMAN-00571: =3D
> =

=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
> 3D=3D3D=3D=20
> =

=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D= 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
> 3D=3D3D=3D
> =3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D
> 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,=20
> handle=3D3D"df_LEPROD_s1597_p1_htghnp
> ds_1_1", parms=3D3D""
> 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=20
> 'df_LEPROD_s1597_p1_ ht ghnpds_1_1' on server 'dohsbus01'.

>=20

> Here is a sample of my script:

>=20
> BACKS=3D3D/usr/oracle/tools/backups;export BACKS . =
/usr/oracle/tools/ids

> umask 066;export umask RSCRPT=3D3D$BACKS/storscripts;export RSCRPT=20
> #export NLS_LANG=3D3DAMERICAN_AMERICA.WE8ISO8859P1
> NSR_CLIENT=3D3Ddohsdb10.test;export NSR_CLIENT=20
> NSR_SERVER=3D3Ddohsbus01;export NSR_SERVER=20
> ORATAB_LOC=3D3D/var/opt/oracle;export ORATAB_LOC =
#$ORACLE_HOME/bin/rman=20
> msglog /dblogs/backups/dupleprod.txt<< EOD $ORACLE_HOME/bin/rman <<=20
> EOD connect rcvcat $RMANID connect target=20
> $TARGET_at_leprod.doh.state.fl.us connect auxiliary=20
> $AUX_at_leprod_dup.doh.state.fl.us run { allocate auxiliary channel d1=20
> type 'SBT_TAPE' ; set newname for datafile 1 to=20
> '/u01/oradata/leprod/system01.dbf';
> set newname for datafile 2 to '/u01/oradata/leprod/undo01.dbf'; set=20
> 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

>=20


> ....................................

> --
> http://www.freelists.org/webpage/oracle-l
>=20

Hi,

You need to further configure the auxiliary channel so that it can access the backup sets created on your NW server for the *production* node.

With your simple
> allocate auxiliary channel d1 type 'SBT_TAPE' ;
I guess the default sbt configuration for your test "node" is used, thus causing NW to look for backup sets that might have been created for this test "node", and there aren't any.

Regards,
Jerome

BEGIN-ANTISPAM-VOTING-LINKS

---

Teach CanIt if this mail (ID 29563204) is spam: Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D29563204&m=3D8bea= 90e15
64d
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D29563204&m=3D8bea= 90e15
64d
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D29563204&m=3D8bea= 90e15
64d

---

END-ANTISPAM-VOTING-LINKS

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

Received on Thu Apr 14 2005 - 08:37:50 CDT