"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@xxxxxxxxx> wrote: > 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 >