This is a multi-part message in MIME format.
------_=_NextPart_001_01C4F511.B79F67E2
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello Jennifer, I bet you didn't count on all these responses to your
question!
=20
Let me tell you from experience, managing excludes on Windows servers is
not a fun task. It can easily eat up a FTE a week, maybe more depending
upon the number of boxes you have. I think many people (management) do
not understand exactly what a 1 is. To me, a RC1 is a good backup, but
not all files were backed up completely. That doesn't mean that the
files that show up as in use were not backed up, just that they were not
backed up fully. As some one has already mentioned, something is better
than nothing. Someone please correct me if I'm wrong in my thinking. I
just did a little test. I found a backup that finished with a 1, got the
file it missed and restored the file. I can open it and use it, but the
changes that were made to it after the backup are not there as I would
expect.
=20
Thanks,
=20
Kris
________________________________
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of Lewick,
Taylor
Sent: Friday, January 07, 2005 5:49 PM
To: Jennifer Hooper; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Excluding Files for Successful Jobs
Jennifer, I know certain management can always be thick headed. But
based on the responses to this list, you may seriously think about
printing off the responses (maybe do a little editing to remove some of
the thoughts on "management") and show them how many people are in
agreeance with you." It may not do much good, but you will CYA, and
show them that it just isn't you who thinks this way.
=20
Also, you may want to explain to them, as I have heard it phrased on
this forum before, that the company did not purchase a backup system,
you purchased a restore system. And as Ed explained, it is better to
back up an open file and get a status 1, then not backup one at all. =20
=20
If it is reporting and seeing yellow ones that drives them nuts, I wrote
a bunch of scripts to show errors as anything that is not status 0 or 1,
219 (because all the storage units are in use) If they gripe about that
one, then give them a PO to order more drives.
=20
Also, on exclude lists, a good practice is to only exclude things like
/cdrom and /u01/oradata if you are using BCVs or snapshots on another
host to perform the database backup. =20
=20
You don't want your nightlyfulls to grab the oradata directory. Backing
it up is both a waste of time and resources, as it won't be useful for a
restore unless the database is down cold, and often times the oradata
directory is the largest directory(ies) on the system.
=20
There are some other valid reasons, but using them to list all open
files isn't one of them, in my opinion.
=20
Taylor
=20
------_=_NextPart_001_01C4F511.B79F67E2
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>SQL Restore issue...</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR>
<STYLE>@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: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.emailstyle17 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US vLink=3Dblue link=3Dblue>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D197332923-07012005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Hello Jennifer, I bet you didn't count on all =
these=20
responses to your question!</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D197332923-07012005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D197332923-07012005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Let me tell you from experience, =
m</FONT></SPAN><SPAN=20
class=3D197332923-07012005><FONT face=3DArial color=3D#0000ff =
size=3D2>anaging excludes=20
on Windows servers is not a fun task. It can easily eat up a FTE a week, =
maybe=20
more depending upon the number of boxes you have. I think many =
people=20
(management) do not understand exactly what a 1 is. To me, a RC1 is =
a good=20
backup, but not all files were backed up completely. That doesn't mean =
that the=20
files that show up as in use were not backed up, just that they were not =
backed=20
up fully. As some one has already mentioned, something is better than =
nothing.=20
Someone please correct me if I'm wrong in my thinking. I just did a =
little test.=20
I found a backup that finished with a 1, got the file it missed and =
restored the=20
file. I can open it and use it, but the changes that were made to it =
after the=20
backup are not there as I would expect.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D197332923-07012005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D197332923-07012005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Thanks,</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D197332923-07012005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D197332923-07012005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Kris</FONT></SPAN></DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> =
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <B>On Behalf Of =
</B>Lewick,=20
Taylor<BR><B>Sent:</B> Friday, January 07, 2005 5:49 PM<BR><B>To:</B> =
Jennifer=20
Hooper; veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> RE: =
[Veritas-bu]=20
Excluding Files for Successful Jobs<BR></FONT><BR></DIV>
<DIV></DIV>
<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">Jennifer, I =
know=20
certain management can always be thick headed. But based on the =
responses=20
to this list, you may seriously think about printing off the responses =
(maybe do=20
a little editing to remove some of the thoughts on =
“management”) and show them=20
how many people are in agreeance with you.” It may not do =
much good, but=20
you will CYA, and show them that it just isn’t you who thinks this =
way.</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"></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">Also, you may =
want to=20
explain to them, as I have heard it phrased on this forum before, that =
the=20
company did not purchase a backup system, you purchased a restore =
system. =20
And as Ed explained, it is better to back up an open file and get a =
status 1,=20
then not backup one at all. </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"></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">If it is =
reporting and=20
seeing yellow ones that drives them nuts, I wrote a bunch of scripts to =
show=20
errors as anything that is not status 0 or 1, 219 (because all the =
storage units=20
are in use) If they gripe about that one, then give them a PO to =
order=20
more drives.</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"></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">Also, on =
exclude lists,=20
a good practice is to only exclude things like /cdrom and /u01/oradata =
if you=20
are using BCVs or snapshots on another host to perform the database=20
backup. </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"></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">You =
don’t want your=20
nightlyfulls to grab the oradata directory. Backing it up is both =
a waste=20
of time and resources, as it won’t be useful for a restore unless =
the database=20
is down cold, and often times the oradata directory is the largest=20
directory(ies) on the system.</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"></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">There are =
some other=20
valid reasons, but using them to list all open files isn’t one of =
them, in my=20
opinion.</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"></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">Taylor</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV></BODY></HTML>
------_=_NextPart_001_01C4F511.B79F67E2--
|
