I appreciate your help but I have following Oracle's instructions on
cloning databases with RMAN - per their instructions I set NSR_CLIENT to
the oracle host in the script as you can see in the original e-mail. I
have used this script to clone before with success - that is what is
frustrating me.
Once I set the NSR_CLIENT in my script I did not need to also set that
as a param. In my allocate auxiliary channel.
-----Original Message-----
From: Vitalis [mailto:vitalisman_at_gmail.com]=20
Sent: Thursday, April 14, 2005 8:54 AM
To: Stankus, Paula G
Cc: oracle-l_at_freelists.org
Subject: Re: help trying to clone database to remote server
Nope.
I have never worked with NSR but you don't seem to follow what I was
trying to explain: the pointer to the NSR server was correct, the
pointer to the NSR client is not.
I guess you'll have to use something like:
allocate auxiliary channel d1 type 'SBT_TAPE' parms =
'ENV=3D(NSR_CLIENT=3Dthe
production server where the primary database is located)';
Regards,
Jerome
On 4/14/05, Paula_Stankus_at_doh.state.fl.us
<Paula_Stankus_at_doh.state.fl.us> wrote:
> Nope.
>=20
> Even when I do the following I get the same error message:
>=20
> NSR_SERVER=3D3Ddohsbus01;export NSR_SERVER=20
> ORATAB_LOC=3D3D/var/opt/oracle;export ORATAB_LOC $ORACLE_HOME/bin/rman =
> debug msglog /dblogs/backups/dupleprod.txt<< EOD connect rcvcat=20
> $RMANID connect target $TARGET_at_leprod connect auxiliary=20
> user/pass_at_leprod_dup run { allocate auxiliary channel d1 type=20
> 'SBT_TAPE'
> parms 'ENV=3D3D(NSR_SERVER=3D3Dfully qualified backup server =
name)';=3D20
>=20
> -----Original Message-----
> From: Vitalis [mailto:vitalisman_at_gmail.com]=3D20
> 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
>=20
> On 4/13/05, Paula_Stankus_at_doh.state.fl.us=20
> <Paula_Stankus_at_doh.state.fl.us> wrote:
> > =3D3D20
> > I am getting the following error:
> >=3D20
> > RMAN-00571: =3D3D
> > =3D
> =
=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D=
3D3D=3D3D3D=3D3D3D=3D3D3D
> =3D3D=3D =
3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D
> > 3D=3D3D3D=3D3D=3D20
> > =3D
> =
=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D=
3D3D=3D3D3D=3D3D3D=3D3D3D
> =3D3D=3D =
3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D
> > 3D=3D3D3D=3D3D
> > =3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D
> > RMAN-00569: =3D
> =
=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D=
3D3D=3D3D3D=3D3D3D=3D3D3D
> =3D3D=3D
> 3D ERROR=3D20
> > MESSAGE =3D3D STACK FOLLOWS =3D
> =
=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D=
3D3D=3D3D3D=3D3D3D=3D3D3D
> =3D3D=3D
> 3D
> > RMAN-00571: =3D3D
> > =3D
> =
=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D=
3D3D=3D3D3D=3D3D3D=3D3D3D
> =3D3D=3D =
3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D
> > 3D=3D3D3D=3D3D=3D20
> > =3D
> =
=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D=
3D3D=3D3D3D=3D3D3D=3D3D3D
> =3D3D=3D =
3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D
> > 3D=3D3D3D=3D3D
> > =3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D=3D3D3D
> > 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,=3D20 =20
> >handle=3D3D3D"df_LEPROD_s1597_p1_htghnp
> > ds_1_1", parms=3D3D3D""
> > 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=3D20 =20
> >'df_LEPROD_s1597_p1_ ht ghnpds_1_1' on server 'dohsbus01'.
> >=3D20
> > Here is a sample of my script:
> >=3D20
> > BACKS=3D3D3D/usr/oracle/tools/backups;export BACKS . =3D
> /usr/oracle/tools/ids
>=20
> > umask 066;export umask RSCRPT=3D3D3D$BACKS/storscripts;export=20
> > RSCRPT=3D20 #export NLS_LANG=3D3D3DAMERICAN_AMERICA.WE8ISO8859P1
> > NSR_CLIENT=3D3D3Ddohsdb10.test;export NSR_CLIENT=3D20=20
> > NSR_SERVER=3D3D3Ddohsbus01;export NSR_SERVER=3D20=20
> > ORATAB_LOC=3D3D3D/var/opt/oracle;export ORATAB_LOC =3D
> #$ORACLE_HOME/bin/rman=3D20
> > msglog /dblogs/backups/dupleprod.txt<< EOD $ORACLE_HOME/bin/rman=20
> ><<=3D20 EOD connect rcvcat $RMANID connect target=3D20 =20
> >$TARGET_at_leprod.doh.state.fl.us connect auxiliary=3D20 =20
> >$AUX_at_leprod_dup.doh.state.fl.us run { allocate auxiliary channel=20
> >d1=3D20 type 'SBT_TAPE' ; set newname for datafile 1 to=3D20 =20
> >'/u01/oradata/leprod/system01.dbf';
> > set newname for datafile 2 to '/u01/oradata/leprod/undo01.dbf';=20
> >set=3D20 newname for datafile 4 to=20
> >'/u02/oradata/leprod/ax_le_small01.dbf';
> > set newname for datafile 5 to '/u01/oradata/leprod/users01.dbf';
> > set newname for datafile 3 to=20
> >'/u02/oradata/leprod/at_le_small01.dbf';
> > #execute script archive_log_current; #execute script backup_al_all;
> >duplicate target database to leprod =3D20 =20
> >....................................
> > --
> > http://www.freelists.org/webpage/oracle-l
> >=3D20
>=20
> Hi,
>=20
> You need to further configure the auxiliary channel so that it can=20
> access the backup sets created on your NW server for the *production*=20
> node.
>=20
> With your simple
> > allocate auxiliary channel d1 type 'SBT_TAPE' ;
> I guess the default sbt configuration for your test "node" is used,=20
> thus causing NW to look for backup sets that might have been created=20
> for this test "node", and there aren't any.
>=20
> Regards,
> Jerome
>=20
> BEGIN-ANTISPAM-VOTING-LINKS
> ------------------------------------------------------
> Teach CanIt if this mail (ID 29563204) is spam:
> Spam:
> =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Ds&i=3D3D29563204&m=3D=
3D8
> bea=3D
> 90e15
> 64d
> Not spam:
> =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Dn&i=3D3D29563204&m=3D=
3D8
> bea=3D
> 90e15
> 64d
> Forget vote:
> =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Df&i=3D3D29563204&m=3D=
3D8
> bea=3D
> 90e15
> 64d
> ------------------------------------------------------
> END-ANTISPAM-VOTING-LINKS
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>
BEGIN-ANTISPAM-VOTING-LINKS
Teach CanIt if this mail (ID 29577183) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D29577183&m=3Dc99c=
1e587
00c
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D29577183&m=3Dc99c=
1e587
00c
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D29577183&m=3Dc99c=
1e587
00c
END-ANTISPAM-VOTING-LINKS
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 14 2005 - 09:01:22 CDT
