Message-Id: <10582.113962@fatcity.com> From: Chuck Hamilton Date: Mon, 7 Aug 2000 06:18:59 -0700 (PDT) Subject: Re: Hot Backups...am I off base?? --0-1681692777-965654339=:21447 Content-Type: text/plain; charset=us-ascii I'm not sure what's meant by "verfiy option" but I would keep the hot backup. Unless the system backup is done with all tablespaces in backup mode, it'll be a fuzzy backup and can't be relied on to recover the database. Webber Valerie H wrote: 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 --------------------------------- Do You Yahoo!? Kick off your party with Yahoo! Invites. --0-1681692777-965654339=:21447 Content-Type: text/html; charset=us-ascii

I'm not sure what's meant by "verfiy option" but I would keep the hot backup. Unless the system backup is done with all tablespaces in backup mode, it'll be a fuzzy backup and can't be relied on to recover the database.

Webber Valerie H <Valerie.H.Webber@irs.gov> wrote:

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

Do You Yahoo!?
Kick off your party with Yahoo! Invites.