Re: How to apply archive logs on an cold backup

Frank van Bortel wrote:

> Howard J. Rogers wrote:
>> Frank:

Clearly, there is mis-communication. The tenor of your contribution regarding 'look at your other posts in this thread' was very definitely that I had repeatedly asserted one would NEVER need to 'use backup controlfile' in a recovery.

If that is wrong, you could just have said so.

You have now done so, and I take that part as finished.

[therefore, snip]

>> Now, your asterisk indicated that the OP would have restored
>> "Controlfile(s), online redolog files, datafiles, (S)PFILE(s),
>> directory structures, password file"
>>
>> And if that's the case, all bets are off because he's just performed a
>> wrong restoration.

>
> You lost me here - isn't this the restore of a cold backup?!?

NO!

This is the entire point that keeps being lost in this thread. In noarchivelog mode, I *must* have a cold backup. In archivelog, I have the *choice* of backing up cold. So if I say to you I have a cold backup, you can tell nothing about whether I am in archivelog mode or not.

But one's recovery actions are constrained and governed ONLY by whether I am in archivelog mode or not.

And in archivelog mode the rule simply is, Frank: NEVER, ever, ever, ever, ever, ever, ever, backup your online redo logs in the first place, so never ever ever ever restore them either. In fact, doing so would never actually be an option, because they wouldn't be in your backupset.

I'll say it again, and hope the message is clear enough: the mention in the original poster's contribution here of the temperature of his backup is a complete 100% red herring. The issue was and is: archivelog mode or not? That's all.

HJR Received on Mon Sep 06 2004 - 14:24:39 CDT