Oracle Database - Please help restore after RAID controller corrupted some files
Posted on 2011-03-17
I have a server which runs a production Oracle database. The RAID controller borked and took a few files with it. After getting the O/S back up and running, the Oracle service tries to start, but I get the following error:
ORA-00214: control file 'CONTROL01.CTL' version 16371 inconsistent with file 'CONTROL02.CTL' version 16356
I have 3 control files. I have tried deleting each of them individually, but that results in different errors, depending which I remove. I have also tried copying 01 over the other two, as well as 02 and 03. If I use 02 or 03 for all of them I get:
ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], , , [0x000000000], , , , 
If I use 01 for all of them I get:
ORA-00227: corrupt block detected in control file: (block 23, # blocks 1)
ORA-00202: control file: 'CONTROL03.CTL'
..strange to me that it throws the error in CONTROL03 instead of 01, but I guess it doesn't have to read them in alpha order.
How can I get the Oracle database to mount?