Re: noarchivelog recovery

Hi Nicolas,

One thing I forgot to mention.

If the delete occurred recently and might still be recorded on the online redo logs, you could look at using logmnr to extract the lost rows.

It's about your only hope.

Good Luck

Richard
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:Zd_b9.19603$g9.59891_at_newsfeeds.bigpond.com...
> Hi Nicolas,
>
> If you don't take frequent backups, if you don't keep your redo logs, it
is
> asking a bit much to have a protected database.
>
> Attempt a complete recovery (you might be 'lucky' and you may not have
> overwritten the redo logs since your last backup, but I doubt it) and if
> unsuccessful put this one down to experience, protect the database and
never
> let it happen again.
>
> A complete restore from your last backup is about it.
>
> Cheers
>
> Richard
> "Nicolás Marjovsky" <nmarjovs_at_insite.com.ar> wrote in message
> news:437b1332.0208301708.429e750_at_posting.google.com...
> > Hello.
> >
> > Is it possible to make a data recovery in this situation. If so, how
> > should I do it?(I´m running Oracle 8.1.7)
> > Archivelog is not active and someone made by mistake a "delete from
> > tablename", in some tables. We don't have recent database backups.
> >
> > Thanks in advance.
>
>
Received on Sat Aug 31 2002 - 03:10:42 CDT