This is a multi-part message in MIME format.
------_=_NextPart_001_01C3877A.4F46BFFE
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Carl,
=20
I have no difficulty to connect to catalog, target and auxiliary =
database using the following script from host1:
rman catalog rman/rman@catdb target sys/syspass@prod_tmp auxiliary =
sys/syspass@prod_dup;
=20
I also verified that the backup set which the restore script is looking =
for is existing by using the following command
#/usr/openv/netbackup/bin/bplist -C host2 -l -t 4 -R /=20
=20
I think the problem lies at NetBackup configuration. I don't know =
whether the two lines from dbclient log below are normal
=20
dbc_GetServerClientConfig: NBU's client name=3D <host2> differs from =
gethostname()=3D <host1>
.....
dbc_GetMediaListByName: Request String =3D <3.4GA host2 host1 *NULL* =
4 1064843658
1065016458 /bk_62_1_506076858>
=20
By the way I can restore to the same host without any problem. Thanks =
for the help.
=20
Wei
=20
=20
=20
-----Original Message-----
From: ckstehman AT pepco DOT com [mailto:ckstehman AT pepco DOT com]
Sent: Tuesday, September 30, 2003 1:19 PM
To: Wei Cao
Cc: veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] unable to restore to alternate client
Try checking the following:=20
1. Insure you can connect to the RMAN catalog database from host1 =
(destination client)=20
2. Set environment variable NBA_ORA_CLIENT=3Dhost2 (Which you have =
done), and ORACLE_SID=20
3. Copy the init.ora file from the source client to the alternate =
(destination client) to the same directory on the destination client=20
4. Be sure all the directories are set up on the destination client and =
match exactly the ones from the source client=20
5. Be sure the directories on the destination client have write =
permission=20
6. Set up a password file for the desination client database=20
7. Start the database in nomount state=20
8. start "rman" on the destination client=20
9. set dbid to the dbid of the source client database from rman set =
dbid=3D<dbid of source database on host2)=20
10 Connect to the target database without using a userid/password=20
11. Run the RMAN restore script=20
bp.conf SERVER=3D<Master server>=20
Check the Oracle System Administrator's guide for Netbackup, there are =
examples in there. We have successfully=20
done an alternate client restore.=20
Hope this helps..=20
=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
Carl Stehman
PHI Services Company
202-331-6619
Pager 301-765-2703
ckstehman AT pepco DOT com=20
"Wei Cao" <wcao AT winants.rutgers DOT edu>=20
Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu=20
09/30/2003 12:07 PM=20
=20
To: <veritas-bu AT mailman.eng.auburn DOT edu>=20
cc: "Wei Cao" <wcao AT winants.rutgers DOT edu>=20
Subject: [Veritas-bu] unable to restore to alternate =
client
Hello All,
I am trying to do an alternate client restore using NetBackup 3.4 with =
Oracle extension without any success. Does anyone know what I am doing =
wrong?
1) login as user oracle do a hot backup on node Host2
2) want to restore the hot backup to host1; host1 is also where the =
NetBackup server is installed.
3) login as user oracle do a restore on node host1, get the following =
message in the dbclient log file:
09:46:44 [27384] <4> dbc_InitializeDBClient: INF - =
client's Debug Level =3D <1>
09:46:44 [27384] <4> dbc_InitializeDBClient: --- SESSION =
INITIATED ---
09:46:44 [27384] <4> getOracleVersion: ORACLE_HOME=3D =
</oracle/oracle805/app/oracle/product/8.1.7>
09:46:44 [27384] <4> dbc_GetServerClientConfig: =
ServerName: <host1>, ClientName: <host2>
09:46:44 [27384] <4> dbc_GetServerClientConfig: NBU's =
client name=3D <host2> differs from gethostname()=3D <host1>
09:46:44 [27384] <4> dbc_GetClassNameFromConfig: user's =
class=3D <ora85>
09:46:44 [27384] <4> get_class: Class <ora85> found in =
configuration
09:46:44 [27384] <4> sbtinit: VERITAS NetBackup for =
Oracle8 - Release 3.4GA (030800)
System name: SunOS
Node name: host1
Release: 5.8
Version: Generic_108528-20
Machine: sun4u
User name: oracle
Group name: dba
Client Host: host1
09:46:44 [27384] <4> sbtinit: support for Proxy Copy =
enabled
09:46:46 [27384] <4> get_bfs_date_range: Start Time =3D =
09/29/03 09:54:18
09:46:46 [27384] <4> get_bfs_date_range: End Time =3D =
10/01/03 09:54:18
09:46:46 [27384] <4> dbc_GetMediaListByName: Request =
String =3D <3.4GA host2 host1 *NULL* 4 1064843658 1065016458 =
/bk_62_1_506076858>
09:46:46 [27384] <2> getsockconnected: host=3Dhost1 =
service=3Dbprd address=3Dhost1 protocol=3Dtcp non-reserved port=3D13720
09:46:47 [27384] <4> find_backup_image: =
bk_62_1_506076858 not found
09:46:47 [27384] <16> sbtrestore: Backup file not found.
09:46:47 [27384] <4> sbtend: --- END of SESSION --- =20
4) bp.conf for user oracle on host2 is as follows:
SERVER =3D host1
CLIENT_NAME =3D host2
BPBACKUP_CLASS =3D ora85
VERBOSE =3D 9 =20
5) bp.conf for user oracle on host1
SERVER =3D host1
CLIENT_NAME =3D host2
BPBACKUP_CLASS =3D ora85
VERBOSE=20
6) bp file in the /usr/openv/netbackup directory
SERVER =3D host1
CLIENT_NAME =3D host2
VERBOSE
CLIENT_READ_TIMEOUT =3D 3600
7) No.Restrictions is in the /usr/openv/netbackup/db/altnames directory
8) NB_ORA_CLIENT is specified in the script as well
allocate auxiliary channel dupt1 type 'sbt_tape' =
parms=3D"ENV=3D(NB_ORA_CLENT=3Dhost2)";
I appreciate any help and ideas. Thank you very much.=20
Wei
=20
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
------_=_NextPart_001_01C3877A.4F46BFFE
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D324282817-30092003><FONT face=3DArial color=3D#0000ff =
size=3D2>Hi=20
Carl,</FONT></SPAN></DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3DArial color=3D#0000ff =
size=3D2>I have=20
no difficulty to connect to catalog, target and auxiliary database using =
the=20
following script from host1:</FONT></SPAN></DIV>
<DIV><SPAN class=3D324282817-30092003> <FONT =
face=3DArial=20
color=3D#0000ff size=3D2>rman catalog <A=20
href=3D"mailto:rman/rman@catdb";>rman/rman@catdb</A> target <A=20
href=3D"mailto:sys/syspass@prod_tmp";>sys/syspass@prod_tmp</A> auxiliary =
<A=20
href=3D"mailto:sys/syspass@prod_dup";>sys/syspass@prod_dup</A>;</FONT></SP=
AN></DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3DArial color=3D#0000ff =
size=3D2>I also=20
verified that the backup set which the restore script is looking for is=20
existing by using the following command</FONT></SPAN></DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3DArial color=3D#0000ff =
size=3D2> #/usr/openv/netbackup/bin/bplist -C host2 -l =
-t 4 -R /=20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D324282817-30092003></SPAN> </DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3DArial color=3D#0000ff =
size=3D2>I=20
think the problem lies at NetBackup =
configuration.</FONT> <FONT=20
face=3DArial color=3D#0000ff size=3D2>I don't know whether the two lines =
from dbclient=20
log below are normal</FONT></SPAN></DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3D"Courier New"=20
size=3D2> dbc_GetServerClientConfig: NBU's client =
name=3D=20
<host2> differs from gethostname()=3D =
<host1></FONT></SPAN></DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3D"Courier New"=20
size=3D2> .....</FONT></SPAN></DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3D"Courier New"=20
size=3D2> dbc_GetMediaListByName: Request String =3D =
<3.4GA=20
host2 host1 *NULL* 4 1064843658</FONT></SPAN></DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3D"Courier New"=20
size=3D2> 1065016458 =
/bk_62_1_506076858></FONT></SPAN></DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3D"Courier New"=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3DArial color=3D#0000ff =
size=3D2>By the=20
way I can restore to the same host without any problem. Thanks for the=20
help.</FONT></SPAN></DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3DArial color=3D#0000ff =
size=3D2>Wei</FONT></SPAN></DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3D"Courier New"=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D324282817-30092003><FONT face=3D"Courier New"=20
size=3D2></FONT> </DIV>
<DIV><BR></DIV></SPAN>
<DIV><SPAN class=3D324282817-30092003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT> </DIV></SPAN>
<BLOCKQUOTE>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> =
ckstehman AT pepco DOT com=20
[mailto:ckstehman AT pepco DOT com]<BR><B>Sent:</B> Tuesday, September 30, =
2003 1:19=20
PM<BR><B>To:</B> Wei Cao<BR><B>Cc:</B>=20
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> Re: [Veritas-bu] =
unable=20
to restore to alternate client<BR><BR></FONT></DIV><BR><FONT =
face=3Dsans-serif=20
size=3D2>Try checking the following:</FONT> <BR><BR><FONT =
face=3Dsans-serif=20
size=3D2>1. Insure you can connect to the RMAN catalog database from =
host1=20
(destination client)</FONT> <BR><FONT face=3Dsans-serif size=3D2>2. =
Set=20
environment variable NBA_ORA_CLIENT=3Dhost2 (Which you have done), and =
ORACLE_SID</FONT> <BR><FONT face=3Dsans-serif size=3D2>3. Copy the =
init.ora file=20
from the source client to the alternate (destination client) to the =
same=20
directory on the destination client</FONT> <BR><FONT face=3Dsans-serif =
size=3D2>4.=20
Be sure all the directories are set up on the destination client and =
match=20
exactly the ones from the source client</FONT> <BR><FONT =
face=3Dsans-serif=20
size=3D2>5. Be sure the directories on the destination client have =
write=20
permission</FONT> <BR><FONT face=3Dsans-serif size=3D2>6. Set up a =
password file=20
for the desination client database</FONT> <BR><FONT face=3Dsans-serif =
size=3D2>7.=20
Start the database in nomount state</FONT> <BR><FONT face=3Dsans-serif =
size=3D2>8.=20
start "rman" on the destination client</FONT> <BR><FONT =
face=3Dsans-serif=20
size=3D2>9. set dbid to the dbid of the source client database from =
rman set=20
dbid=3D<dbid of source database on host2)</FONT> <BR><FONT =
face=3Dsans-serif=20
size=3D2>10 Connect to the target database without using a=20
userid/password</FONT> <BR><FONT face=3Dsans-serif size=3D2>11. Run =
the RMAN=20
restore script</FONT> <BR><BR><FONT face=3Dsans-serif size=3D2>bp.conf =
SERVER=3D<Master server></FONT> <BR><FONT face=3Dsans-serif =
size=3D2>Check the=20
Oracle System Administrator's guide for Netbackup, there are examples =
in=20
there. We have successfully</FONT> <BR><FONT face=3Dsans-serif =
size=3D2>done=20
an alternate client restore.</FONT> <BR><BR><FONT face=3Dsans-serif =
size=3D2>Hope=20
this helps..</FONT> <BR><FONT face=3Dsans-serif=20
=
size=3D2><BR>=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<BR>Carl Stehman<BR>PHI Services=20
Company<BR>202-331-6619<BR>Pager =
301-765-2703<BR>ckstehman AT pepco DOT com</FONT>=20
<BR><BR><BR><BR>
<TABLE width=3D"100%">
<TBODY>
<TR vAlign=3Dtop>
<TD>
<TD><FONT face=3Dsans-serif size=3D1><B>"Wei Cao"=20
<wcao AT winants.rutgers DOT edu></B></FONT> <BR><FONT =
face=3Dsans-serif=20
size=3D1>Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu</FONT>
=
<P><FONT face=3Dsans-serif size=3D1>09/30/2003 12:07 PM</FONT> =
<BR></P>
<TD><FONT face=3DArial size=3D1> =
</FONT><BR><FONT=20
face=3Dsans-serif size=3D1> To: =
=20
<veritas-bu AT mailman.eng.auburn DOT edu></FONT> =
<BR><FONT=20
face=3Dsans-serif size=3D1> cc: =
=20
"Wei Cao" <wcao AT winants.rutgers DOT edu></FONT> =
<BR><FONT=20
face=3Dsans-serif size=3D1> Subject: =
=20
[Veritas-bu] unable to restore to alternate=20
client</FONT></TR></TBODY></TABLE><BR><BR><BR><FONT =
face=3D"Courier New"=20
size=3D2>Hello All,<BR><BR>I am trying to do an alternate client =
restore using=20
NetBackup 3.4 with Oracle extension without any success. Does anyone =
know what=20
I am doing wrong?<BR><BR>1) login as user oracle do a hot backup on =
node=20
Host2<BR>2) want to restore the hot backup to host1; host1 is also =
where the=20
NetBackup server is installed.<BR>3) login as user oracle do a restore =
on node=20
host1, get the following message in the dbclient log =
file:<BR><BR> =20
09:46:44 [27384] =
<4>=20
dbc_InitializeDBClient: INF - client's Debug Level =3D =
<1><BR> =20
09:46:44 [27384] =
<4>=20
dbc_InitializeDBClient: --- SESSION INITIATED ---<BR> =
=20
09:46:44 [27384] <4>=20
getOracleVersion: ORACLE_HOME=3D=20
</oracle/oracle805/app/oracle/product/8.1.7><BR> =
=20
09:46:44 [27384] <4>=20
dbc_GetServerClientConfig: ServerName: <host1>, ClientName:=20
<host2><BR> =
=20
09:46:44 [27384] <4> dbc_GetServerClientConfig: NBU's client =
name=3D=20
<host2> differs from gethostname()=3D <host1><BR> =
=20
09:46:44 [27384] <4>=20
dbc_GetClassNameFromConfig: user's class=3D <ora85><BR> =
=20
09:46:44 [27384] <4>=20
get_class: Class <ora85> found in configuration<BR> =
=20
09:46:44 [27384] <4> sbtinit: =
VERITAS=20
NetBackup for Oracle8 - Release 3.4GA (030800)<BR> =
=20
System name: =
=20
SunOS<BR> =
=20
Node name: host1<BR> =
=20
=
Release:=20
5.8<BR> =
=20
Version: =
=20
Generic_108528-20<BR> =
=20
Machine: =20
sun4u<BR> =
=20
User name: oracle<BR> =
=20
=
Group=20
name: dba<BR> =
=20
Client Host: =20
host1<BR><BR> =
=20
09:46:44 [27384] <4> sbtinit: support for Proxy Copy =
enabled<BR> =20
09:46:46 [27384] =
<4>=20
get_bfs_date_range: Start Time =3D 09/29/03 09:54:18<BR> =
=20
09:46:46 [27384] <4>=20
get_bfs_date_range: End Time =3D 10/01/03 09:54:18<BR> =
=20
09:46:46 [27384] <4>=20
dbc_GetMediaListByName: Request String =3D <3.4GA host2 host1 =
*NULL* 4=20
1064843658 1065016458 /bk_62_1_506076858><BR> =
=20
09:46:46 [27384] <2> =
getsockconnected:=20
host=3Dhost1 service=3Dbprd address=3Dhost1 protocol=3Dtcp =
non-reserved=20
port=3D13720<BR> =
09:46:47=20
[27384] <4> find_backup_image: bk_62_1_506076858 not =
found<BR> =20
09:46:47 [27384] =
<16>=20
sbtrestore: Backup file not found.<BR> =
=20
09:46:47 [27384] <4> sbtend: --- END of =
SESSION ---=20
<BR><BR>4) bp.conf for user oracle on host2 is as=20
follows:<BR><BR> =
SERVER=20
=3D host1<BR> =
CLIENT_NAME=20
=3D host2<BR> =20
BPBACKUP_CLASS =3D ora85<BR> =
=20
VERBOSE =3D 9 <BR><BR>5) bp.conf for user =
oracle on=20
host1<BR><BR> =
SERVER =3D=20
host1<BR> =
CLIENT_NAME =3D=20
host2<BR> =20
BPBACKUP_CLASS =3D ora85<BR> =
=20
VERBOSE <BR><BR>6) bp file in the /usr/openv/netbackup=20
directory<BR><BR> =
=20
SERVER =3D host1<BR> =
=20
CLIENT_NAME =3D host2<BR> =
=20
VERBOSE<BR> =20
CLIENT_READ_TIMEOUT =3D 3600<BR><BR>7) No.Restrictions is in the=20
/usr/openv/netbackup/db/altnames directory<BR><BR>8) NB_ORA_CLIENT is=20
specified in the script as well<BR> =
=20
allocate auxiliary channel dupt1 type 'sbt_tape'=20
parms=3D"ENV=3D(NB_ORA_CLENT=3Dhost2)";<BR><BR>I appreciate any help =
and ideas.=20
Thank you very much.</FONT> <BR><FONT face=3D"Courier New"=20
size=3D2><BR>Wei<BR> =20
<BR><BR>_______________________________________________<BR>Veritas-bu =
maillist=20
-=20
=
Veritas-bu AT mailman.eng.auburn DOT
edu<BR>http://mailman.eng.auburn.edu/=
mailman/listinfo/veritas-bu<BR></FONT><BR><BR><BR></BLOCKQUOTE></BODY></H=
TML>
------_=_NextPart_001_01C3877A.4F46BFFE--
|
