V$LOGHISTORY & control files

From: Mike Burden <michael.burden_at_capgemini.co.uk>
Date: Fri, 22 Jan 1999 09:44:16 +0000
Message-ID: <36A8486F.39EB2453@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 - 03:44:16 CST