ORA-00214 – Controlfiles inconsistent

Today’s morning started with “ORA-00214”.I get happy when i get errors or issues.Coming back to point, here i would show the steps taken to resolve it.

“An ORA-00214 is issued whenever Oracle detects an inconsistency between two mirrored copies of the control file.”

One of the UAT db was unable to mount cause of inconsistencies in the multiplexed controlfiles. It gave the below error during startup :-

sql> startup
ORACLE instance started.

Total System Global Area  209715200 bytes
Fixed Size                  1295896 bytes
Variable Size             146803176 bytes
Database Buffers           54525952 bytes
Redo Buffers                7090176 bytes
ORA-00214: controlfile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\CONTROL01.CTL' version 17404
inconsistent with file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\CONTROL03.CTL' version 17409

Steps taken to resolve it:-

1. Show parameter control_file

2. As from the above error it could been seen that the version <number> for CONTROL03.CTL is higher, compared to CONTROL01.CTL, so

sql> alter system set control_files='D:\oracle\product\10.2.0\oradata\CONTROL03.CTL' scope=spfile;

sql> shutdown immediate;

sql> startup mount; --> The mount was successful.

sql> alter database open;

Checked for is some error in alert log.Everything seemed to be ok.Changed the control_files parameter,switched the logfile groups and the made the database down.

sql> alter system set control_files='D:\oracle\product\10.2.0\oradata\CONTROL01.CTL',
'D:\oracle\product\10.2.0\oradata\CONTROL02.CTL','D:\oracle\product\10.2.0\oradata\CONTROL03.CTL' scope=spfile;

sql> alter system switch logfile;
sql> alter system switch logfile;
sql> shutdown immediate;

Copied the CONTROL03.CTL , made two copies of it ,renamed it to CONTROL01.CTL and CONTROL02.CTL and started up the database.

sql >startup
ORACLE instance started.

Total System Global Area  209715200 bytes
Fixed Size                  1295896 bytes
Variable Size             146803176 bytes
Database Buffers           54525952 bytes
Redo Buffers                7090176 bytes
Database mounted.
Database opened.
sql>
sql>

NOTE:- When in step 2 the control_files parameter was set to ‘D:\oracle\product\10.2.0\oradata\CONTROL01.CTL’, SCN mismatch occurred between the redo logfiles and the controlfile and the database didn’t go to mount stage.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s