Veritas-bu

[Veritas-bu] backing up LARGE oracle databases (looking for suggestions)

2005-01-27 11:14:28
Subject: [Veritas-bu] backing up LARGE oracle databases (looking for suggestions)
From: rhaig AT renewdata DOT com (Rob Haig)
Date: Thu, 27 Jan 2005 10:14:28 -0600
This is a multi-part message in MIME format.

------_=_NextPart_001_01C5048B.46DE2587
Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

So I'm trying to wrap my head around this problem.  I'm backing up a 4TB
oracle database with 4 LTO2 drives, connected to the server via 1GB
Ethernet.  That's not that bad of a problem.  RMAN, lvl0 backups twice a
week, plus daily lvl1 backups plus archive logs.  However, when you
throw into the mix that I have 20 of these servers (4TB is the average
DB size, they very from about 200G to 7TB) to back up, it gets more
interesting.  I'll be able to spend money eventually, but not right now.
My eventual plan is a few fully populated SL500 libraries with 4 drives
each.  In the final plan, I'd like to have 8 drives each library and
about 150TB of SAN in between the DB servers and tape drives with
serverless backup from the SAN to tape.  Or, a big honkin' virtual tape
library full of disks that can do serverless backup and has several SAN
connections. =20

=20

But right now, I'm limited to 2, maybe 3, 2-drive LTO2 changers with
enough slots to back up about 8TB of data each before I have to shuffle
out full tapes.  I've been pounding my head on this problem for a few
days now and every time I think I have it sorted out so it's not that
bad, I remember that I have 20 of these databases.

=20

Anyone have any suggestions?

=20

--=20

Rob


------_=_NextPart_001_01C5048B.46DE2587
Content-Type: text/html;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">

<style>
<!--
 /* 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;}
span.EmailStyle17
        {font-family:Arial;
        color:windowtext;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
        {page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>So I&#8217;m trying to wrap my head around this
problem.&nbsp; I&#8217;m backing up a 4TB oracle database with 4 LTO2 =
drives,
connected to the server via 1GB Ethernet.&nbsp; That&#8217;s not that =
bad of a
problem.&nbsp; RMAN, lvl0 backups twice a week, plus daily lvl1 backups =
plus
archive logs.&nbsp; However, when you throw into the mix that I have 20 =
of
these servers (4TB is the average DB size, they very from about 200G to =
7TB) to
back up, it gets more interesting.&nbsp; I&#8217;ll be able to spend =
money
eventually, but not right now.&nbsp; My eventual plan is a few fully =
populated
SL500 libraries with 4 drives each.&nbsp; In the final plan, I&#8217;d =
like to
have 8 drives each library and about 150TB of SAN in between the DB =
servers and
tape drives with serverless backup from the SAN to tape. &nbsp;Or, a big =
honkin&#8217;
virtual tape library full of disks that can do serverless backup and has
several SAN connections.&nbsp; </span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>But right now, I&#8217;m limited to 2, maybe 3, =
2-drive LTO2
changers with enough slots to back up about 8TB of data each before I =
have to
shuffle out full tapes.&nbsp; I&#8217;ve been pounding my head on this =
problem
for a few days now and every time I think I have it sorted out so =
it&#8217;s
not that bad, I remember that I have 20 of these =
databases.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Anyone have any suggestions?</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>-- </span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Rob</span></font></p>

</div>

</body>

</html>
=00
------_=_NextPart_001_01C5048B.46DE2587--