Veritas-bu

[Veritas-bu] Space on tape

2002-08-08 18:10:28
Subject: [Veritas-bu] Space on tape
From: Mark.Donaldson AT experianems DOT com (Donaldson, Mark)
Date: Thu, 8 Aug 2002 16:10:28 -0600
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.&nbsp; We backup our local databases by either splitting BCV 
(unix-file backup) or by a "rolling-hot backup" (a scripted walk through the 
tablespaces).&nbsp; They both compress just fine at the drive.&nbsp; 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>&nbsp;</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.&nbsp; 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>&nbsp;</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&nbsp; 
  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&nbsp;&nbsp; 
  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>&nbsp;</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>&nbsp;</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?&nbsp; 
  The drive is doing the compression.&nbsp; </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.&nbsp; 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 &amp; 
oranges 
  but still more like oranges &amp; 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">&nbsp;&nbsp; Mark Donaldson - 
  Sr. Systems Engineer</SPAN></FONT> <BR><FONT size=2><SPAN 
  style="FONT-SIZE: 10pt">&nbsp;&nbsp; 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">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; There are 
  10 kinds of people in this world, those</SPAN></FONT> <BR><FONT size=2><SPAN 
  style="FONT-SIZE: 
10pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  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--

<Prev in Thread] Current Thread [Next in Thread>