cancel
Showing results for 
Search instead for 
Did you mean: 

How to recover an SAP instance when a control file got corrupted?

Former Member
0 Kudos

Hi experts,

How to recover an SAP instance when a control file got corrupted(oracle database)?

Please help me as soon as possible.

Regards

subramanyam reddy

Accepted Solutions (1)

Accepted Solutions (1)

ACE-SAP
Active Contributor
0 Kudos

Hi

Check the DB alert log, there are by default 3 control files on a Oracle DB used by SAP.

Maybe only one of them is corrupted and you can overwrite it with another one that is clean.

If not you can use the note referenced by Sunil to recreate the control file.

Watch out before recreating control file you will need to rename / delete the existing ones.

You can find the location of the control files from the Oracle pfile copy created by BR*Tools in

     Windows       D:\oracle\<SID>\11203\database\init<SID>.ora

     Unix             /oracle/<SID>/112_64/dbs/init<SID>.ora

Regards

Answers (2)

Answers (2)

former_member188883
Active Contributor
0 Kudos

Hi Subramanyam,

Refer steps in the link http://amit7oracledba.blogspot.in/2012/10/how-to-recreate-control-file-in-oracle.html

Hope this helps.

Regards,

Deepak Kori

Former Member
0 Kudos

note 1889854 - Recreation of the Control file should help you to recreate the control file.