Hot Backups...am I off base??

From: Webber Valerie H <Valerie.H.Webber_at_irs.gov>
Date: Fri, 4 Aug 2000 10:42:10 -0400
Message-Id: <10579.113858@fatcity.com>

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_01BFFE22.2C4F446E
Content-Type: text/plain;

charset="iso-8859-1"

I am writing Korn shell scripts to create nightly hot backups on UNIX (SUN Solaris.)

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.

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.

Am I off my rocker not to rely solely on the system backup?

Would any of you use this strategy in production???

Thanks in advance!
Val
Valerie H. Webber
Management Systems Designers, Inc
Valerie.H.Webber_at_m1.irs.gov
704-569-1002 x107

------_=_NextPart_001_01BFFE22.2C4F446E
Content-Type: text/html;

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Hot Backups...am I off base?? </TITLE>
</HEAD>
<BODY>

I am writing Korn =
shell scripts to create nightly hot backups on UNIX (SUN = Solaris.)


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.

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.

Am I off my =
rocker not to rely solely on the system backup? 


Would any of you =
use this strategy in production???


Thanks in =
advance!
 Val
 Valerie H. =
Webber 
Management Systems Designers, Inc 
Valerie.H.Webber_at_m1.irs.gov 
704-569-1002 x107 = Received on Fri Aug 04 2000 - 09:42:10 CDT