Re: How to apply archive logs on an cold backup

Bob Jones wrote:

[snip]

> I don't see how the database would be vulnerable to media failure. At what
> point?

Immediately he issues the 'alter database open resetlogs' command, which your version of the recovery command requires him to do.

A media failure of any sort after that time cannot be recovered from, except by doing exceedingly complex steps which are prone to be gotten wrong.

If you don't know this, why did you offer the advice you did? And if you did know it, why didn't you mention it?

>> > Yes, I prefer simplicity.
>>
>> No, you appear to prefer writing answers that make no sense at all.
>>

It lacks sense in the same way that if I asked you how to peel a potato, the answer 'there's a bottle in the fridge' would lack sense.

I suppose you *could* peel a potato with a bottle, having first drained it of its contents and smashed it. But it would be an unusual approach, and one you might do on a camping holiday only after you'd forgotten to pack the potato peeler and you've established that no other functioning potato peelers can be found in nearby shops or amongst fellow campers.

Similarly, when asked 'How do I recover a database using a cold backup?', one replies "By issuing the command 'recover database .. using backup controlfile'" only if one doesn't want to be making much sense. Because ordinarily, and most commonly, no you don't.

Of course, if you get asked "I have lost all my control files and I only have a binary backup to restore from, so how do I recover", your answer makes a lot more sense. Rather like if I ask "Is there any more white wine", the answer "There's a bottle in the fridge" suddenly becomes sensible.

> Some qualities can worse than ignorance.

Constructing a sentence without the verb in it isn't actually one of them. But not retracting a wrong and potentially dangerous answer when its degree of error has been pointed out to you is, I agree.

HJR Received on Thu Sep 02 2004 - 12:41:04 CDT