Re: Recovering Deleted Record

Syltrem, how do you view the contents of Online Redo Logs? Stan.

"Syltrem" <syltrem_at_videotron.ca> wrote in message news:4lMv6.146$qO6.38023_at_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:30:35 CST