Oracle Inconsistent Control Files Error ORA 00214

Follow the following steps if you are facing inconsistent control files error ORA-00214 in oracle database.

Step 1:

open the sqlplus and connect as sysdba user by the following command

conn / as sysdba

and enter password

Step 2:

Execute the following commands

shutdown immediate;

STARTUP NOMOUNT;

Step 3:

Execute the following commands and you may change the path of control file if any.

alter system set control_files=C:>oracleproduct10.20.0db10g1CONTROL01.CTL scope=spfile;

show parameter control_files;

shutdown immediate;

startup mount;

recover database;

alter database open;

Step 4:

If the error of inconsistent control files continues repeat step 2 and 3. And change the control01.CTL to control02.CTL or  control03.CTL