"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3ebbbdd7$0$10625$ed9e5944_at_reading.news.pipex.net>...
> "Marc Eggenberger" <marc.eggenberger_at_itc.alstom.com> wrote in message
> news:MPG.1925bf3d3a28565e989690_at_H02374...
> > Hi there.
> >
> > I have a database running on Oracle 8.0.6 on WinNT.
> >
> > Its running in archive log mode.
> >
> > Some users did some wrong operations on the database. So strucural
> > change, but they altered data (did some delete statements and some
> > inserts). How can I restore the database to the point it was at today
> > 13.00?
> >
> > is this done with
> >
> > recover database until time '2003-05-09:13:00:00'
>
> Assuming you have gone back to a previous backup and have all logs then that
> command will indeed restore the database to how it was at 1pm. All
> subsequent changes will be lost. I'm not clear if this is what you want.
Just to add to what has been already said.You can restore till time as
you suggested yourself (if that has not been done that
already).Remember to recover using a backup controlfile for a time
based recovery if your backup is not recent.
Michael Ngong
Received on Fri May 09 2003 - 13:54:50 CDT
