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 -> Restore to now - 2 hours

Restore to now - 2 hours

From: Marc Eggenberger <marc.eggenberger_at_itc.alstom.com>
Date: Fri, 9 May 2003 14:36:33 +0200
Message-ID: <MPG.1925bf3d3a28565e989690@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'



??



-- 
mfg
Marc Eggenberger


Received on Fri May 09 2003 - 07:36:33 CDT












Original text of this message













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