Re: Recovery scenario

On Jan 31, 2008 2:58 PM, Hemant K Chitale <hkchital@xxxxxxxxxxxxxx> 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

Other related posts: