| 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:RE: Backup Strategy
Ok, my backup strategy:
Thats if for me.
Gene
>>> dgoulet_at_vicr.com 10/04/01 18:19 PM >>> Jared & Gene,
Any backup strategy that gives me more than one recovery option is viable in my mind. Consequently I use a mix of hot and cold backups as well as keeping my archive logs around for a long while. At least as long as the oldest cold backup.
Dick Goulet
____________________Reply Separator____________________ Author: Jared.Still_at_radisys.com Date: 10/4/2001 2:30 PM
Well, if you can live with losing data due to a crash, or if your data is all static, no problem I guess.
Jared
"Gene Sais"
<Gsais_at_co.palm-be To: <ORACLE-L_at_fatcity.com>,
<Jared.Still_at_radisys.com>
ach.fl.us> cc:
Subject: RE: Backup Strategy
10/04/01 02:23 PM
I see 2 advantages of cold over hot backups:
Gene
* Still not convinced backing up closed files are not safer/better than
open files :) *
>>> <Jared.Still_at_radisys.com> 10/04/01 04:59PM >>>
OK, I'll bite, what OS commands?
As for cold backups, and I'm sure you've heard this already, they're only really needed after you open a database with 'resetlogs' . Otherwise it is not necessary to use a cold backup.
Jared
"Gene Sais"
<Gsais_at_co.palm-be To: Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>
ach.fl.us> cc:
Sent by: Subject: RE: Backup
Strategy
root_at_fatcity.com
10/04/01 02:10 PM
Please respond to
ORACLE-L
Well for 1 reason, Cold backups are restored using OS cmds, no need for Oracle recovery, whereas, Hot Backups require OS cmds + Oracle recovery. One exception is pt in time recoveries. I do have 1 db that will be web-enabled, therefore 24x7. So guess what I have to do, Hot Backups. I am not against them, jst prefer cold. Anyone have hot backup scripts? Lisa, you are the script ninja, got 1 of those scripts lying aorund. Thanks :)
Gene
>>> kimberly.smith_at_gmd.fujitsu.com 10/04/01 04:00PM >>> Why is better Gene? What is it about the files being closed that gives you the trust factor? I don't use RMAN here either but its more because my backup method works wonders and I just don't need those extra features that RMAN provides.
There are a lot of sites out there that cannot afford to have the database come down even for 5 minutes so you might want to spend some time getting the warm fuzzies over hot backups. I swear, they work.
-----Original Message-----
Sent: Thursday, October 04, 2001 12:25 PM
To: Multiple recipients of list ORACLE-L
I personally prefer cold backups over hot. Always better when the files
are
closed. But hey, this is coming from someone who still doesn't trust Rman
:)
Gene
>>> kimberly.smith_at_gmd.fujitsu.com 10/04/01 12:40PM >>> I agree with your export statement but I must question this one. I cannot think of a single reason to get a cold backup over a hot backup. I can think of reasons for cold backups but if I was doing hot backups already I would not shutdown my database just to get a cold. There is a myth out there that hot backups are not as reliable as cold backups and its false. Your really not saving anything time wise if there is a crash (unless of course all your disks crash as you are bring up the database).
Weekly cold backups are a good plan.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: kimberly.smith_at_gmd.fujitsu.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the messag BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Oct 04 2001 - 18:50:01 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: Gsais_at_co.palm-beach.fl.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: kimberly.smith_at_gmd.fujitsu.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: Gsais_at_co.palm-beach.fl.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, includea line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: gsais_at_co.palm-beach.fl.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |