How can I start the database again in Oracle?

Question

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00204: error in reading (block 3, # blocks 8) of control file
ORA-00202: control file:
'I:\ORACLE\PRODUCT\10.2.0\ORADATA\SECONDDB\CONTROL01.CTL'
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).


What shoul i do now to start the database?

Answer 1

Actually the error seems to be more like a physical corruption of the file, as indicated by the source error ("(OS 23) Data error (cyclic redundancy check).")



You may wan to run a check disk on that drive.



There should be multiple copies of the control file (3 by defaut) in the same location. If the error is for only one of them, you should be able to start the database using one of those copies.



I advise that you contact Oracle support. You do have a support contract, do you ?

Answer 2

The first error you're encountering is trying to read from a disk that isn't there or is corrupt (Hopefully the first and you just have to mount it.) Sort that out and other problems should go,



I'd read up on this before attempting again. Oracle's own online documentation is very good.

Answer 3

Ora-00202 Control File