Veritas-bu

[Veritas-bu] Restricting tapes to a single stream

2006-01-31 11:15:45
Subject: [Veritas-bu] Restricting tapes to a single stream
From: GreenbergKA AT aetna DOT com (Greenberg, Katherine A)
Date: Tue, 31 Jan 2006 11:15:45 -0500
This is a multi-part message in MIME format.

------_=_NextPart_001_01C62681.971AC148
Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

The only way I can conceive of you doing this is to....
=20
1. Set up separate policies for each stream of the database.
2. Set up 3 volume pools.
3. Assign a different volume pool to each policy.
=20
Kind of a lot of work for something you could potentially correct.
=20
=20
-----Original Message-----
From: Jeff Lightner [mailto:jlightner AT water DOT com]=20
Sent: Tuesday, January 31, 2006 10:48 AM
To: Greenberg, Katherine A
Subject: RE: [Veritas-bu] Restricting tapes to a single stream



This is your idea of help?

=20

Why bother with automatic retries at all if I'm going to get up in the
middle of the night to deal with each error.   In point of fact we do
troubleshoot but for whatever reason in 5.1 MP4 the 52s seem to come for
no reason on occasion and the tape will be successfully used later.
Your comment wouldn't solve the question I posed - what if the error
that caused the second try was something other than a 52?

________________________________

From: Greenberg, Katherine A [mailto:GreenbergKA AT aetna DOT com]=20
Sent: Tuesday, January 31, 2006 10:22 AM
To: Jeff Lightner; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Restricting tapes to a single stream

=20

Why don't you try to identify and repair what is causing the 52 errors?

=20

There are a few technotes and fixes for that specific error code, as it
is fairly common.

=20

~Kate

=20

-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of Jeff
Lightner
Sent: Tuesday, January 31, 2006 9:20 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Restricting tapes to a single stream

Is it possible to setup a policy in such a way that any stream will not
use a tape previously used within another stream of the same backup?

Background:

We run our Production DB backup using 3 streams.   This backup is used
for doing refreshes to test and training databases.   On occasion during
the original backup we'll see a status 52 forces one of the streams to
timeout and do a new try which is successful.  Unfortunately the new try
on that stream may occur after one of the other 2 streams has finished
with a tape so it grabs that tape for this stream.   This is OK but on
restore it won't even schedule the 3rd stream until after the stream
that originally used the tape has finished restoring so of course it
causes a long delay in refresh.   I didn't see a setting in the policy
definition so I'm wondering if there is a bp.conf or other setting that
would prevent the use of the same tape within two different streams of
the same backup?

Jeffrey C. Lightner

Unix Systems Administrator

DS Waters of North America

678-486-3516

________________________________

This e-mail may contain confidential or privileged information. If you
think you have received this e-mail in error, please advise the sender
by
reply e-mail and then delete this e-mail immediately. Thank you.
Aetna=20


------_=_NextPart_001_01C62681.971AC148
Content-Type: text/html;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40"; xmlns:v =3D=20
"urn:schemas-microsoft-com:vml" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word" xmlns:st1 =3D=20
"urn:schemas-microsoft-com:office:smarttags"><HEAD><TITLE>Message</TITLE>=

<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1523" name=3DGENERATOR><!--[if !mso]>
<STYLE>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</STYLE>
<![endif]--><o:SmartTagType name=3D"place"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><!--[if !mso]>
<STYLE>
st1\:*{behavior:url(#default#ieooui) }
</STYLE>
<![endif]-->
<STYLE>
<!--
 /* Font Definitions */
 @font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Verdana;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* 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
        {mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman";}
span.EmailStyle19
        {mso-style-type:personal-reply;
        font-family:Arial;
        color:navy;}
@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 vLink=3Dpurple link=3Dblue>
<DIV><SPAN class=3D828251416-31012006><FONT face=3DVerdana size=3D2>The =
only way I can=20
conceive of you doing this is to....</FONT></SPAN></DIV>
<DIV><SPAN class=3D828251416-31012006><FONT face=3DVerdana=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D828251416-31012006><FONT face=3DVerdana size=3D2>1. =
Set up separate=20
policies for each stream of the database.</FONT></SPAN></DIV>
<DIV><SPAN class=3D828251416-31012006><FONT face=3DVerdana size=3D2>2. =
Set up 3 volume=20
pools.</FONT></SPAN></DIV>
<DIV><SPAN class=3D828251416-31012006><FONT face=3DVerdana size=3D2>3. =
Assign a=20
different volume pool to each policy.</FONT></SPAN></DIV>
<DIV><SPAN class=3D828251416-31012006><FONT face=3DVerdana=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D828251416-31012006><FONT face=3DVerdana size=3D2>Kind =
of a lot of=20
work for something you could potentially correct.</FONT></SPAN></DIV>
<DIV><SPAN class=3D828251416-31012006><FONT face=3DVerdana=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D828251416-31012006></SPAN>&nbsp;</DIV>
<DIV></DIV>
<DIV><FONT face=3DTahoma size=3D2>-----Original =
Message-----<BR><B>From:</B> Jeff=20
Lightner [mailto:jlightner AT water DOT com] <BR><B>Sent:</B> Tuesday, January =
31, 2006=20
10:48 AM<BR><B>To:</B> Greenberg, Katherine A<BR><B>Subject:</B> RE:=20
[Veritas-bu] Restricting tapes to a single stream<BR><BR></DIV></FONT>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">This is your =
idea of=20
help?<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Why bother =
with=20
automatic retries at all if I&#8217;m going to get up in the middle of =
the night to=20
deal with each error.&nbsp;&nbsp; In point of fact we do troubleshoot =
but for=20
whatever reason in 5.1 MP4 the 52s seem to come for no reason on =
occasion and=20
the tape will be successfully used later.&nbsp;&nbsp; Your comment =
wouldn&#8217;t=20
solve the question I posed &#8211; what if the error that caused the =
second try was=20
something other than a 52?<o:p></o:p></SPAN></FONT></P>
<DIV>
<DIV class=3DMsoNormal style=3D"TEXT-ALIGN: center" align=3Dcenter><FONT =

face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: 12pt">
<HR tabIndex=3D-1 align=3Dcenter width=3D"100%" SIZE=3D2>
</SPAN></FONT></DIV>
<P class=3DMsoNormal><B><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">From:</SPAN></FONT></B><FONT=20
face=3DTahoma size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">=20
Greenberg, Katherine A [mailto:GreenbergKA AT aetna DOT com] <BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, January 31, 2006 =
10:22=20
AM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B> Jeff Lightner; =

veritas-bu AT mailman.eng.auburn DOT edu<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [Veritas-bu] =
Restricting tapes=20
to a single stream</SPAN></FONT><o:p></o:p></P></DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"><o:p>&nbsp;</o:p></SPAN></FONT></P>
<DIV>
<P class=3DMsoNormal><FONT face=3DVerdana size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana">Why don't you try to =
identify and=20
repair what is causing the 52 errors?</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt">&nbsp;<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DVerdana size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Verdana">There are a few =
technotes and=20
fixes for that specific error code, as it is fairly=20
common.</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt">&nbsp;<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DVerdana size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Verdana">~Kate</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt">&nbsp;<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><FONT face=3DTahoma =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: bold">From:</SPAN></B>=20
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <B><SPAN=20
style=3D"FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Jeff =
Lightner<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, January 31, 2006 =
9:20=20
AM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B>=20
veritas-bu AT mailman.eng.auburn DOT edu<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> [Veritas-bu] Restricting =
tapes to=20
a single stream<o:p></o:p></SPAN></FONT></P></DIV>
<P><FONT face=3DArial size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
FONT-FAMILY: Arial"><!-- Converted from text/rtf format -->Is=20
it possible to setup a policy in such a way that any stream will not use =
a tape=20
previously used within another stream of the same=20
backup?</SPAN></FONT><o:p></o:p></P>
<P><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">Background:</SPAN></FONT><o:p></o:p></P>
<P><FONT face=3DArial size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
FONT-FAMILY: Arial">We=20
run our Production DB backup using 3 streams.&nbsp;&nbsp; This backup is =
used=20
for doing refreshes to test and training databases.&nbsp;&nbsp; On =
occasion=20
during the original backup we&#8217;ll see a status 52 forces one of the =
streams to=20
timeout and do a new try which is successful.&nbsp; Unfortunately the =
new try on=20
that stream may occur after one of the other 2 streams has finished with =
a tape=20
so it grabs that tape for this stream.&nbsp;&nbsp; This is OK but on =
restore it=20
won&#8217;t even schedule the 3<SUP>rd</SUP> stream until after the =
stream that=20
originally used the tape has finished restoring so of course it causes a =
long=20
delay in refresh.&nbsp;&nbsp; I didn&#8217;t see a setting in the policy =
definition so=20
I&#8217;m wondering if there is a bp.conf or other setting that would =
prevent the use=20
of the same tape within two different streams of the same=20
backup?</SPAN></FONT><o:p></o:p></P>
<P><A name=3D""><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt">Jeffrey C. =
Lightner</SPAN></FONT></A><o:p></o:p></P>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">Unix=20
Systems Administrator<o:p></o:p></SPAN></FONT></P>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">DS Waters=20
of <st1:place w:st=3D"on">North =
America</st1:place><o:p></o:p></SPAN></FONT></P>
<P><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt">678-486-3516<o:p></o:p></SPAN></FONT></P>
<DIV class=3DMsoNormal style=3D"TEXT-ALIGN: center" align=3Dcenter><FONT =

face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: 12pt">
<HR align=3Dcenter width=3D"100%" SIZE=3D1>
</SPAN></FONT></DIV>
<P><STRONG><B><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt">This e-mail may contain confidential or =
privileged=20
information. If you</SPAN></FONT></B></STRONG><B><SPAN=20
style=3D"FONT-WEIGHT: bold"><BR><STRONG><B><FONT face=3D"Times New =
Roman">think you=20
have received this e-mail in error, please advise the=20
sender</FONT></B></STRONG><BR><STRONG><B><FONT=20
face=3D"Times New Roman">by</FONT></B></STRONG><BR><STRONG><B><FONT=20
face=3D"Times New Roman">reply e-mail and then delete this e-mail =
immediately.=20
Thank you.</FONT></B></STRONG><BR><st1:place =
w:st=3D"on"><STRONG><B><FONT=20
face=3D"Times New =
Roman">Aetna</FONT></B></STRONG></st1:place><STRONG><B><FONT=20
face=3D"Times New Roman">=20
</FONT></B></STRONG></SPAN></B><o:p></o:p></P></DIV></BODY></HTML>

------_=_NextPart_001_01C62681.971AC148--