Re: Control file recovery

> The controlfile is from a backup. Your scenario is relatively simple.
> There might be datafiles coming from backups, there might be datafiles
> current.
> How is Oracle to decide which SCN and logsequence is correct? This is
> *always* derived from the controlfile, but the controlfile is from a
> backup. So who can tell? Should Oracle assume it is always the highest
> SCN and logsequence? One might end-up in recovery after recovery,
> because if there are different SCNs and LOGSEQUENCES in various files,
> choosing ONE of them, would force Oracle to perform further recovery.
> So, yes, the number could be updated, but we can't *trust the number
> to be correct*, and Oracle won't allow datafiles etc in different
> stages, because for Oracle a database is an unity.

In the Docs it is menationed that in case you are creating a new control file, you don't need to do RESETLOGS. So what happens when CREATE a new control file? Received on Tue Sep 06 2005 - 04:53:29 CDT