Message-Id: <10579.113858@fatcity.com> From: Webber Valerie H Date: Fri, 4 Aug 2000 10:42:10 -0400 Subject: Hot Backups...am I off base?? 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@m1.irs.gov 704-569-1002 x107 ------_=_NextPart_001_01BFFE22.2C4F446E Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hot Backups...am I off base??

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@m1.irs.gov
704-569-1002 x107 =