View Full Version : recovery dbf

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

thanks :mad:

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).

8th April 2005, 06:34 PM

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.