I have Oracle 11g release 2.

My database is crash.I have only one datafile of billing.in which all important information is store.

I do not have dump.I have only one .dbf file.

Now I want to use this file when I create new database to regenerate data.

But how can I use that datafile?

As long as there is an intact datafile, there is hope:-)

But there is indeed no easy way to get your data back. As Aman suggested, contact Oracle Support immediately.

Do not try to resolve this by yourself resp. by some clever advices from the internet!

Oracle Support has utilities like DUL to read your datafile without accessing it through an instance.

PRM-DUL is another alternative recovery unload tool can be found here:DBRECOVER for Oracle

DBRECOVER Recovery Options

For Oracle incidents, start with the DBRECOVER for Oracle trial to verify table visibility, row previews, and export readiness on copied datafiles. For MySQL and InnoDB incidents, DBRECOVER for MySQL is free software and can inspect.ibd files, ibdata1, and database directories locally.

When the case is urgent, preserve the original files first, work from copies, and contact paid emergency support with the database version, platform, error messages, file list, and recovery objective.

Archive ParnassusData Blog Migration Archive