Re: Recovery scenario

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 31 Jan 2008 15:17:31 +0000
Message-ID: <7765c8970801310717k1d39c379kd881ce61de64d6d3@mail.gmail.com>


On Jan 31, 2008 2:58 PM, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:

>
>
> A "using Backup Controlfile" implicitly means
> "the controlfile is older then the datafiles"
>

I've always thought of it as 'ignore the scn in the controlfile' not the controlfile is older..

> the RECOVER command then actually _builds_ the archivelog
> file names [using log_archive_dest and log_archive_format].

It wasn't the file *name *per se but the *creation time* as in the message

ORA-00279: change 11805815756 generated at *01/30/2008 05:00:15* needed for thread 1

Where we were told that the backups including the controlfile backup were from several hours *before* 5 in the morning. The recovery process seems to know when this change was created - but I don't really see how it can - unless as Andrew suggested the controlfile was actually from *after* 5am. I'm sure I used to know this once, but I'm feeling really old and stupid right now.

Niall

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 31 2008 - 09:17:31 CST

Original text of this message