CONTROL FILE CORRUPTION ISSUE

Issue :

--------

While startup the database, it shows the following error message,

ORA-00204: error in reading (block 3, # blocks 8) of control file

ORA-00202: control file: 'C:\ORACLEXE\ORADATA\XE\CONTROL.DBF'

ORA-27091: unable to queue I/O

ORA-27070: async read/write failed

OSD-04006: ReadFile() failure, unable to read from file

O/S-Error: (OS 23) Data error (cyclic redundancy check).

Solution :

-------------

1.   Try to multiplex corrupted control file.

(ie) shut immediate, copy and paste another control file named with this corrupted one and start the database with pfile.

2. Another hand, you may remove the corrupted control file entry from pfile, then start database with pfile and create spfile.
3. This second step will help in all kind of situations;

The main thing we can manage to start the database using a single control file itself and also all the control files are having the same content.