This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C5F9C9.8A1D1E76
Content-Type: text/plain;
charset="iso-8859-1"
My old shop used to backup a 20TB Oracle RAC database using RMAN only. It
took almost 24 hours to do a full but we only did this weekly. Daily
backups were incrementals via RMAN and they were never a significant
problem. It's not entirely problem free, Oracle can spend a lot of time
determining what needs to be backed up for its incremental. The database
servers were media servers, of course.
Another option is to do RMAN fulls of certain table spaces with nightly
incrementals of the other remaining tablespaces. Each night do a full
backup of a different set of tablespaces. This would allow you to roll a
full backup of the entire database across the week rather than pounding the
heck out of it once a week. We talked about this but never implemented due
to its complexity and the fact that our weekends were nearly empty of DB
traffic. It's great on paper, though.
"stair stepping" was never discussed but I don't think the primary DBA's on
this database would've dug that that level, either.
Split mirrors were discussed briefly but were canned due to expense (how
many times do you want to buy 20TB?).
-M
-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]On Behalf Of Jeff
Lightner
Sent: Monday, December 05, 2005 10:31 AM
To: steve_swick AT dofasco DOT ca; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Large Oracle RMAN DB Backup Question
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.
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).
_____
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
Backup Gurus:
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....
Steve Swick
Storage Analyst
Dofasco Inc. Box 2460, Hamilton, Ontario, L8N 3J5
Phone (905) 548-7200 Ext 3337
steve_swick AT dofasco DOT ca
_________
DOFASCO Our product is steel, Our strength is people.
Our home is Hamilton.
------_=_NextPart_001_01C5F9C9.8A1D1E76
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40"; xmlns:v =3D=20
"urn:schemas-microsoft-com:vml" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word" xmlns:st1 =3D=20
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Large Oracle RMAN DB Backup Question</TITLE>
<META content=3D"MSHTML 6.00.2800.1515" name=3DGENERATOR><!--[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]--><o:SmartTagType name=3D"Street"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><o:SmartTagType=20
name=3D"PostalCode"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><o:SmartTagType=20
name=3D"State"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><o:SmartTagType=20
name=3D"address"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><o:SmartTagType=20
name=3D"City"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><o:SmartTagType=20
name=3D"place"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Small Fonts;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; =
}
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
"Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
OL {
MARGIN-BOTTOM: 0in
}
UL {
MARGIN-BOTTOM: 0in
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US vLink=3Dpurple link=3Dblue>
<DIV><SPAN class=3D048262718-05122005><FONT face=3DArial =
color=3D#0000ff size=3D2>My old=20
shop used to backup a 20TB Oracle RAC database using RMAN only. =
It took=20
almost 24 hours to do a full but we only did this weekly. Daily =
backups=20
were incrementals via RMAN and they were never a significant =
problem. It's=20
not entirely problem free, Oracle can spend a lot of time determining =
what needs=20
to be backed up for its incremental. The database servers were =
media=20
servers, of course.</FONT></SPAN></DIV>
<DIV><SPAN class=3D048262718-05122005><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D048262718-05122005><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Another option is to do RMAN fulls of certain table spaces =
with nightly=20
incrementals of the other remaining tablespaces. Each night do a =
full=20
backup of a different set of tablespaces. This would allow you to =
roll a=20
full backup of the entire database across the week rather than pounding =
the heck=20
out of it once a week. We talked about this but never implemented =
due to=20
its complexity and the fact that our weekends were nearly empty of DB=20
traffic. It's great on paper, though.</FONT></SPAN></DIV>
<DIV><SPAN class=3D048262718-05122005><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D048262718-05122005><FONT face=3DArial =
color=3D#0000ff size=3D2>"stair=20
stepping" was never discussed but I don't think the primary DBA's on =
this=20
database would've dug that that level, either.</FONT></SPAN></DIV>
<DIV><SPAN class=3D048262718-05122005><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D048262718-05122005><FONT face=3DArial =
color=3D#0000ff size=3D2>Split=20
mirrors were discussed briefly but were canned due to expense (how many =
times do=20
you want to buy 20TB?).</FONT></SPAN></DIV>
<DIV><SPAN class=3D048262718-05122005><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D048262718-05122005><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>-M</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]<B>On Behalf Of =
</B>Jeff=20
Lightner<BR><B>Sent:</B> Monday, December 05, 2005 10:31 =
AM<BR><B>To:</B>=20
steve_swick AT dofasco DOT ca; =
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B>=20
RE: [Veritas-bu] Large Oracle RMAN DB Backup =
Question<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">I haven't =
done it but=20
my coworker here has indicated several times that RMAN isn't good for =
hot=20
backup of large DBs because it does "stair stepping" of the tables =
and takes=20
forever to backup due to this. Perhaps others on the list =
have=20
more details of this behavior.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">We do use =
RMAN for=20
some smaller repositories and all the scripts are done on the RMAN =
side (in=20
fact the backup is initiated by scripts on the server rather than=20
Netbackup).<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV class=3DMsoNormal style=3D"TEXT-ALIGN: center" =
align=3Dcenter><FONT=20
face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: 12pt">
<HR tabIndex=3D-1 align=3Dcenter width=3D"100%" SIZE=3D2>
</SPAN></FONT></DIV>
<P class=3DMsoNormal><B><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">From:</SPAN></FONT></B><FONT=20
face=3DTahoma size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">=20
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <B><SPAN=20
style=3D"FONT-WEIGHT: bold">On Behalf Of=20
</SPAN></B>steve_swick AT dofasco DOT ca<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, December 05, =
2005 11:51=20
AM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B>=20
veritas-bu AT mailman.eng.auburn DOT edu<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> [Veritas-bu] Large =
Oracle RMAN=20
DB Backup Question</SPAN></FONT><o:p></o:p></P></DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Backup Gurus: =20
</SPAN></FONT><BR><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial"> We have a large =
oracle rman=20
db which is currently over 500 gb. In the<U> very near future</U=
> this=20
db is going to grow to 1 TB. We have just finished testing =
& began=20
implementing BLIB on this and other large db=20
backups.</SPAN></FONT><o:p></o:p></P>
<P><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Are any of you able to =
backup=20
large db's like this to numerous tapes at the same time. Is =
this all=20
being setup from the RMAN side of things? Any ideas, =
suggestions or=20
things to watch out for would greatly be=20
appreciated.</SPAN></FONT><o:p></o:p></P>
<P><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">TiA....</SPAN></FONT>=20
<o:p></o:p></P>
<P style=3D"MARGIN-LEFT: 1in"><I><FONT face=3D"Times New Roman" =
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-STYLE: italic">Steve =
Swick</SPAN></FONT></I>=20
<BR><B><FONT size=3D2><SPAN style=3D"FONT-WEIGHT: bold; FONT-SIZE: =
10pt">Storage=20
Analyst</SPAN></FONT></B> <BR><FONT size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt">Dofasco Inc. <st1:address =
w:st=3D"on"><st1:Street=20
w:st=3D"on">Box 2460</st1:Street>, <st1:City =
w:st=3D"on">Hamilton</st1:City>,=20
<st1:State w:st=3D"on">Ontario</st1:State>, <st1:PostalCode =
w:st=3D"on">L8N=20
3J5</st1:PostalCode></st1:address></SPAN></FONT> <BR><FONT =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt">Phone (905) 548-7200 Ext =
3337</SPAN></FONT>=20
<o:p></o:p></P>
<P style=3D"MARGIN-LEFT: 0.5in"><FONT face=3D"Times New Roman" =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt"> =
steve_swick AT dofasco DOT ca</SPAN></FONT> <o:p></o:p></P>
<P style=3D"MARGIN-LEFT: 2in"><B><FONT face=3DTahoma size=3D1><SPAN=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; FONT-FAMILY: =
Tahoma">________</SPAN></FONT></B><B><U><FONT=20
face=3D"Small Fonts" color=3Dblack size=3D1><SPAN=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; COLOR: black; =
FONT-FAMILY: 'Small Fonts'">_</SPAN></FONT></U></B>=20
<BR><B><U><FONT face=3D"Small Fonts" color=3Dblack size=3D1><SPAN=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; COLOR: black; =
FONT-FAMILY: 'Small Fonts'">DOFASCO</SPAN></FONT></U></B><FONT=20
face=3D"Small Fonts" size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: 'Small Fonts'">=20
Our product is steel, Our =
strength=20
is people.</SPAN></FONT> <o:p></o:p></P>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> =20
=20
=20
</SPAN></FONT><FONT=20
face=3D"Small Fonts" size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: 'Small Fonts'">Our home is =
<st1:City=20
w:st=3D"on"><st1:place =
w:st=3D"on">Hamilton</st1:place></st1:City>.</SPAN></FONT>=20
<o:p></o:p></P>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"><o:p> </o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTM=
L>
------_=_NextPart_001_01C5F9C9.8A1D1E76--
|
