This is a multi-part message in MIME format.
------_=_NextPart_001_01C5F9C1.AD7C2775
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I haven't done it but my coworker here has indicated several times that
RMAN isn't good for hot backup of large DBs because it does "stair
stepping" of the tables and takes forever to backup due to this.
Perhaps others on the list have more details of this behavior.
=20
We do use RMAN for some smaller repositories and all the scripts are
done on the RMAN side (in fact the backup is initiated by scripts on the
server rather than Netbackup).
=20
________________________________
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of
steve_swick AT dofasco DOT ca
Sent: Monday, December 05, 2005 11:51 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Large Oracle RMAN DB Backup Question
=20
=20
Backup Gurus: =20
We have a large oracle rman db which is currently over 500 gb. In the
very near future this db is going to grow to 1 TB. We have just
finished testing & began implementing BLIB on this and other large db
backups.
Are any of you able to backup large db's like this to numerous tapes at
the same time. Is this all being setup from the RMAN side of things?
Any ideas, suggestions or things to watch out for would greatly be
appreciated.
TiA....=20
Steve Swick=20
Storage Analyst=20
Dofasco Inc. Box 2460, Hamilton, Ontario, L8N 3J5=20
Phone (905) 548-7200 Ext 3337=20
steve_swick AT dofasco DOT ca=20
_________=20
DOFASCO Our product is steel, Our strength is people.=20
Our home is Hamilton.=20
=20
------_=_NextPart_001_01C5F9C1.AD7C2775
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
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=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Large Oracle RMAN DB Backup Question</title>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"Street"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PostalCode"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"State"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"address"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Small Fonts";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* 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
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@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:158540331;
mso-list-template-ids:-1574265760;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
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 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I haven’t done it but my =
coworker
here has indicated several times that RMAN isn’t good for hot =
backup of
large DBs because it does “stair stepping” of the tables and =
takes
forever to backup due to this. Perhaps others on the list =
have more details
of this behavior.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>We do use RMAN for some smaller
repositories and all the scripts are done on the RMAN side (in fact the =
backup
is initiated by scripts on the server rather than =
Netbackup).<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>
<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>
</span></font></div>
<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'>
veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <b><span =
style=3D'font-weight:
bold'>On Behalf Of </span></b>steve_swick AT dofasco DOT ca<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Monday, December =
05, 2005
11:51 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b>
veritas-bu AT mailman.eng.auburn DOT edu<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> [Veritas-bu] =
Large Oracle
RMAN DB Backup Question</span></font><o:p></o:p></p>
</div>
<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>
<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>
<p><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Backup
Gurus: </span></font><br>
<font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>
We have a large oracle rman db which is currently over 500 gb. In =
the<u>
very near future</u> this db is going to grow to 1 TB. We have =
just
finished testing & began implementing BLIB on this and other large =
db
backups.</span></font><o:p></o:p></p>
<p><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Are
any of you able to backup large db's like this to numerous tapes at the =
same
time. Is this all being setup from the RMAN side of things? =
Any
ideas, suggestions or things to watch out for would greatly be =
appreciated.</span></font><o:p></o:p></p>
<p><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>TiA....</span></font>
<o:p></o:p></p>
<p style=3D'margin-left:1.0in'><i><font size=3D3 face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;font-style:italic'>Steve =
Swick</span></font></i> <br>
<b><font size=3D2><span =
style=3D'font-size:10.0pt;font-weight:bold'>Storage =
Analyst</span></font></b>
<br>
<font size=3D1><span style=3D'font-size:7.5pt'>Dofasco Inc. =
<st1:address
w:st=3D"on"><st1:Street w:st=3D"on">Box 2460</st1:Street>, <st1:City =
w:st=3D"on">Hamilton</st1:City>,
<st1:State w:st=3D"on">Ontario</st1:State>, <st1:PostalCode =
w:st=3D"on">L8N 3J5</st1:PostalCode></st1:address></span></font>
<br>
<font size=3D1><span style=3D'font-size:7.5pt'>Phone (905) 548-7200 Ext =
3337</span></font>
<o:p></o:p></p>
<p style=3D'margin-left:.5in'><font size=3D1 face=3D"Times New =
Roman"><span
style=3D'font-size:7.5pt'>
steve_swick AT dofasco DOT ca</span></font> <o:p></o:p></p>
<p style=3D'margin-left:2.0in'><b><font size=3D1 face=3DTahoma><span
style=3D'font-size:7.5pt;font-family:Tahoma;font-weight:bold'>________</s=
pan></font></b><b><u><font
size=3D1 color=3Dblack face=3D"Small Fonts"><span =
style=3D'font-size:7.5pt;font-family:
"Small Fonts";color:black;font-weight:bold'>_</span></font></u></b> <br>
<b><u><font size=3D1 color=3Dblack face=3D"Small Fonts"><span =
style=3D'font-size:7.5pt;
font-family:"Small =
Fonts";color:black;font-weight:bold'>DOFASCO</span></font></u></b><font
size=3D1 face=3D"Small Fonts"><span =
style=3D'font-size:7.5pt;font-family:"Small Fonts"'>
Our product is steel, Our =
strength
is people.</span></font> <o:p></o:p></p>
<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>
</span></font><font size=3D1
face=3D"Small Fonts"><span style=3D'font-size:7.5pt;font-family:"Small =
Fonts"'>Our
home is <st1:City w:st=3D"on"><st1:place =
w:st=3D"on">Hamilton</st1:place></st1:City>.</span></font>
<o:p></o:p></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_01C5F9C1.AD7C2775--
|
