[Veritas-bu] Space on tape
2002-08-08 18:10:28
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_01C23F28.678B2850
Content-Type: text/plain
Nope. We backup our local databases by either splitting BCV (unix-file
backup) or by a "rolling-hot backup" (a scripted walk through the
tablespaces). They both compress just fine at the drive. For the new DB
we're bring online, we'll be using RMAN.
-M
-----Original Message-----
From: Stewart, Phillip R [mailto:pstewa03 AT sprintspectrum DOT com]
Sent: Thursday, August 08, 2002 1:20 PM
To: 'Donaldson, Mark'; Veritasbu (E-mail)
Subject: RE: [Veritas-bu] Space on tape
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_01C23F28.678B2850
Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<TITLE>Space on tape</TITLE>
<META content="MSHTML 6.00.2716.2200" name=GENERATOR>
<STYLE>@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Monotype Corsiva;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY:
"Times New Roman"
}
SPAN.EmailStyle18 {
COLOR: black
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=339450822-08082002><FONT face=Arial color=#0000ff
size=2>Nope. We backup our local databases by either splitting BCV
(unix-file backup) or by a "rolling-hot backup" (a scripted walk through the
tablespaces). They both compress just fine at the drive. For the
new
DB we're bring online, we'll be using RMAN.</FONT></SPAN></DIV>
<DIV><SPAN class=339450822-08082002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=339450822-08082002><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> Stewart, Phillip R
[mailto:pstewa03 AT sprintspectrum DOT com]<BR><B>Sent:</B> Thursday, August
08, 2002
1:20 PM<BR><B>To:</B> 'Donaldson, Mark'; Veritasbu
(E-mail)<BR><B>Subject:</B>
RE: [Veritas-bu] Space on tape<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; 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 face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"></SPAN></FONT> </P>
<DIV>
<P class=MsoNormal><U><FONT face="Monotype Corsiva" color=blue size=5><SPAN
style="FONT-SIZE: 18pt; COLOR: blue; FONT-FAMILY: 'Monotype Corsiva'">Phillip
R. Stewart</SPAN></FONT></U></P>
<P class=MsoNormal><FONT face=Arial color=red size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Arial">Backup and
Recovery</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=red size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Arial">Desk
913.794.7821</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=red size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Arial">PCS
913.226.0137</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"></SPAN></FONT> </P></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; 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: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">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: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">All NB should know about is blocks moved,
right?
The drive is doing the compression. </SPAN></FONT></P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">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: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">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: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">Any other ideas?</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">-M</SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE:
10pt">-----------------------------------------------------------------------</SPAN></FONT>
<BR><FONT size=2><SPAN style="FONT-SIZE: 10pt"> Mark Donaldson -
Sr. Systems Engineer</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt"> Experian - Denver Colorado</SPAN></FONT>
<BR><FONT size=2><SPAN
style="FONT-SIZE:
10pt">-----------------------------------------------------------------------
</SPAN></FONT><BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt"> There are
10 kinds of people in this world, those</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE:
10pt">
that understand binary and those that don't. </SPAN></FONT><BR><FONT
size=2><SPAN
style="FONT-SIZE:
10pt">-----------------------------------------------------------------------</SPAN></FONT>
</P></DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C23F28.678B2850--
|
|
|