Re: noarchivelog recovery

Most important thing is that you make a copy of all online redolog files as soon as possible after the incident. Looks like the copy of the files you made "one hour after" is the best.
Depending on how much activity took place in that hour and the size of the redolog files, the timestamp before the deletion is or is no more in the redologfiles.
Unfortunately you did an open resetlogs so you can't get any info from the current database (v$log, v$loghistory).

You could use Logminer utility to reconstruct the deleted data from the redologs - provided the info is in it.
You can run logminer on any database to analyze the redologs you saved. (Although I had problems to read redologs from Solaris under Windows NT, so you must use the same platform, Oracle version can be same or higher). A search with "logminer" on Metalink returns many usefull notes, like 111886.1 "how to setup logminer".

Nicolás Marjovsky <nmarjovs_at_insite.com.ar> schreef in berichtnieuws 437b1332.0208310825.50af591a_at_posting.google.com...
| 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 Sun Sep 01 2002 - 03:23:29 CDT