[Veritas-bu] Best practise, large oracle databases...

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_01C54B48.7E2071A2
Content-Type: text/plain;
        charset="iso-8859-1"

We used to backup a 20TB database using RMAN.  We did weekly full backups
and daily incrementals with a mid-week cummulative incremental.  All this,
of course, is done via the RMAN commands, not NB.  NB for Oracle is just a
block mover & tracker.  It doesn't care what is in the block, RMAN takes
care of that.  
 
One hard thing was dealing with errors during the backup.  Since a lot can
happen in 20TB of data flow, we had a method to record the start-time of the
first backup attempt, then attempt a point-in-time backup restart using the
"NOT BACKED UP SINCE" rman keywords.  Four attempts were made to backup the
data before we gave up for the evening.
 
Later, we moved to a method where the Full backup would be reattempted each
night until it fully succeeded, utilizing the same NOT BACKED UP SINCE
method where the start time was from a file that recorded the previous
attempt.  During a bad week, we'd often still get enough backup pieces on
tape to make the database restorable.
 
Third mirror split off would've been nice but for large databases there's
two issues, incremental become very difficult so you end up doing a lot of
fulls, and 20TB of "Third-mirror" disk is expensive.
 
-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 Hampus Lind
Sent: Wednesday, April 27, 2005 7:17 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Best practise, large oracle databases...


Hi all!
 
How do you guys and gals perform you large oracle backups?? We have an
incoming oracle db that are about 1.5TB - 2 TB..
We run NBU 5.1 MP2 on hpux 11.11.. Our oracle servers will also be hpux
11.11..
 
All ideas are welcome.
 
Thanks!!
 
MVH / Hampus Lind
Rikspolisstyrelsen
National Police Board
Tele arb: +46 (0)8 - 401 99 43
Tele mob: +46 (0)70 - 217 92 66
E-mail: hampus.lind AT rps.police DOT se <mailto:hampus.lind AT rps.police DOT 
se> 
 
 


------_=_NextPart_001_01C54B48.7E2071A2
Content-Type: text/html;
        charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">


<META content="MSHTML 6.00.2800.1476" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=488174516-27042005><FONT face=Arial color=#0000ff size=2>We 
used to backup a 20TB database using RMAN.&nbsp; We did weekly full backups and 
daily incrementals with a mid-week cummulative 
incremental.&nbsp;&nbsp;All&nbsp;this, of&nbsp;course, is done via the RMAN 
commands, not NB.&nbsp; NB&nbsp;for Oracle is just a block mover &amp; 
tracker.&nbsp; It doesn't care what is in the block, RMAN takes care of 
that.&nbsp; </FONT></SPAN></DIV>
<DIV><SPAN class=488174516-27042005><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=488174516-27042005><FONT face=Arial color=#0000ff size=2>One 
hard thing was dealing with errors during the backup.&nbsp; Since a lot can 
happen in 20TB of data flow, we had a method to record the start-time of the 
first backup attempt, then attempt a point-in-time backup restart using the 
"NOT 
BACKED UP SINCE" rman keywords.&nbsp; Four attempts were made to backup the 
data 
before we gave up for the evening.</FONT></SPAN></DIV>
<DIV><SPAN class=488174516-27042005><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=488174516-27042005><FONT face=Arial color=#0000ff 
size=2>Later, 
we moved to a method where the Full backup would be reattempted each night 
until 
it fully succeeded, utilizing the same NOT BACKED UP SINCE method where the 
start time was from a file that recorded the previous attempt.&nbsp; During a 
bad week, we'd often still get enough backup pieces on tape to make the 
database 
restorable.</FONT></SPAN></DIV>
<DIV><SPAN class=488174516-27042005><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=488174516-27042005><FONT face=Arial color=#0000ff size=2>Third 
mirror split off would've been nice but for large databases there's two issues, 
incremental become very difficult so you end up doing a lot of fulls, and 20TB 
of "Third-mirror" disk is expensive.</FONT></SPAN></DIV>
<DIV><SPAN class=488174516-27042005><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=488174516-27042005><FONT face=Arial color=#0000ff 
size=2>-M</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma 
  size=2>-----Original Message-----<BR><B>From:</B> 
  veritas-bu-admin AT mailman.eng.auburn DOT edu 
  [mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]<B>On Behalf Of 
</B>Hampus 
  Lind<BR><B>Sent:</B> Wednesday, April 27, 2005 7:17 AM<BR><B>To:</B> 
  veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> [Veritas-bu] Best 
  practise, large oracle databases...<BR><BR></FONT></DIV>
  <DIV><FONT face=Arial size=2>Hi all!</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>How do you guys and gals perform you large 
oracle 
  backups?? We have an incoming oracle db that are about 1.5TB - 2 
  TB..</FONT></DIV>
  <DIV><FONT face=Arial size=2>We run NBU 5.1 MP2 on hpux 11.11.. Our oracle 
  servers will also be hpux 11.11..</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial><FONT size=2>All ideas are welcome.</FONT></FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>Thanks!!</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>MVH / Hampus 
  Lind<BR>Rikspolisstyrelsen<BR>National Police Board<BR>Tele arb: +46 (0)8 - 
  401 99 43<BR>Tele mob: +46 (0)70 - 217 92 66<BR>E-mail: <A 
  href="mailto:hampus.lind AT rps.police DOT se">hampus.lind AT rps.police DOT 
se</A></FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C54B48.7E2071A2--