Re: V$LOGHISTORY & control files

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Fri, 22 Jan 1999 07:57:19 -0800
Message-ID: <Pine.OSF.4.02.9901220750490.22099-100000@gonzo.wolfenet.com>

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 - 09:57:19 CST