Veritas-bu

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

2006-04-12 15:57:48
Subject: [Veritas-bu] setting up Oracle hot backups with Netbackup 5.0MP4 and Oracle 10G
From: pkeating AT bank-banque-canada DOT ca (Paul Keating)
Date: Wed, 12 Apr 2006 15:57:48 -0400
--VM4a.44K52SHnS.Dl+i6.FHb5SE5
MIME-Version: 1.0
Content-Type: multipart/alternative;
        boundary="----_=_NextPart_001_01C65E6B.5F8F7B9F"
content-class: urn:content-classes:message

------_=_NextPart_001_01C65E6B.5F8F7B9F
Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

we're not using solaris 10 either...though it's in the pipe.
=20
thanks for the info.
=20
=20
--=20

        -----Original Message-----
        From: ckstehman AT pepco DOT com [mailto:ckstehman AT pepco DOT com]=20
        Sent: April 12, 2006 12: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
=09
=09
=09

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

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

                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
        =09
        =09
                Hey all.=20
        =09
                I've installed the Netbackup Oracle RMAN agent on a
Solaris server running Oracle 10G.=20
        =09
                everything seems ok so far...followed the instructions
in the SAG for linking Oracle and NBU.=20
        =09
                the problem comes when creating the templates/scripts
for the oracel server.=20
        =09
                any "howto" docs or primers on this?=20
        =09
                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
        =09
                Unable to list template files for (oracle) errmsg:
invalid error number. (at two different points)=20
        =09
                followed by:=20
                ERR -  Unable to save template file for (test.tpl)
Errmsg: socket read failed=20
        =09
                Any ideas?=20
        =09
                Thanks.=20
        =09
                Paul=20


------_=_NextPart_001_01C65E6B.5F8F7B9F
Content-Type: text/html;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><SPAN =
class=3D747065719-12042006>we're=20
not using solaris 10 either...though it's in the =
pipe.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><SPAN=20
class=3D747065719-12042006></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#800000 size=3D2><SPAN =
class=3D747065719-12042006>thanks=20
for the info.</SPAN></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D1>-- </FONT></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #800000 2px =
solid; MARGIN-RIGHT: 0px">
  <DIV></DIV>
  <DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
  face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20
  ckstehman AT pepco DOT com [mailto:ckstehman AT pepco DOT com] 
<BR><B>Sent:</B> =
April 12,=20
  2006 12:56 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=20
  up Oracle hot backups with Netbackup 5.0MP4 and Oracle=20
  10G<BR><BR></FONT></DIV><FONT=20
  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 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=20
  need 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=20
  have 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"=20
  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=20
    Netbackup 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"=20
    size=3D2>everything seems ok so far...followed the instructions in =
the SAG for=20
    linking Oracle and 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=20
    is 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=20
    the 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=20
    to list template files for (oracle) errmsg: invalid error number. =
(at two=20
    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=20
    failed </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
    ideas? </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></BLOCKQUOTE></DIV></FONT></BLOCKQUOTE></BODY></HTML>=

=00
------_=_NextPart_001_01C65E6B.5F8F7B9F--
--VM4a.44K52SHnS.Dl+i6.FHb5SE5
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

=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=C3=A7aise 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 immediat=
ely from
your system and notify the sender promptly by email that you have done so.=20

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

Le pr=C3=A9sent courriel peut contenir de l'information privil=C3=A9gi=C3=
=A9e ou confidentielle.
La Banque du Canada ne renonce pas aux droits qui s'y rapportent. Toute dif=
fusion,
utilisation ou copie de ce courriel ou des renseignements qu'il contient pa=
r une
personne autre que le ou les destinataires d=C3=A9sign=C3=A9s est interdite=
 Si vous recevez
ce courriel par erreur, veuillez le supprimer imm=C3=A9diatement et envoyer=
 sans d=C3=A9lai =C3=A0
l'exp=C3=A9diteur un message =C3=A9lectronique pour l'aviser que vous avez =
=C3=A9limin=C3=A9 de votre
ordinateur toute copie du courriel re=C3=A7u.

--VM4a.44K52SHnS.Dl+i6.FHb5SE5--

<Prev in Thread] Current Thread [Next in Thread>