Re: Oracle datafile consistent ?

The controlfile IS continually updated. It contains one SCN per datafile. If you have recreated your controlfile from trace, you can only issue alter database open resetlogs.
If you have restored it and do recovery you should use 'using backup controlfile', so Oracle knows YOU are going to determine where to stop recovery.

Hth,

--
Sybrand Bakker, Oracle DBA
mkeene <matthew_keeneNOmaSPAM_at_ansett.com.au.invalid> wrote in message news:0a0133f8.7ffd4ac8_at_usw-ex0101-003.remarq.com...
> So what happens when the control file has been either restored from
> backup, or even worse, recreated from the trace file ? In the first
> case the SCN will be old and in the second it will not exist at all, so
> what does Oracle use in this case ? Which SCN in the control file does
> it use ? Is there one per datafile or a single one for the entire
> instance ? How does Oracle write this information to it ? It can't be
> continually updating it because this would make the control file a huge
> bottleneck, does it only write it during a system checkpoint ?
>
> The control file was where I originally understood the comparison was
> done but the more I started to look into it and research it the more
> confused I got, which was why I asked the question here.
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Tue Jan 11 2000 - 01:13:34 CST