Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Restore to now - 2 hours

Re: Restore to now - 2 hours

From: Marc Eggenberger <marc.eggenberger_at_itc.alstom.com>
Date: Fri, 9 May 2003 17:19:40 +0200
Message-ID: <MPG.1925e576b3f31a0e989692@H02374>


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 Eggenberger
Received on Fri May 09 2003 - 10:19:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US