Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Hot Backups...am I off base??

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

From: djordjej <djordjej_at_attcanada.ca>
Date: Fri, 4 Aug 2000 19:03:07 -0400
Message-Id: <10579.113901@fatcity.com>


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 <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??=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_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type><TITLE>Hot Backups...am I off = base??</TITLE><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<META content=3D'"MSHTML 4.71.1712.3"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>If you have enough of space, I would =
not delete=20
the files from the disk.&nbsp; Ask your SA why increasing the recovery = time by=20
the time needed to restore the files from the tape.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>And as somebody mentioned, make sure ti test=20
recovery.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Djordje</FONT></DIV>
<BLOCKQUOTE=20

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

    <DIV><FONT face=3DArial size=3D2><B>-----Original = Message-----</B><BR><B>From:=20

    </B>Webber Valerie H &lt;<A=20
    =
href=3D"mailto:Valerie.H.Webber_at_irs.gov">Valerie.H.Webber_at_irs.gov</A>&gt;=
<BR><B>To:=20

    </B>Multiple recipients of list ORACLE-L &lt;<A=20

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

    </B>Friday, August 04, 2000 4:38 PM<BR><B>Subject: </B>Hot = Backups...am I=20

    off base?? <BR><BR></DIV></FONT>
    <P><FONT color=3D#800000 face=3D"Bookman Old Style">I am writing = Korn shell=20

    scripts to create nightly hot backups on UNIX (SUN Solaris.)</FONT> =
</P>

    <P><FONT color=3D#800000 face=3D"Bookman Old Style">Another = &quot;DBA&quot;=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.</FONT></P>     <P><FONT color=3D#800000 face=3D"Bookman Old Style">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.</FONT></P>     <P><FONT color=3D#800000 face=3D"Bookman Old Style">Am I off my = rocker not to=20

    rely solely on the system backup? </FONT></P>     <P><FONT color=3D#800000 face=3D"Bookman Old Style">Would any of you = use this=20

    strategy in production???</FONT> </P>     <P><FONT color=3D#800000 face=3D"Bookman Old Style">Thanks in = advance!</FONT>=20

    <BR><FONT color=3D#800000 face=3D"Bookman Old Style">Val</FONT> =
<BR><B><I><FONT=20

    color=3D#000080 face=3D"Bookman Old Style">Valerie H.=20     Webber</FONT></I></B><I></I><FONT color=3D#000000 = face=3DArial><BR></FONT><FONT=20

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

    Inc</FONT><FONT color=3D#000000 face=3DArial><BR></FONT><FONT = color=3D#000080=20

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

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

    size=3D1>704-569-1002 x107</FONT><FONT color=3D#000000 face=3DArial> = Received on Fri Aug 04 2000 - 18:03:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US