Veritas-bu

[Veritas-bu] setting up Oracle hot backups with Netbackup 5.0MP4 and Oracle 10G

2006-04-12 12:55:37
Subject: [Veritas-bu] setting up Oracle hot backups with Netbackup 5.0MP4 and Oracle 10G
From: ckstehman AT pepco DOT com (ckstehman AT pepco DOT com)
Date: Wed, 12 Apr 2006 12:55:37 -0400
<FONT face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=
=3D2><DIV><BR><DIV>We have not upgraded to Solaris 10, however we are backi=
ng up Oracle 10G using RMAN.&nbsp;&nbsp;We use the template .sh and rcv scr=
ipts that are installed when the agent is installed on the client.</DIV><DI=
V>&nbsp;</DIV><DIV>The directory is /usr/open/netbakup/ext/oracle/ or some =
such, you may need to browse around.</DIV><DIV>&nbsp;</DIV><DIV>We use the =
Netbackup scheduler to call the .sh script (modified for our envorinment) w=
hich calls othe .rcv script (also modified) which contains the RMAN command=
s.&nbsp; This should work unless Solaris 10 has broken this.&nbsp; We have =
not tried to use the Wizard to create the scripts.&nbsp; OR we may have awh=
ile back and quit because they didn't work.</DIV><DIV>&nbsp;</DIV><DIV>My t=
wo cents...</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV><DIV><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&nbsp;Stehman<BR>IT&nbsp;Infrastructure&nbsp;Team<BR>Pepco&nbsp;Holdin=
gs,&nbsp;Inc.<BR>202-331-6619<BR>Pager&nbsp;301-765-2703<BR><A href=3D"mail=
to:ckstehman AT pepco DOT com" target=3Dblank >ckstehman AT pepco DOT 
com</A><BR></DIV><D=
IV><BR></DIV><DIV><FONT color=3D#990099>-----veritas-bu-admin AT mailman DOT 
eng.a=
uburn.edu wrote: -----<BR><BR></DIV></FONT><blockquote style=3D"PADDING-RIG=
HT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px soli=
d; MARGIN-RIGHT: 0px">To: &lt;veritas-bu AT mailman.eng.auburn DOT 
edu&gt;<BR>From=
: "Paul Keating" &lt;pkeating AT bank-banque-canada DOT ca&gt;<BR>Sent by: 
veritas=
-bu-admin AT mailman.eng.auburn DOT edu<BR>Date: 04/12/2006 10:05AM<BR>Subject: 
[V=
eritas-bu] setting up Oracle hot backups with Netbackup 5.0MP4 and Oracle 1=
0G<BR><BR><DIV><SPAN class=3D138485913-12042006><FONT face=3D"Default Sans =
Serif,Verdana,Arial,Helvetica,sans-serif" size=3D2  >Hey all. </FONT></SPAN=
></DIV><DIV><SPAN class=3D138485913-12042006><FONT face=3D"Default Sans Ser=
if,Verdana,Arial,Helvetica,sans-serif" size=3D2  ></FONT></SPAN> </DIV><DIV=
><SPAN class=3D138485913-12042006><FONT face=3D"Default Sans Serif,Verdana,=
Arial,Helvetica,sans-serif" size=3D2  >I've installed the Netbackup Oracle =
RMAN agent on a Solaris server running Oracle 10G. </FONT></SPAN></DIV><DIV=
><SPAN class=3D138485913-12042006><FONT face=3D"Default Sans Serif,Verdana,=
Arial,Helvetica,sans-serif" size=3D2  ></FONT></SPAN> </DIV><DIV><SPAN clas=
s=3D138485913-12042006><FONT face=3D"Default Sans Serif,Verdana,Arial,Helve=
tica,sans-serif" size=3D2  >everything seems ok so far...followed the instr=
uctions in the SAG for linking Oracle and NBU. </FONT></SPAN></DIV><DIV><SP=
AN class=3D138485913-12042006><FONT face=3D"Default Sans Serif,Verdana,Aria=
l,Helvetica,sans-serif" size=3D2  ></FONT></SPAN> </DIV><DIV><SPAN class=3D=
138485913-12042006><FONT face=3D"Default Sans Serif,Verdana,Arial,Helvetica=
,sans-serif" size=3D2  >the problem comes when creating the templates/scrip=
ts for the oracel server. </FONT></SPAN></DIV><DIV><SPAN class=3D138485913-=
12042006><FONT face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-seri=
f" size=3D2  ></FONT></SPAN> </DIV><DIV><SPAN class=3D138485913-12042006><F=
ONT face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=3D2=
  >any "howto" docs or primers on this? </FONT></SPAN></DIV><DIV><SPAN clas=
s=3D138485913-12042006><FONT face=3D"Default Sans Serif,Verdana,Arial,Helve=
tica,sans-serif" size=3D2  ></FONT></SPAN> </DIV><DIV><SPAN class=3D1384859=
13-12042006><FONT face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-s=
erif" size=3D2  >the DBA is running Backup, Archive and Restore GUI on the =
Oracle host, logging in as sysdba using host/os based authentication. </FON=
T></SPAN></DIV><DIV><SPAN class=3D138485913-12042006><FONT face=3D"Default =
Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=3D2  >When following th=
e wizard to create a template, gets the following errors along the way: </F=
ONT></SPAN></DIV><DIV><SPAN class=3D138485913-12042006><FONT face=3D"Defaul=
t Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=3D2  ></FONT></SPAN> =
</DIV><DIV><SPAN class=3D138485913-12042006><FONT face=3D"Default Sans Seri=
f,Verdana,Arial,Helvetica,sans-serif" size=3D2  >Unable to list template fi=
les for (oracle) errmsg: invalid error number. (at two different points) </=
FONT></SPAN></DIV><DIV><SPAN class=3D138485913-12042006><FONT face=3D"Defau=
lt Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=3D2  ></FONT></SPAN>=
 </DIV><DIV><SPAN class=3D138485913-12042006><FONT face=3D"Default Sans Ser=
if,Verdana,Arial,Helvetica,sans-serif" size=3D2  >followed by: </FONT></SPA=
N></DIV><DIV><SPAN class=3D138485913-12042006><FONT face=3D"Default Sans Se=
rif,Verdana,Arial,Helvetica,sans-serif" size=3D2  >ERR -&nbsp; Unable to sa=
ve template file for (test.tpl) Errmsg: socket read failed </FONT></SPAN></=
DIV><DIV><SPAN class=3D138485913-12042006><FONT face=3D"Default Sans Serif,=
Verdana,Arial,Helvetica,sans-serif" size=3D2  ></FONT></SPAN> </DIV><DIV><S=
PAN class=3D138485913-12042006><FONT face=3D"Default Sans Serif,Verdana,Ari=
al,Helvetica,sans-serif" size=3D2  >Any ideas? </FONT></SPAN></DIV><DIV><SP=
AN class=3D138485913-12042006><FONT face=3D"Default Sans Serif,Verdana,Aria=
l,Helvetica,sans-serif" size=3D2  ></FONT></SPAN> </DIV><DIV><SPAN class=3D=
138485913-12042006><FONT face=3D"Default Sans Serif,Verdana,Arial,Helvetica=
,sans-serif" size=3D2  >Thanks. </FONT></SPAN></DIV><DIV><SPAN class=3D1384=
85913-12042006><FONT face=3D"Default Sans Serif,Verdana,Arial,Helvetica,san=
s-serif" size=3D2  ></FONT></SPAN> </DIV><DIV><SPAN class=3D138485913-12042=
006><FONT face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" si=
ze=3D2  >Paul </FONT></SPAN></DIV><FONT face=3D"Default Monospace,Courier N=
ew,Courier,monospace" size=3D2  >=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=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><BR>La vers=
ion fran=E7aise suit le texte anglais.<BR><BR>-----------------------------=
-------------------------------------------------------<BR><BR>This email m=
ay contain privileged and/or confidential information, and the Bank of<BR>C=
anada does not waive any related rights. Any distribution, use, or copying =
of this<BR>email or the information it contains by other than the intended =
recipient is<BR>unauthorized. If you received this email in error please de=
lete it immediately from<BR>your system and notify the sender promptly by e=
mail that you have done so. <BR><BR>---------------------------------------=
---------------------------------------------<BR><BR>Le pr=E9sent courriel =
peut contenir de l'information privil=E9gi=E9e ou confidentielle.<BR>La Ban=
que du Canada ne renonce pas aux droits qui s'y rapportent. Toute diffusion=
,<BR>utilisation ou copie de ce courriel ou des renseignements qu'il contie=
nt par une<BR>personne autre que le ou les destinataires d=E9sign=E9s est i=
nterdite Si vous recevez<BR>ce courriel par erreur, veuillez le supprimer i=
mm=E9diatement et envoyer sans d=E9lai =E0<BR>l'exp=E9diteur un message =E9=
lectronique pour l'aviser que vous avez =E9limin=E9 de votre<BR>ordinateur =
toute copie du courriel re=E7u.<BR></FONT></blockquote><DIV><br></DIV></DIV=
></FONT>
<br><br>This Email message and any attachment may contain information that =
is proprietary, legally privileged, confidential and/or subject to copyrigh=
t belonging to Pepco Holdings, Inc. or its affiliates ("PHI").  This Email =
is intended solely for the use of the person(s) to which it is addressed.  =
If you are not an intended recipient, or the employee or agent responsible =
for delivery of this Email to the intended recipient(s), you are hereby not=
ified that any dissemination, distribution or copying of this Email is stri=
ctly prohibited.  If you have received this message in error, please immedi=
ately notify the sender and permanently delete this Email and any copies.  =
PHI policies expressly prohibit employees from making defamatory or offensi=
ve statements and infringing any copyright or any other legal right by Emai=
l communication.  PHI will not accept any liability in respect of such comm=
unications.