Message-Id: <10579.113901@fatcity.com> From: "djordjej" Date: Fri, 4 Aug 2000 19:03:07 -0400 Subject: Re: Hot Backups...am I off base?? 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 To: Multiple recipients of list ORACLE-L 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@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 Hot Backups...am I off = base??
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.
 
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"=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 =
Valerie H.=20 Webber
Management Systems = Designers,=20 Inc
Valerie.H.Webber@m1.irs.gov
704-569-1002 x107 =