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:RE: Backup Strategy

Re:RE: Backup Strategy

From: Gene Sais <gsais_at_co.palm-beach.fl.us>
Date: Thu, 04 Oct 2001 16:50:01 -0700
Message-ID: <F001.003A2C11.20011004170518@fatcity.com>

Ok, my backup strategy:

  1. Prod Db's - Cold backups semi-weekly to disk. Then off to tape. Export backups
    (full) daily to disk, keep 7 days on disk. Archive log mode and arcs backed up to
    tape daily and flushed from archive filesystem with monitoring script. Typically keep 40 days worth on disk. I think thats enough :).
  2. Dev & Test Db's - Sometimes cold backups to disk, depending on db or need. No archive log mode. Export backups (full) daily to disk, keep 7 days on disk. I find exports more valuable to developers.

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:

  1. Archive log mode not required for cold backups. Dev & Test DB's do not need archive space.
  2. Cold backups follow the KISS principle. Shutdown db, tar, dump, cpio, dd, etc. the datafiles, redo logs, ctl files, oracle filesystems, etc. to tape, Startup db, Done. Take the tape to same or another server and restore, No Oracle cmds required (filesystems being the same). Now for Hot Backups, we have to add a step. Not a big step :) We need the arcs and need to recover the db.

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-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). -- 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).
Received on Thu Oct 04 2001 - 18:50:01 CDT

Original text of this message

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