URGENT ---- BIG MISTAKE --- HELP !!!!

Hi,

I was using a third party tool to drop tables from a tablespace.
When I confirmed the action, I noticed, too late, that the WHOLE TABLESPACE
was dropped.

Since this is a relatively small database, with only 4 users, we didn't have backup procedures
(WE WILL AS OF NOW!!!!!). We did manual backups once in a while, the latest one being
a few months ago. How can I restore the database as best as I can??

Can I use the REDO logs? How do I do this??

Please, detailed steps as I am not really a DBA.

Thanks.

several questions need to be answered!!!!

What Oracle version are you running on ???

The latest backup you had, what kind of backup is that ??? You can't use your redo log to recover your table when you dropped.

Oracle 8.1.7

Last backup was a full export end of December.

If you have cold or hot backup of your database and all archived redo logs since your last backup than you can restore your database from the backup on a different server and on the same server with the different name and roll forward up to the point where tablespace was dropped. Please state what kind of backup you have and whether you have all archived redo logs.

what all files did u lose in that tablespace/r u in archivelog mode or noarchive logmode?
then we can think up a strategy. The Q is to see how much of of data is going to be lost forver(meaning the period between end dec and now!)

what all files did u lose in that tablespace/r u in archivelog mode or noarchive logmode?
then we can think up a strategy. The Q is to see how much of of data is going to be lost forever(meaning the period between end dec and now!)

If you have the full export in Dec , you can recover that table but all of the data from DEc to now will be lost.


use import utility to import your table and the command as follow:

IMP USERNAME/PASSWWORD FILE=FILENAME.DMP LOG=RECOVER.LOG TABLES=THE TABLE WAS LOST


hope this will help

I am not running in ARCHIVELOG mode.
I have some REDO log files.

..........AH! I MIGHT BE A LUCKY MAN

It seems there is a .dmp file that was created this morning (at the fatal time).
Must have been done by the software, or Oracle, or GOD !!!!

I will be recreating the database from this export file and hope it works.

Quote:

---

Originally posted by DQuinn
I am not running in ARCHIVELOG mode.
I have some REDO log files.

..........AH! I MIGHT BE A LUCKY MAN

It seems there is a .dmp file that was created this morning (at the fatal time).
Must have been done by the software, or Oracle, or GOD !!!!

I will be recreating the database from this export file and hope it works.

---

Or a DBA :D

Angel

Hi

Can you mention in which directory u see the newly generated dump file?

This may not be a good news... as it was created at
the FATAL time !

Nandu
:(

Quote:

---

Originally posted by nandu
Hi

Can you mention in which directory u see the newly generated dump file?

This may not be a good news... as it was created at
the FATAL time !

Nandu
:(

---

What?

Error files are generated at fatal time, but not .dmp files. Maybe is not correct if not finished but ... if yes he/she should recover the database with this .dmp without problems.

Cheers

Angel

You can still open the database by offlining the databafile and tablespace. Only the problem will be you will not have all the tables and data of the tablespace.

However, as you mentioned in the previous post, if you have a DMP created last night that would be the best bet

IT WORKED !!!!!!

It seems that the 3rd party software I am using created an export file before dropping the tablespace (the file was created under one of its directories).

Using this export file, I was able to bring back the database to this morning (before my STUPID mistake).

Since this software saved my A**, I should probably mention its name. It is DBArtisan by Embarcadero.

OOPS... I forgot.

Sincere thanks to all who replied or worked at finding a solution. This forum is the best because of people like you.