Re: Recovery scenario

From: Prasad <p4cldba_at_gmail.com>
Date: Thu, 31 Jan 2008 12:12:05 -0800
Message-ID: <666b99c70801311212p74a3c4ffsc101f768605b50ff@mail.gmail.com>


"Why would oracle ask for a file that is from 5am when the backup finished at 1 30am?"

Can this be due to the backup controlfile reading the last scn of online redo logs . ??

On Thu, Jan 31, 2008 at 7:17 AM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:

> 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 - 14:12:05 CST

Original text of this message