How to fix ORA-00214 error in Oracle Database?

If your Oracle database is not working fine, it is not necessary that database can encounter many problems with the database but if in this situation the database gets shutdown due to sudden power cut. Then after restarting the database it gives error messages such as ORA-00214 as shown below:

SQL>startup

Oracle instance started

Total System Global Area 83605532 bytes

Fixed size 75804 bytes

Variable size 57016320 bytes

Database Buffers 26435584 bytes

Redo Buffers 77824 bytes

ORA-00214:controlfile’D:\ORACLE\DATA\CONTROL01.CTL’version11541 inconsistent with file ’D:\ORACLE\ORADATA\DATA\CONTROL03.CTL’version11538

“ORA-00214: control files "string" version string inconsistent with file "string" version string.”

Cause of occurrence of this error: 

·         If you tried to move one or more copies of control files at different location when Oracle database was up and running.

·         If you tried to restore data from the database backup but your backup has not taken properly. It may take the database when it is up and running.

·         The database or the system gets corrupted or deleted during updating process.

How to fix ORA-00214 error in OracleDatabase?

1.    Firstly shutdown the database if it was on. If the database gets shutdown then you need to do it.

2.    If you have edited the CONTROL_FILES parameter from init.ora and modified if by adding one copy of control file then.

3.    Start the Oracle database restricted mode with Startup Restrict. You will get error messages then go back and perform the second step with another control file or else go with the next step.

4.    Shutdown the database with SQL>shutdown command.

5.    Copy the minor copied control files that are used to bring the Oracle database up and running.

6.    Then edit the init.ora file of the control files to add all the mirror copy.

Also read: How to Protect Silent Data Corruption in Oracle

7.    At last start the Oracle database and you can see the problems are fixed.

 But if still the problem is not fixed with the database then use the Oracle File Repair Tool to fix all the issues that are related to database and data-files of Oracle database.