Re: Recovering Deleted Record

From: Syltrem <syltrem_at_videotron.ca>
Date: Mon, 26 Mar 2001 14:06:31 -0500
Message-ID: <4lMv6.146$qO6.38023@wagner.videotron.net>

If you have archiving enabled you can ALTER DATABASE RECOVER UNTIL (time or SCN) and get the record back if you know of a time at which it was still there. Then if you want to get back to the exact point in time where you stopped your database to do this recovery, you can save the data somewhere (EXPort for example) then do a recovery a 2nd time and let it run through all of the archive files.

It may take some time but can can certainly be done.

Others may confirm, but if that DELETE is still in your online redo logs and you are not have archiving enabled, it should still work. Oracle can recover from your online redo logs if you don`t delete them and don`t overwrite them with a backup copy when doing the restore.

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS web site)

"Stan Powers" <delphidev_at_yahoo.com> a écrit dans le message news:
PeLv6.283480$v.33042421_at_typhoon.nyroc.rr.com...


> How is it possible to recover a record deleted accidentally?  Is this

> information stored in the Redo logs?  Or a Audit Log?

>

> Is there a way that I can configure my database so that it maintains a

 log,


> and copy for that matter, of all deleted records?

>

> Thanks, Stan.

>

>

Received on Mon Mar 26 2001 - 13:06:31 CST