|
[Veritas-bu] Best practise, large oracle databases...
2005-04-27 15:20:04
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_01C54B5E.1DC9043B
Content-Type: text/plain;
charset="iso-8859-1"
We had to pull the backup off on weekend days so it was more-or-less a 48
hour window. We pulled it off in around 36. It was a NB SSO environment to
LTO-1 tape drives and the Oracle was RAC. We ran 4 streams of data from
each RAC server at a time. It was backing up to an STK L700.
-----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
yeo-ming.koh AT amd DOT com
Sent: Wednesday, April 27, 2005 10:58 AM
To: Mark.Donaldson AT cexp DOT com; hampus.lind AT rps.police DOT se;
veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Best practise, large oracle databases...
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_01C54B5E.1DC9043B
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=465181119-27042005><FONT face=Arial color=#0000ff size=2>We
had
to pull the backup off on weekend days so it was more-or-less a 48 hour
window. We pulled it off in around 36. It was a NB SSO environment
to LTO-1 tape drives and the Oracle was RAC. We ran 4 streams of data
from
each RAC server at a time. It was backing up to an STK
L700.</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>yeo-ming.koh AT amd DOT com<BR><B>Sent:</B> Wednesday, April 27, 2005
10:58
AM<BR><B>To:</B> Mark.Donaldson AT cexp DOT com; 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><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></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C54B5E.1DC9043B--
|
| <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
|
|
|
