|
[Veritas-bu] Space on tape
2002-08-08 15:19:44
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_01C23F10.3A7EDA36
Content-Type: text/plain
If it is an oracle DB backed up by SQLBacktrack don't count on getting any
more compression. In fact when we backup up oracle we DON'T use any MPX
because it slows down the backup.
Phillip R. Stewart
Backup and Recovery
Desk 913.794.7821
PCS 913.226.0137
-----Original Message-----
From: Donaldson, Mark [mailto:Mark.Donaldson AT experianems DOT com]
Sent: Wednesday, August 07, 2002 5:33 PM
To: Veritasbu (E-mail)
Subject: [Veritas-bu] Space on tape
I'm trying to figure out how may tape blocks are being occupied by a set of
images (we're trying to guess at the compressability of our database and
make inferences to a new one coming online soon).
All NB should know about is blocks moved, right? The drive is doing the
compression.
The only guess I have right now is to do a non-mpx backup to a set of new
tapes, feed the tapes in, then use dd to copy the files to /dev/null and
find out how many blocks are read. Seems like a lot of trouble.
I'm also doing a software compressed backup and finding out how many blocks
are moved that way - it's not apples & oranges but still more like oranges &
lemons - somewhere in the ballpark.
Any other ideas?
-M
-----------------------------------------------------------------------
Mark Donaldson - Sr. Systems Engineer
Experian - Denver Colorado
-----------------------------------------------------------------------
There are 10 kinds of people in this world, those
that understand binary and those that don't.
-----------------------------------------------------------------------
------_=_NextPart_001_01C23F10.3A7EDA36
Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<title>Space on tape</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Monotype Corsiva";
panose-1:3 1 1 1 1 2 1 1 1 1;}
/* 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;}
p
{margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{color:black;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>If it is an oracle DB backed up by
SQLBacktrack
don't count on getting any more compression. In fact when we backup up
oracle we DON'T use any MPX because it slows down the backup.</span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'> </span></font></p>
<div>
<p class=MsoNormal><u><font size=5 color=blue face="Monotype Corsiva"><span
style='font-size:18.0pt;font-family:"Monotype Corsiva";color:blue'>Phillip R.
Stewart</span></font></u></p>
<p class=MsoNormal><font size=2 color=red face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:red'>Backup and Recovery</span></font></p>
<p class=MsoNormal><font size=2 color=red face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:red'>Desk 913.794.7821</span></font></p>
<p class=MsoNormal><font size=2 color=red face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:red'>PCS
913.226.0137</span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'> </span></font></p>
</div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Donaldson, Mark
[mailto:Mark.Donaldson AT experianems DOT com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, August 07, 2002
5:33 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Veritasbu (E-mail)<br>
<b><span style='font-weight:bold'>Subject:</span></b> [Veritas-bu] Space on
tape</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New
Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p style='margin-left:.5in'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>I'm trying to figure out how may tape blocks are being
occupied by a set of images (we're trying to guess at the compressability of
our database and make inferences to a new one coming online
soon).</span></font></p>
<p style='margin-left:.5in'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>All NB should know about is blocks moved, right?
The drive is doing the compression. </span></font></p>
<p style='margin-left:.5in'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>The only guess I have right now is to do a non-mpx
backup to a set of new tapes, feed the tapes in, then use dd to copy the files
to /dev/null and find out how many blocks are read. Seems like a lot of
trouble.</span></font></p>
<p style='margin-left:.5in'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>I'm also doing a software compressed backup and
finding out how many blocks are moved that way - it's not apples & oranges
but still more like oranges & lemons - somewhere in the
ballpark.</span></font></p>
<p style='margin-left:.5in'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>Any other ideas?</span></font> <br>
<font size=2><span style='font-size:10.0pt'>-M</span></font> </p>
<p style='margin-left:.5in'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>-----------------------------------------------------------------------</span></font>
<br>
<font size=2><span style='font-size:10.0pt'> Mark Donaldson - Sr.
Systems Engineer</span></font> <br>
<font size=2><span style='font-size:10.0pt'> Experian - Denver
Colorado</span></font> <br>
<font size=2><span
style='font-size:10.0pt'>-----------------------------------------------------------------------
</span></font><br>
<font size=2><span
style='font-size:10.0pt'>
There are 10 kinds of people in this world, those</span></font> <br>
<font size=2><span
style='font-size:10.0pt'>
that understand binary and those that don't. </span></font><br>
<font size=2><span
style='font-size:10.0pt'>-----------------------------------------------------------------------</span></font>
</p>
</div>
</body>
</html>
------_=_NextPart_001_01C23F10.3A7EDA36--
|
|
|
