PDA

View Full Version : recovery dbf



talkstock888
8th April 2005, 03:24 PM
Hi
I remove dbf in oracle 9 is any way i can be recover those files.

thanks :mad:

bob
8th April 2005, 06:05 PM
Unfortunately, it's gone. Unless you specifically move an item to the trash can, once you delete it, there's no way to recover it (short of paying big bucks for commercial recovery specialists).

james_in_denver
8th April 2005, 06:34 PM
Ouch....

Did you by any chance have a backup and the archivelog feature enabled???

If you have a backup, and the old archivelogs, you can restore the database by using the datafile backup and applying the archived redo logs.....

have you used "exp" to export any data recently??? if so, you create a new empty tablespace and import the data, though depending on your tablespace/datafile layout/backup strategy, that may be impossible.