Re: How to apply archive logs on an cold backup

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Mon, 06 Sep 2004 18:45:54 +1000
Message-Id: <413c23ce$0$29142$afc38c87@news.optusnet.com.au>

John Hurley wrote:

> dbanewbie_at_yahoo.com.br (robson) wrote in message
> news:<514f866a.0408311326.68c5d22d_at_posting.google.com>...

>> i have the database with archive log and one cold backup.
>> how to apply archive log in cold backup?
>> 
>> thanks,
>> robson

>
> Did you get the information you needed?
>
> Looks like many of the people responding got into a heated argument
> but there was not enough information supplied in your original post to
> give any accurate advice.
>
> If you are restoring from a cold backup and needing to perform forward
> recovery, it depends if you have lost all of your current control
> files or not.

Look, it's wooly statements like these that that have been at the source of the "heated argument" you devined in this thread.

Why does restoring from a cold backup and needing to perform forward recovery depend on whether he's lost all his control files or not?

The recovery one is capable of performing does not depend on the temperature of the thing being restored, only on *what* is being restored. And hence the recovery that he can perform depends entirely on what sort of failure he has suffered.

The temperature of one's backup NEVER makes a difference to the recovery actions one performs.

So yes, if he's lost all his current control files, that's one type of recovery needed. If he's lost his current online log, that's another type of recovery needed. And so on. But I wish people would stop talking about "if you've got a cold backup... you can do X", because he can do X with a hot, cold or slightly tepid backup too.

The sole determinants of what recovery one performs is: am I in archivelog; what has failed; do I have all my archives. And that's it.

> Also the state of your online redo log's is important.
>
> Of course before anyone would advocate any kind of database recovery,
> a deeper understanding of the problem that you were facing would be
> needed.

Precisely. But not, apparently, to everyone who thought to post (and I'm not referring to you! Yours is eminently, sensibly vague advice in reply to an eminently vague request for help. I would just like to see less concern shown about the temperature of the backup, because as I tried to point out in post 1 of this thread, it is a complete red herring).

Regards
HJR Received on Mon Sep 06 2004 - 03:45:54 CDT