Error Description:
-------------------------
Whenever you tried to start the database the database failed to mount. It retuen the following error message.
ORA-00202: controlfile: '/oradata2/data1/dbase/control01.ctl'
ORA-27046: file size is not a multiple of logical block size
Cause of the Problem:
------------------------
All of the control files were corrupted.
Solution of the Problem:
----------------------------
A)If you have backup of control file then restore the control file. How to restore control file from backup is discussed on Restore Control File from backup
B)If you don't have control file then re-create it.
How to create control file is discussed on, How to create control file
The scenario based discussion is very helpful for novice DBA like me. Thanks
ReplyDeleteaminul_osb@yahoo.com