Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restore to now - 2 hours
In article <3ebbbdd7$0$10625$ed9e5944_at_reading.news.pipex.net>, n-
litchfield_at_audit-commission.gov.uk says...
> "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.
Yes that is what I want.
Solved this issue.
thanks anyways
-- mfg Marc EggenbergerReceived on Fri May 09 2003 - 10:19:40 CDT
![]() |
![]() |