Wednesday, May 14, 2008

File size is not a multiple of logical block size ORA-00202,ORA-27046

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

1 comment:

  1. The scenario based discussion is very helpful for novice DBA like me. Thanks
    aminul_osb@yahoo.com

    ReplyDelete