Re: Restore to now - 2 hours

"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'
>

It certainly is. It's known as an incomplete recovery, and you might want to read up on those before trying one. But in general, the procedure is: shutdown the database. Restore ALL datafiles (but not the control files or online redo logs). Startup mount. Recover database until time <etc etc etc>. Alter database open.

You will of course lose any data committed after your 'until time'.

If it's just one or two tables that have been 'damaged', and you don't fancy losing committed data on the entire database in order to repair the damage, then you can consider using import to restore the tables concerned (assuming you have an export dump file, of course, and assuming the last export was done fairly recently).

Regards
HJR Received on Fri May 09 2003 - 14:39:16 CDT