Re: noarchivelog recovery

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sat, 31 Aug 2002 17:37:27 +1000
Message-ID: <Zd_b9.19603$g9.59891@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 - 02:37:27 CDT