Re: V$LOGHISTORY & control files

Thanks, I'll try that on my test machine.

Jeremiah Wilton wrote:

> On Fri, 22 Jan 1999, Mike Burden wrote:
> >
> > 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???
>
> If you use a backup controlfile or create a new controlfile using SQL
> before you perform recovery, then recovery will just apply redo until a
> specified point in time, or until it encounters a STOP SCN in the redologs
> that is not followed by any further redolog entries.
>
> --
> Jeremiah Wilton http://www.wolfenet.com/~jeremiah
Received on Fri Jan 22 1999 - 10:42:59 CST