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

RE: Backup Strategy

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Thu, 04 Oct 2001 13:42:59 -0700
Message-ID: <F001.003A27E7.20011004134104@fatcity.com>

Gene is a sysadmin at heart.  He hasn't been fully groomed and trained in the Data Base Arts.  I think that's the main reason for his (unjustified) reluctance to TRUST something that works. 

It's like physics.  You see it every day, the math doesn't make 100% sense to you, but you have to convince yourself that certain facts are true before you can move to the next level.  Play with hot backups, test the scenarios, learn to trust it.  Convince yourself that it WORKS.

I have a boatload of scripts.  Gene you should be able to modify your trusty dusty cold backup scripts to execute the alter tablespace commands dynamically, one by one, and do the copy.   should be a minor change.   There's one caveat:  you can't do this if you aren't in archive log mode.

I'll look through what I've got and send them to you. 

(For those of you who don't know, Gene is my old boss.  I taught him a lot about Oracle -  LOL... My favorite taunt:  Gene's afraid of R-Man!  Gene's afraid of R-Man!)

Lisa Koivu
Oracle Database Administrator and Terrible Perl Programmer Fairfield Resorts, Inc.
954-935-4117

-----Original Message-----

From:   Gene Sais [SMTP:Gsais_at_co.palm-beach.fl.us]
Sent:   Thursday, October 04, 2001 5:11 PM
To:     Multiple recipients of list ORACLE-L
Subject:        RE: Backup Strategy

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, just 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 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).
--

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, 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 - 15:42:59 CDT

Original text of this message

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