| 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??
This is a multi-part message in MIME format.
------=_NextPart_000_005B_01BFFE22.AA9B2260 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hot Backups...am I off base??When I first read this, I thought your co = worker was deranged...Then I reread your message, and realised that the = system backup would contain your hotbackup files. You state that there = is plenty of space on disk for both the system and hot backup files. It = made me wonder how many backup sets you would have access to. If it is = just one, then I would not feel comfortable with the described scenario. = I feel comfortable with my backup/recovery options only if I have = access to multiple backup sets for a database e.g. Daily backups for the = previous week or two. I would also point out that I would have tested a = number of recovery situations using those backups, so that I am = cofortable that the backup process is getting all the required files
Try for a compromise. He can delete your hotbackup if he copies it to = it's own tape first. Then you can be satisfied that you have something = to fall back on, and he can keep house all he wants. If anyone balks at = the cost of a dozen or so tapes to accomplish this, make them aware that = this is a pretty cost effective redundancy, and ANY dataloss would cost = much much more. =20
Steve McClure
Uncertified Oracle Hack
I am writing Korn shell scripts to create nightly hot backups on UNIX = (SUN Solaris.)=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.
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?=20
Would any of you use this strategy in production???=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
------=_NextPart_000_005B_01BFFE22.AA9B2260 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><TITLE>Hot Backups...am I off base??</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>When I first read this, I thought your =
co worker=20
was deranged...Then I reread your message, and realised that the system =
backup=20
would contain your hotbackup files. You state that there is plenty =
of=20
space on disk for both the system and hot backup files. It made me =
wonder=20
how many backup sets you would have access to. If it is just one, =
then I=20
would not feel comfortable with the described scenario. I feel =
comfortable=20
with my backup/recovery options only if I have access to multiple backup =
sets=20
for a database e.g. Daily backups for the previous week or two. I =
would=20
also point out that I would have tested a number of recovery situations =
using=20
those backups, so that I am cofortable that the backup process is =
getting all=20
the required files</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Try for a compromise. He can =
delete your=20
hotbackup if he copies it to it's own tape first. Then you can be=20
satisfied that you have something to fall back on, and he can keep house =
all he=20
wants. If anyone balks at the cost of a dozen or so tapes to =
accomplish=20
this, make them aware that this is a pretty cost effective redundancy, =
and ANY=20
dataloss would cost much much more. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Steve McClure</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Uncertified Oracle Hack</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:Valerie.H.Webber_at_irs.gov"=20
title=3DValerie.H.Webber_at_irs.gov>Webber Valerie H</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
href=3D"mailto:ORACLE-L_at_fatcity.com"=20
title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, August 04, 2000 =
8:58=20
AM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Hot Backups...am I off =
base??=20
</DIV> <DIV><BR></DIV> <P><FONT color=3D#800000 face=3D"Bookman Old Style">I am writing Korn =shell=20
 |
 |