Re: Hot Backups...am I off base??

From: djordjej <djordjej_at_attcanada.ca>
Date: Fri, 4 Aug 2000 19:03:07 -0400
Message-Id: <10579.113901@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0023_01BFFE46.9FEAE340 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

If you have enough of space, I would not delete the files from the disk. = Ask your SA why increasing the recovery time by the time needed to = restore the files from the tape.

And as somebody mentioned, make sure ti test recovery.

Djordje
-----Original Message-----

From: Webber Valerie H <Valerie.H.Webber_at_irs.gov> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Friday, August 04, 2000 4:38 PM Subject: Hot Backups...am I off base??=20 =20
 =20
 I am writing Korn shell scripts to create nightly hot backups on = UNIX (SUN Solaris.)=20

=20
Another "DBA" (ex-System Admin I might add) recommends 1. making a = hot backup of the database, 2. make a system backup, 3. then DELETE the = hot backup we just created relying only on the system backup with a = verify option. He say this is good for housekeeping on the system.

=20
I highly opposed this scenario. There is plenty of space available = on the system for the backup files so that is not an issue. I'd rather = have both.. the system backup and the hot backup on disk drives.

   =20
    Am I off my rocker not to rely solely on the system backup?=20    =20
    Would any of you use this strategy in production???=20    =20
    Thanks in advance!=20
    Val=20
    Valerie H. Webber
    Management Systems Designers, Inc
    Valerie.H.Webber_at_m1.irs.gov
    704-569-1002 x107=20

   =20
   =20
   =20

------=_NextPart_000_0023_01BFFE46.9FEAE340 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type><TITLE>Hot Backups...am I off = base??</TITLE><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<META content=3D'"MSHTML 4.71.1712.3"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>If you have enough of space, I would =
not delete=20
the files from the disk.  Ask your SA why increasing the recovery = time by=20
the time needed to restore the files from the tape.</DIV>
<DIV> </DIV>
<DIV>And as somebody mentioned, make sure ti test=20
recovery.</DIV>
<DIV> </DIV>
<DIV>Djordje</DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: = 5px">

<DIV>-----Original = Message----- From:=20

Webber Valerie H <<A=20
=
href=3D"mailto:Valerie.H.Webber_at_irs.gov">Valerie.H.Webber_at_irs.gov</A>>=
 To:=20

Multiple recipients of list ORACLE-L <<A=20

    =
href=3D"mailto:ORACLE-L_at_fatcity.com">ORACLE-L_at_fatcity.com</A>&gt;<BR><B>D=
ate:=20

Friday, August 04, 2000 4:38 PM Subject: Hot = Backups...am I=20

off base?? </DIV>
I am writing = Korn shell=20

scripts to create nightly hot backups on UNIX (SUN Solaris.) =


Another = "DBA"=20

(ex-System Admin I might add) recommends 1. making a hot backup of = the=20

database, 2. make a system backup, 3. then DELETE the hot backup we = just=20

created relying only on the system backup with a verify option. He = say this=20

is good for housekeeping on the system. I highly opposed = this=20

scenario. There is plenty of space available on the system for the = backup=20

files so that is not an issue. I'd rather have both.. the system = backup and=20

the hot backup on disk drives. Am I off my = rocker not to=20

rely solely on the system backup? Would any of you = use this=20

strategy in production??? Thanks in = advance!=20

Val =
 <FONT=20

color=3D#000080 face=3D"Bookman Old Style">Valerie H.=20 Webber <FONT=20

color=3D#000080 face=3D"Comic Sans MS" size=3D1>Management Systems = Designers,=20

Inc <FONT = color=3D#000080=20

face=3D"Comic Sans MS" =
size=3D1>Valerie.H.Webber_at_m1.irs.gov<FONT=20

color=3D#000000 face=3DArial> <FONT color=3D#000080 = face=3D"Comic Sans MS"=20

size=3D1>704-569-1002 x107 = Received on Fri Aug 04 2000 - 18:03:07 CDT