RE: Hot Backups...am I off base??

From: <Kimberly.smith_at_gmd.fujitsu.com>
Date: Sun, 6 Aug 2000 09:45:33 -0700
Message-Id: <10581.113924@fatcity.com>

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_at_fatcity.com [mailto:root_at_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 <Valerie.H.Webber_at_irs.gov> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Hot Backups...am I off base??</TITLE>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY bgColor=3D#ffffff>
<DIV>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</DIV>
<DIV>are=20
not housing any data files.  I am not sure about the good = housekeeping=20
part.  You always have to keep that disk </DIV>
<DIV>space=20
around since the next night you are going to come do it again.  I = do=20
however delete my backup right before </DIV>
<DIV><SPAN=20
class=3D857174216-06082000>creating the new ones.  This is mostly = to make it=20
easier for my script to determine if the backup was=20 successful</DIV>
<DIV>or=20
not.</DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr>-----Original Message----- From: root_at_fatcity.com=20 [mailto:root_at_fatcity.com]On Behalf Of djordjej Sent: = Friday,=20

  August 04, 2000 5:04 PM<BR><B>To:</B> Multiple recipients of list=20
  ORACLE-L<BR><B>Subject:</B> Re: Hot Backups...am I off=20
  base??<BR><BR></DIV></FONT>

<DIV>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.</DIV>
 <DIV> </DIV> <DIV>And as somebody mentioned, make sure ti test=20 recovery.</DIV>

  <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT size=3D2>Djordje</FONT></DIV>
  <BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; = PADDING-LEFT: 5px">

<DIV>-----Original = Message----- From:=20

Webber Valerie H <<A=20
=
href=3D"mailto:Valerie.H.Webber_at_irs.gov">Valerie.H.Webber_at_irs.gov</A>>=
 To:=20

Multiple recipients of list ORACLE-L <<A=20

    =
href=3D"mailto:ORACLE-L_at_fatcity.com">ORACLE-L_at_fatcity.com</A>&gt;<BR><B>D=
ate:=20

Friday, August 04, 2000 4:38 PM Subject: Hot = Backups...am I=20

off base?? </DIV>
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 =
 <FONT=20

color=3D#000080 face=3D"Bookman Old Style">Valerie H.=20 Webber <FONT=20

color=3D#000080 face=3D"Comic Sans MS" size=3D1>Management Systems = Designers,=20

Inc <FONT = color=3D#000080=20

face=3D"Comic Sans MS" =
size=3D1>Valerie.H.Webber_at_m1.irs.gov<FONT=20

color=3D#000000 face=3DArial> <FONT color=3D#000080 = face=3D"Comic Sans MS"=20

size=3D1>704-569-1002 x107 = Received on Sun Aug 06 2000 - 11:45:33 CDT