Message-Id: <10581.113924@fatcity.com> From: Kimberly.smith@gmd.fujitsu.com Date: Sun, 6 Aug 2000 09:45:33 -0700 Subject: RE: Hot Backups...am I off base?? This is a multi-part message in MIME format. ------=_NextPart_000_0083_01BFFF8B.114784E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hot Backups...am I off base??If I had the space I would keep the hot backup on disk. Of course this makes more sense if you put it on disks that are not housing any data files. I am not sure about the good housekeeping part. You always have to keep that disk space around since the next night you are going to come do it again. I do however delete my backup right before creating the new ones. This is mostly to make it easier for my script to determine if the backup was successful or not. -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of djordjej Sent: Friday, August 04, 2000 5:04 PM To: Multiple recipients of list ORACLE-L Subject: Re: Hot Backups...am I off base?? 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 To: Multiple recipients of list ORACLE-L Date: Friday, August 04, 2000 4:38 PM Subject: 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 ------=_NextPart_000_0083_01BFFF8B.114784E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hot Backups...am I off base??
If I=20 had the space I would keep the hot backup on disk.  Of course this = makes=20 more sense if you put it on disks that
are=20 not housing any data files.  I am not sure about the good = housekeeping=20 part.  You always have to keep that disk
space=20 around since the next night you are going to come do it again.  I = do=20 however delete my backup right before
creating the new ones.  This is mostly = to make it=20 easier for my script to determine if the backup was=20 successful
or=20 not.
-----Original Message-----
From: root@fatcity.com=20 [mailto:root@fatcity.com]On Behalf Of djordjej
Sent: = Friday,=20 August 04, 2000 5:04 PM
To: Multiple recipients of list=20 ORACLE-L
Subject: Re: Hot Backups...am I off=20 base??

If you have enough of space, I = would not=20 delete the files from the disk.  Ask your SA why increasing the = recovery=20 time by the time needed to restore the files from the = tape.
 
And as somebody mentioned, make sure ti test=20 recovery.
 
Djordje
-----Original = Message-----
From:=20 Webber Valerie H <Valerie.H.Webber@irs.gov>=
To:=20 Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
D= ate:=20 Friday, August 04, 2000 4:38 PM
Subject: Hot = Backups...am I=20 off base??

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

Another "DBA" = (ex-System=20 Admin I might add) recommends 1. making a hot backup of the = database, 2.=20 make a system backup, 3. then DELETE the hot backup we just created = relying=20 only on the system backup with a verify option. He say this is good = for=20 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 =
Valerie H.=20 Webber
Management Systems = Designers,=20 Inc
Valerie.H.Webber@m1.irs.gov
704-569-1002 x107 =