Re: Cold backup versus hot backup.

From: Mark Anderson <fnmpa_at_uaf.edu>
Date: Mon, 13 Apr 2009 08:09:53 -0800 (AKDT)
Message-ID: <4447.137.229.7.101.1239638993.squirrel_at_fnmpa.email.uaf.edu>

I was surprised to read Jack's response. I had thought that the only advantage that hot backups had over cold was that the database remains available during the backup. Which is a huge advantage in many, many cases, of course.

But cold backups, both in concept and in implementation, are so much simpler than hot backups. All else being equal, I would choose the simplest method possible to minimize the number of places that something could go wrong and maximize the chances that if something did go wrong I could understand what happened as the first step to correcting it.

If someone will thank Guillermo for increasing the availability of the databases in question by going to hot backups (or if his life will be simplified by consistently using hot backups throughout) then by all means make the switch from cold to hot backups. But I would otherwise try to Keep It Simple, Stupid wherever possible. Especially since he apparently already has cold backups working satisfactorily now.

regards,

Mark

> I would always suggest a hot backup.
> The only advantage of cold backups over hot backups I can think of is that
> if you only have the datafiles and no archives you can still bring it up
> in
> a consistent state (old data but consistent).
>
> jack
>
> 2009/4/13 Guillermo Alan Bort <cicciuxdba_at_gmail.com>
>
>> Another debate...
>>
>> We have several DBs that are currently under a cold backup schema.
>> Basically they go down either every day or once a week and a full cold
>> backup is taken. There are several issues related to the DB starting
>> up before the backup ends, but that's not an Oracle problem, nor a
>> cold-backup problem... just a lack of attention problem.
>>
>> On the other hand, hot backups have many advantages...
>>
>> what do you consider are the advantages and disadvantages of both cold
>> and hot backups, and would you use a cold backup schema? if so, in
>> what situation?
>>
>> Thanks ^_^
>>
>>
>> Alan Bort
>> Oracle Certified Professional
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> Jack van Zanen
>
> -------------------------
> This e-mail and any attachments may contain confidential material for the
> sole use of the intended recipient. If you are not the intended recipient,
> please be aware that any disclosure, copying, distribution or use of this
> e-mail or any attachment is prohibited. If you have received this e-mail
> in
> error, please contact the sender and delete all copies.
> Thank you for your cooperation
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 13 2009 - 11:09:53 CDT