| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 <Valerie.H.Webber_at_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_at_m1.irs.gov
704-569-1002 x107
<P> 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.<BR>
<P> <B><I>Webber Valerie H <Valerie.H.Webber_at_irs.gov></I></B> wrote: <BR>
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"><BR>
<META content="MS Exchange Server version 5.5.2650.12" name=Generator><BR>
<P><FONT color=#800000 face="Bookman Old Style">I am writing Korn shell scripts to create nightly hot backups on UNIX (SUN Solaris.)</FONT> </P><BR>
<P><FONT color=#800000 face="Bookman Old Style">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.</FONT></P><BR>
<P><FONT color=#800000 face="Bookman Old Style">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.</FONT></P><BR>
<P><FONT color=#800000 face="Bookman Old Style">Am I off my rocker not to rely solely on the system backup? </FONT></P><BR>
<P><FONT color=#800000 face="Bookman Old Style">Would any of you use this strategy in production???</FONT> </P><BR>
<P><FONT color=#800000 face="Bookman Old Style">Thanks in advance!</FONT> <BR><FONT color=#800000 face="Bookman Old Style">Val</FONT> <BR><B><I><FONT color=#000080 face="Bookman Old Style">Valerie H. Webber</FONT></I></B><I></I><FONT color=#000000 face=Arial><BR></FONT><FONT color=#000080 face="Comic Sans MS" size=1>Management Systems Designers, Inc</FONT><FONT color=#000000 face=Arial><BR></FONT><FONT color=#000080 face="Comic Sans MS" size=1>Valerie.H.Webber_at_m1.irs.gov</FONT><FONT color=#000000 face=Arial><BR></FONT><FONT color=#000080 face="Comic Sans MS" size=1>704-569-1002 x107</FONT><FONT color=#000000 face=Arial> </FONT></P><BR></BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>
Kick off your party with Yahoo! Invites.
Received on Mon Aug 07 2000 - 08:18:59 CDT
 |
 |