Unloading data from oracle dbf files

oraclerestore

I have a list of oracle dbf files and I need to restore the information inside these files, there are no control files and anything else. only DBF file
http://s9.postimg.org/mxmx0g73j/Untitled.jpg

Is there any parsing tool or recovery tool that can open DBF files and unload the information in it..

Best Answer

There are 3 alternatives:

  • create a new controlfile and try to add those file in one or more tablespaces, they look part of a partitioned object (you might want to use dbverify before running create controlfile)

  • use UNIX strings command, this should recover some information, but not all...

  • use the BBED tool as documented here: http://orafaq.com/papers/dissassembling_the_data_block.pdf this is a powerful tool but takes a bit of time to master

Also, if you have Oracle Support contract you might try contacting them, it is their format, it is the easiest path to "success".. but probably the most expensive.

Related Question