Re: Recovery scenario

Well, one possible explanation is that both committed and uncommitted changes are written to the on line logs and hence to the archived logs. In the case of a transaction that started before the backup and was running through the backup you could need logs from before the backup started. I'm sure you could think of other scenarios that are specific to your environment.

Allan

On Jan 31, 2008 2:12 PM, Prasad <p4cldba_at_gmail.com> wrote:

> "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