|
[Veritas-bu] Best practise, large oracle databases...
2005-04-27 12:57:58
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_01C54B4A.43CA30FC
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: 7bit
Hmm... That's interesting.
Would like to know
1) What Is the acceptable backup window for this 20TB (I assume it's Data
Warehouse)
2) How long do you take to full backup 20TB DB using Rman?
3) Backup architecture involved to move all the 20TB.
-----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
Mark.Donaldson AT cexp DOT com
Sent: Thursday, April 28, 2005 12:51 AM
To: hampus.lind AT rps.police DOT se; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Best practise, large oracle databases...
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_01C54B4A.43CA30FC
Content-Type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: 7bit
<!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 5.50.4937.800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=933115316-27042005>Hmm...
That's interesting. </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=933115316-27042005>Would
like to know </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=933115316-27042005>1)
What Is the acceptable backup window for this 20TB (I assume it's Data
Warehouse)</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=933115316-27042005>2)
How
long do you take to full backup 20TB DB using Rman? </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=933115316-27042005>3)
Backup architecture involved to move all the 20TB.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=933115316-27042005></SPAN></FONT> </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>Mark.Donaldson AT cexp DOT com<BR><B>Sent:</B> Thursday, April 28, 2005
12:51
AM<BR><B>To:</B> hampus.lind AT rps.police DOT se;
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> RE: [Veritas-bu]
Best
practise, large oracle databases...<BR><BR></FONT></DIV>
<DIV><SPAN class=488174516-27042005><FONT face=Arial color=#0000ff size=2>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. </FONT></SPAN></DIV>
<DIV><SPAN class=488174516-27042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=488174516-27042005><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=488174516-27042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </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. 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> </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> </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> </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> </DIV>
<DIV><FONT face=Arial><FONT size=2>All ideas are
welcome.</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks!!</FONT></DIV>
<DIV> </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> </DIV>
<DIV><FONT face=Arial
size=2></FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C54B4A.43CA30FC--
|
| <Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Veritas-bu] Best practise, large oracle databases..., Hampus Lind
- [Veritas-bu] Best practise, large oracle databases..., yeo-ming.koh AT amd DOT com
- [Veritas-bu] Best practise, large oracle databases..., Mark.Donaldson AT cexp DOT com
- [Veritas-bu] Best practise, large oracle databases...,
yeo-ming.koh AT amd DOT com <=
- [Veritas-bu] Best practise, large oracle databases..., Mark.Donaldson AT cexp DOT com
- [Veritas-bu] Best practise, large oracle databases..., Moses, Darby
|
|
|
