"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.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Fri May 09 2003 - 09:40:21 CDT
