Re: Recovering Deleted Record

From: frank.sara <frank.sara_at_infonie.fr>
Date: Wed, 28 Mar 2001 22:02:45 +0200
Message-ID: <985810502.921545@remus.infonie.fr>

To recover a deleted record, use logminer. to recover all the database, use recover until. Anyway, in order to use recovery, you need a backup of your database FILE. The db need to be in archive mode.

In the v$logmnr_contents table, you'll find in the sql_undo column the insert statement that will reverse the deletion. You need the archived redo log to be able to do that.

Keeping your database in archive mode will let you trace all the deleted record with logminer. You can also use a database trigger. As for the audit option, i dont know if it will permit you to restore the record.

If you use recover until time, you will get your WHOLE DATABASE in the state that it was before the deletion of the record, which is not what you want i think.

Good luck!

Stan Powers <delphidev_at_yahoo.com> a écrit dans le message : 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 Wed Mar 28 2001 - 14:02:45 CST