Veritas-bu

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

2006-04-16 19:33:17
Subject: [Veritas-bu] setting up Oracle hot backups with Netbackup 5.0MP4 and Oracle 10G
From: perf AT peppas DOT gr (Jim Peppas)
Date: Mon, 17 Apr 2006 02:33:17 +0300
This is a multi-part message in MIME format.

------=_NextPart_000_0028_01C661C7.4A9FCA50
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi.
=20
I seem to recall thet you biuld the template on the master server and =
then
use a command on the client to convert the template to a script.
=20
Regards,
Jim

  _____ =20

From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of
ckstehman AT pepco DOT com
Sent: Wednesday, April 12, 2006 7:56 PM
To: Paul Keating
Cc: veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] setting up Oracle hot backups with Netbackup
5.0MP4 and Oracle 10G



We have not upgraded to Solaris 10, however we are backing up Oracle 10G
using RMAN.  We use the template .sh and rcv scripts that are installed =
when
the agent is installed on the client.
=20
The directory is /usr/open/netbakup/ext/oracle/ or some such, you may =
need
to browse around.
=20
We use the Netbackup scheduler to call the .sh script (modified for our
envorinment) which calls othe .rcv script (also modified) which contains =
the
RMAN commands.  This should work unless Solaris 10 has broken this.  We =
have
not tried to use the Wizard to create the scripts.  OR we may have =
awhile
back and quit because they didn't work.
=20
My two cents...
=20
=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
IT Infrastructure Team
Pepco Holdings, Inc.
202-331-6619
Pager 301-765-2703
ckstehman AT pepco DOT com


-----veritas-bu-admin AT mailman.eng.auburn DOT edu wrote: -----



To: <veritas-bu AT mailman.eng.auburn DOT edu>
From: "Paul Keating" <pkeating AT bank-banque-canada DOT ca>
Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu
Date: 04/12/2006 10:05AM
Subject: [Veritas-bu] setting up Oracle hot backups with Netbackup =
5.0MP4
and Oracle 10G


Hey all.=20

I've installed the Netbackup Oracle RMAN agent on a Solaris server =
running
Oracle 10G.=20

everything seems ok so far...followed the instructions in the SAG for
linking Oracle and NBU.=20

the problem comes when creating the templates/scripts for the oracel =
server.


any "howto" docs or primers on this?=20

the DBA is running Backup, Archive and Restore GUI on the Oracle host,
logging in as sysdba using host/os based authentication.=20
When following the wizard to create a template, gets the following =
errors
along the way:=20

Unable to list template files for (oracle) errmsg: invalid error number. =
(at
two different points)=20

followed by:=20
ERR -  Unable to save template file for (test.tpl) Errmsg: socket read
failed=20

Any ideas?=20

Thanks.=20

Paul=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=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

La version fran=E7aise suit le texte anglais.

-------------------------------------------------------------------------=
---
--------

This email may contain privileged and/or confidential information, and =
the
Bank of
Canada does not waive any related rights. Any distribution, use, or =
copying
of this
email or the information it contains by other than the intended =
recipient is
unauthorized. If you received this email in error please delete it
immediately from
your system and notify the sender promptly by email that you have done =
so.=20

-------------------------------------------------------------------------=
---
--------

Le pr=E9sent courriel peut contenir de l'information privil=E9gi=E9e ou
confidentielle.
La Banque du Canada ne renonce pas aux droits qui s'y rapportent. Toute
diffusion,
utilisation ou copie de ce courriel ou des renseignements qu'il contient =
par
une
personne autre que le ou les destinataires d=E9sign=E9s est interdite Si =
vous
recevez
ce courriel par erreur, veuillez le supprimer imm=E9diatement et envoyer =
sans
d=E9lai =E0
l'exp=E9diteur un message =E9lectronique pour l'aviser que vous avez =
=E9limin=E9 de
votre
ordinateur toute copie du courriel re=E7u.





This Email message and any attachment may contain information that is
proprietary, legally privileged, confidential and/or subject to =
copyright
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 =
notified
that any dissemination, distribution or copying of this Email is =
strictly
prohibited. If you have received this message in error, please =
immediately
notify the sender and permanently delete this Email and any copies. PHI
policies expressly prohibit employees from making defamatory or =
offensive
statements and infringing any copyright or any other legal right by =
Email
communication. PHI will not accept any liability in respect of such
communications. _______________________________________________ =
Veritas-bu
maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu=20

------=_NextPart_000_0028_01C661C7.4A9FCA50
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=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2838" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D268233223-16042006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Hi.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D268233223-16042006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D268233223-16042006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>I seem to recall thet you biuld the template on =
the master=20
server and then use a command on the client to convert the template to a =

script.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D268233223-16042006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D268233223-16042006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Regards,</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D268233223-16042006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Jim</FONT></SPAN></DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> =
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <B>On Behalf Of=20
</B>ckstehman AT pepco DOT com<BR><B>Sent:</B> Wednesday, April 12, 2006 7:56=20
PM<BR><B>To:</B> Paul Keating<BR><B>Cc:</B>=20
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> Re: [Veritas-bu] =
setting up=20
Oracle hot backups with Netbackup 5.0MP4 and Oracle =
10G<BR></FONT><BR></DIV>
<DIV></DIV><FONT face=3D"Default Sans =
Serif,Verdana,Arial,Helvetica,sans-serif"=20
size=3D2>
<DIV><BR>
<DIV>We have not upgraded to Solaris 10, however we are backing up =
Oracle 10G=20
using RMAN.&nbsp;&nbsp;We use the template .sh and rcv scripts that are=20
installed when the agent is installed on the client.</DIV>
<DIV>&nbsp;</DIV>
<DIV>The directory is /usr/open/netbakup/ext/oracle/ or some such, you =
may need=20
to browse around.</DIV>
<DIV>&nbsp;</DIV>
<DIV>We use the Netbackup scheduler to call the .sh script (modified for =
our=20
envorinment) which calls othe .rcv script (also modified) which contains =
the=20
RMAN commands.&nbsp; This should work unless Solaris 10 has broken =
this.&nbsp;=20
We have not tried to use the Wizard to create the scripts.&nbsp; OR we =
may have=20
awhile back and quit because they didn't work.</DIV>
<DIV>&nbsp;</DIV>
<DIV>My two 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;Holdings,&nbsp;Inc.<BR>202-331-6619<BR>Pager&nbsp;301=
-765-2703<BR><A=20
href=3D"mailto:ckstehman AT pepco DOT com" =
target=3Dblank>ckstehman AT pepco DOT com</A><BR></DIV>
<DIV><BR></DIV>
<DIV><FONT color=3D#990099>-----veritas-bu-admin AT mailman.eng.auburn DOT edu =
wrote:=20
-----<BR><BR></DIV></FONT>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">To:=20
  &lt;veritas-bu AT mailman.eng.auburn DOT edu&gt;<BR>From: "Paul Keating"=20
  &lt;pkeating AT bank-banque-canada DOT ca&gt;<BR>Sent by:=20
  veritas-bu-admin AT mailman.eng.auburn DOT edu<BR>Date: 04/12/2006=20
  10:05AM<BR>Subject: [Veritas-bu] setting up Oracle hot backups with =
Netbackup=20
  5.0MP4 and Oracle 10G<BR><BR>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" =
size=3D2>Hey all.=20
  </FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif"=20
  size=3D2></FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" =
size=3D2>I've=20
  installed the Netbackup Oracle RMAN agent on a Solaris server running =
Oracle=20
  10G. </FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif"=20
  size=3D2></FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" =
size=3D2>everything=20
  seems ok so far...followed the instructions in the SAG for linking =
Oracle and=20
  NBU. </FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif"=20
  size=3D2></FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" =
size=3D2>the=20
  problem comes when creating the templates/scripts for the oracel =
server.=20
  </FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif"=20
  size=3D2></FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" =
size=3D2>any=20
  "howto" docs or primers on this? </FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif"=20
  size=3D2></FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" =
size=3D2>the DBA is=20
  running Backup, Archive and Restore GUI on the Oracle host, logging in =
as=20
  sysdba using host/os based authentication. </FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" =
size=3D2>When=20
  following the wizard to create a template, gets the following errors =
along the=20
  way: </FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif"=20
  size=3D2></FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" =
size=3D2>Unable to=20
  list template files for (oracle) errmsg: invalid error number. (at two =

  different points) </FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif"=20
  size=3D2></FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" =
size=3D2>followed=20
  by: </FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" =
size=3D2>ERR=20
  -&nbsp; Unable to save template file for (test.tpl) Errmsg: socket =
read failed=20
  </FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif"=20
  size=3D2></FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" =
size=3D2>Any ideas?=20
  </FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif"=20
  size=3D2></FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" =
size=3D2>Thanks.=20
  </FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif"=20
  size=3D2></FONT></SPAN></DIV>
  <DIV><SPAN class=3D138485913-12042006><FONT=20
  face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" =
size=3D2>Paul=20
  </FONT></SPAN></DIV><FONT=20
  face=3D"Default Monospace,Courier New,Courier,monospace"=20
  =
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=20
  version fran=E7aise suit le texte=20
  =
anglais.<BR><BR>---------------------------------------------------------=
---------------------------<BR><BR>This=20
  email may contain privileged and/or confidential information, and the =
Bank=20
  of<BR>Canada does not waive any related rights. Any distribution, use, =
or=20
  copying of this<BR>email or the information it contains by other than =
the=20
  intended recipient is<BR>unauthorized. If you received this email in =
error=20
  please delete it immediately from<BR>your system and notify the sender =

  promptly by email that you have done so.=20
  =
<BR><BR>-----------------------------------------------------------------=
-------------------<BR><BR>Le=20
  pr=E9sent courriel peut contenir de l'information privil=E9gi=E9e ou=20
  confidentielle.<BR>La Banque du Canada ne renonce pas aux droits qui =
s'y=20
  rapportent. Toute diffusion,<BR>utilisation ou copie de ce courriel ou =
des=20
  renseignements qu'il contient par une<BR>personne autre que le ou les=20
  destinataires d=E9sign=E9s est interdite Si vous recevez<BR>ce =
courriel par=20
  erreur, veuillez le supprimer imm=E9diatement et envoyer sans d=E9lai=20
  =E0<BR>l'exp=E9diteur un message =E9lectronique pour l'aviser que vous =
avez =E9limin=E9=20
  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=20
contain information that is proprietary, legally privileged, =
confidential and/or=20
subject to copyright belonging to Pepco Holdings, Inc. or its affiliates =

("PHI"). This Email is intended solely for the use of the person(s) to =
which it=20
is addressed. If you are not an intended recipient, or the employee or =
agent=20
responsible for delivery of this Email to the intended recipient(s), you =
are=20
hereby notified that any dissemination, distribution or copying of this =
Email is=20
strictly prohibited. If you have received this message in error, please=20
immediately notify the sender and permanently delete this Email and any =
copies.=20
PHI policies expressly prohibit employees from making defamatory or =
offensive=20
statements and infringing any copyright or any other legal right by =
Email=20
communication. PHI will not accept any liability in respect of such=20
communications. _______________________________________________ =
Veritas-bu=20
maillist - Veritas-bu AT mailman.eng.auburn DOT edu=20
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu </BODY></HTML>

------=_NextPart_000_0028_01C661C7.4A9FCA50--