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_01C23F2D.DAEA1F90
Content-Type: text/plain
FYI, The benefit of RMAN is it doesnt backup the empty blocks so the
compression you would normally achieve with your unix file backup will be
lessened however the volume will also be smaller.
Regards
Peter Marelas
-----Original Message-----
From: Donaldson, Mark [mailto:Mark.Donaldson AT experianems DOT com]
Sent: Friday, 9 August 2002 8:10 AM
To: 'Stewart, Phillip R'; Donaldson, Mark; Veritasbu (E-mail)
Subject: RE: [Veritas-bu] Space on tape
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_01C23F2D.DAEA1F90
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>Message</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=532033922-08082002><FONT face=Arial color=#0000ff size=2>FYI,
The benefit of RMAN is it doesnt backup the empty blocks so the compression you
would normally achieve with your unix file backup will be lessened however the
volume will also be smaller.</FONT></SPAN></DIV>
<DIV><SPAN class=532033922-08082002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=532033922-08082002><FONT face=Arial color=#0000ff
size=2>Regards</FONT></SPAN></DIV>
<DIV><SPAN class=532033922-08082002><FONT face=Arial color=#0000ff size=2>Peter
Marelas</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Donaldson, Mark
[mailto:Mark.Donaldson AT experianems DOT com] <BR><B>Sent:</B> Friday, 9
August 2002
8:10 AM<BR><B>To:</B> 'Stewart, Phillip R'; Donaldson, Mark; Veritasbu
(E-mail)<BR><B>Subject:</B> RE: [Veritas-bu] Space on
tape<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C23F2D.DAEA1F90--
|
