Re: Rolling forward logical logs
Posted in 1997
David Williams — — source: Informix-list mailing list archive (1991-1998)
In article <3317430B.4E00@netcomuk.co.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >Suppose I take an archive at 0300. At 0900 the users tell me that an >application error has occurred, and the wish to have the database >restored to its state at or before 0600. I interrogate the online.log >and note that in between 0300 and 0900 logs 1-10 have been completed, >and have been backed up using continuous logging. Log 6 completed at >0555. > >How would I roll-forward, after restore, applying the changes contained >only in logs 1-6, stopping at the end of 6 and disregarding 7-10? > >Thanks > >Neil Truby Use Online 7.2 which allows you to rollforward up to a given point in time. -- David Williams