Re: noarchivelog recovery

Approximately one hour after de deletions I made a copy of the instance files. Do you think I have a chance of getting the info back? How should I do it? I've tried this procedure but is not working.

From svrmgrl

1. Shutdown immediate
2. startup mount exclusive
3. ALTER DATABASE RECOVER UNTIL TIME '29-aug-2002 16:00:00'
4. shutdown immediate
5. startup
6. ALTER DATABASE OPEN RESETLOGS

Thanks again.

"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 - 11:25:35 CDT