Re: Recovering Deleted Record

What do you mean?
Are you trying to say I said something that is not true, or is it a real question?
All I can say is that when you do a recover until TIME and oracle runs out of .ARC files, you can instruct it to read .RDO files and it will be happy with that.

Regards,

Syltrem
http://pages.infinit.net/syltrem

"Stan Powers" <delphidev_at_yahoo.com> a écrit dans le message news: vNMv6.283707$v.33089064_at_typhoon.nyroc.rr.com...
> 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 - 14:54:02 CST