Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

database recovery from .dbf files

JaiHind_0007Jun 14 2018 — edited Jun 15 2018

Hello,

I want to recover data from .dbf files which is in mount point /oradata,

and my oracle engine was installed at /u01 which was corrupted and showing disk checking error after that i installed new oracle engine at /u01 (oracle 10g) previous version and this version is same,

What I did I created new database and then create pfile from spfile and make changes in it and give the reference of /oradata/control.ctl file then i am trying to run it at mount stage at it is showing

error:-

ORA-00202: control file: '/u01/app/oracle/oradata/afrestst/control03.ctl'

ORA-27047: unable to read the header block of file

this is happening with all 3 control files.

Now what I have to do in order to recover my database please guide me....

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2018
Added on Jun 14 2018
33 comments
4,454 views