RE: Backup Strategy

From: Guy Hammond <guy.hammond_at_avt.co.uk>
Date: Fri, 05 Oct 2001 07:50:09 -0700
Message-ID: <F001.003A3518.20011005065518@fatcity.com>

That is a good point, it is important to consider who will be doing the recovery. If it is a relatively small and static database, and the recovery will be performed by an Unix admin (i.e. not a specialist DBA) then export/cold backup does make a lot of sense. The main issue to consider is $$$. If the organization won't lose any $$$ from the database being down for as long as it takes to recover from a cold backup, then the simplest technique is sufficient.

Cheers,

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

Sent: Thursday, October 04, 2001 10:11 PM To: Multiple recipients of list 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, just prefer cold. Anyone have hot backup scripts? Lisa, you are the script ninja, got 1 of those scripts lying aorund. Thanks :)

Gene
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Guy Hammond
INET: guy.hammond_at_avt.co.uk

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 Fri Oct 05 2001 - 09:50:09 CDT