Re: V$LOGHISTORY & control files

At the time of recovery the redolog files are applied on the data files by looking at the SCN in the data file (as the latest SCN would be always higher than the old one) and the log sequence number from the control file to know which log files are required to apply.

I think once you make the backup control file to trace, the latest log sequecne and SCN would be noticed to control fiel. But the status of the datafile header and log file sequence numbers are updated automatically.

Once you have a backup control file in the sytem then the V$LOGHISTORY may be consistent.

Vimal

Mike Burden <michael.burden_at_capgemini.co.uk> wrote in article <36A8486F.39EB2453_at_capgemini.co.uk>...
> I believe the information for V$LOGHISTORY comes from the control file.
>
> One of the reasons the control file is important is because it contains
> for the latest SCN used when rolling forward.
>
> If this is the case, then is there a problem backing up the control file
> to trace as any SCN information is lost. If the control file is rebuilt
> from the trace file, all the datafiles are restored and a roll forward
> to a point in time is issued how does Oracle know what SCN to roll
> forward to???
>
>
>
>
Received on Fri Jan 22 1999 - 09:39:05 CST