|
[Veritas-bu] RMAN scripts for Oracle RAC for Netbackup 5.1
2005-07-29 15:21:15
|
Subject: |
[Veritas-bu] RMAN scripts for Oracle RAC for Netbackup 5.1 |
|
From: |
jlightner AT water DOT com (Jeff Lightner) |
|
Date: |
Fri, 29 Jul 2005 15:21:15 -0400 |
This is a multi-part message in MIME format.
------_=_NextPart_001_01C59472.B088EE32
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
We are new to RAC and are just setting up RMAN to do it. Our DBA doing
the RMAN side of things has done that but not RAC.
=20
This is on RedHat EL AS 3 (kernel 2.4.2) using ocfs filesystems.
=20
The sample scripts that come with Netbackup don't mention RAC. =20
=20
>From the Netbackup for Oracle Guide I see we should use the virtual name
to do the backup. =20
=20
1) When connecting to the database he is wondering how does he
connect in the script? =20
He is doing first instance then doing second instance for its archive
logs (even though all are on shared OCFS filesystem). That is if DB
name is PROD he is connecting to instance PROD1 and instance PROD2.
Based on the setup of the tnsnames I believe he should just be able to
tell the script to connect to PROD as it has definitions for the virtual
nodes for PROD1 and PROD2.
=20
2) Does anyone have RMAN scripts for netbackup for RACK they'd be
willing to share so we could model from them?
=20
TIA
=20
Jeffrey C. Lightner
Unix Systems Administrator
DS Waters of North America
678-486-3516
=20
------_=_NextPart_001_01C59472.B088EE32
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40";>
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1249148432;
mso-list-type:hybrid;
mso-list-template-ids:-1965944454 67698705 67698713 67698715 67698703 =
67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>We are new to RAC and are just setting up RMAN to do
it. Our DBA doing the RMAN side of things has done that but =
not
RAC.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>This is on RedHat EL AS 3 (kernel 2.4.2) using ocfs =
filesystems.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>The sample scripts that come with Netbackup =
don’t
mention RAC. <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>From the Netbackup for Oracle Guide I see we should =
use the
virtual name to do the backup. <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'margin-left:.5in;text-indent:-.25in;mso-list:l0 level1 =
lfo1'><![if !supportLists]><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'><span
style=3D'mso-list:Ignore'>1)<font size=3D1 face=3D"Times New =
Roman"><span
style=3D'font:7.0pt "Times New =
Roman"'> =
</span></font></span></span></font><![endif]><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>When connecting
to the database he is wondering how does he connect in the script? =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.25in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>He is doing first instance =
then
doing second instance for its archive logs (even though all are on =
shared OCFS
filesystem). That is if DB name is PROD he is connecting to
instance PROD1 and instance PROD2. Based on the setup of the
tnsnames I believe he should just be able to tell the script to connect =
to PROD
as it has definitions for the virtual nodes for PROD1 and =
PROD2.<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.25in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></fo=
nt></p>
<p class=3DMsoNormal =
style=3D'margin-left:.5in;text-indent:-.25in;mso-list:l0 level1 =
lfo1'><![if !supportLists]><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'><span
style=3D'mso-list:Ignore'>2)<font size=3D1 face=3D"Times New =
Roman"><span
style=3D'font:7.0pt "Times New =
Roman"'> =
</span></font></span></span></font><![endif]><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Does anyone have
RMAN scripts for netbackup for RACK they’d be willing to share so =
we
could model from them?<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>TIA<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoAutoSig><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Jeffrey C. Lightner<o:p></o:p></span></font></p>
<p class=3DMsoAutoSig><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Unix Systems Administrator<o:p></o:p></span></font></p>
<p class=3DMsoAutoSig><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>DS Waters of <st1:place w:st=3D"on">North =
America</st1:place><o:p></o:p></span></font></p>
<p class=3DMsoAutoSig><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>678-486-3516<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
------_=_NextPart_001_01C59472.B088EE32--
|
| <Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Veritas-bu] RMAN scripts for Oracle RAC for Netbackup 5.1,
Jeff Lightner <=
|
|
|
