ORA-00214: control file version inconsistent
Due to the power outage, one of my production database giving the following error.
When I try to startup the database the ORA-00214 controlfile inconsistent error occurred:
SQL> startup
ORACLE instance started.
Total System Global Area 662700032 bytes
Fixed Size 1250716 bytes
Variable Size 281021028 bytes
Database Buffers 373293056 bytes
Redo Buffers 7135232 bytes
ORA-00214: control file ‘C:\ORACLE\PRODUCT\10.2.0\ORADATA\SYMP\CONTROL03.CTL’
version 1021304 inconsistent with file
‘C:\ORACLE\PRODUCT\10.2.0\ORADATA\SYMP\CONTROL01.CTL’ version 1021301
Error: ORA-00214
Cause: An ORA-00214 is issued whenever Oracle detects an inconsistency between two mirrored copies of the control file.
All copies of the control file must have the same internal sequence number for Oracle to start up the database or shut it down in normal or immediate mode.
Action: Use a consistent set of control files.
That is, all the files must be for the same database and from same time period.
Before going to troubleshoot the above error, Please follow the Metalink Doc ID 1014751.6
Action plan:
OS: Windows 2003 R2 32-bit
Database version: 10.2.0.1
Step1: Find the controlfile location:
SQL> show parameter control
NAME TYPE VALUE
———————————— ———– ——————————
control_file_record_keep_time integer 7
control_files string C:\ORACLE\PRODUCT\10.2.0\ORADA
TA\SYMP\CONTROL01.CTL, C:\ORAC
LE\PRODUCT\10.2.0\ORADATA\SYMP
\CONTROL02.CTL, C:\ORACLE\PROD
UCT\10.2.0\ORADATA\SYMP\CONTRO
L03.CTL
Step2: Create and Edit the pfile from spfile:
SQL> create pfile=’C:\oracle\product\10.2.0\db_1\dbs\inittest.ora’ from spfile;
File created.
Step3: Remove the multiplexing controlfile of control_files parameter
Control_file=c:\oracle\product\10.2.0\oradata\symp\control01.ctl
Save
Now try to start the edited pfile:
SQL> startup nomount pfile=’C:\oracle\product\10.2.0\db_1\dbs\inittest.ora’
ORACLE instance started.
Total System Global Area 662700032 bytes
Fixed Size 1250716 bytes
Variable Size 281021028 bytes
Database Buffers 373293056 bytes
Redo Buffers 7135232 bytes
Step4: Try to mount & open the database with pfile:
SQL> alter database mount;
Database altered.
SQL> alter database open;
Database altered.
Step5: Now try to remove the multiplexed controlfile at os level.
C:\oracle\product\10.2.0\oradata>cd symp
C:\oracle\product\10.2.0\oradata\symp>dir
Volume in drive C has no label.
Volume Serial Number is 8048-4083
Directory of C:\oracle\product\10.2.0\oradata\symp
7,290,880 CONTROL01.CTL
7,290,880 CONTROL02.CTL
7,290,880 CONTROL03.CTL
524,296,192 IDCARD_TS.DBF
52,429,312 REDO01.LOG
52,429,312 REDO02.LOG
52,429,312 REDO03.LOG
377,495,552 SYSAUX01.DBF
513,810,432 SYSTEM01.DBF
269,492,224 TEMP01.DBF
68,165,632 UNDOTBS01.DBF
17,047,552 USERS01.DBF
12 File(s) 1,949,468,160 bytes
2 Dir(s) 245,401,767,936 bytes free
C:\oracle\product\10.2.0\oradata\symp>del CONTROL02.CTL
C:\oracle\product\10.2.0\oradata\symp>del CONTROL03.CTL
C:\oracle\product\10.2.0\oradata\symp>dir
Volume in drive C has no label.
Volume Serial Number is 8048-4083
Step6: Multiplex the controlfile with existing copy of controlfile (controlfile01.ctl) :
C:\oracle\product\10.2.0\oradata\symp>copy CONTROL01.CTL CONTROL02.CTL
1 file(s) copied.
C:\oracle\product\10.2.0\oradata\symp>copy CONTROL01.CTL CONTROL03.CTL
1 file(s) copied.
Step7: Start the database with existing default spfile:
SQL> STARTUP
Database started.
Now the database was successfully started without controlfile error.
let see the controlfile location:
SQL> Show parameter control
control_files=’C:\oracle\product\10.2.0\oradata\symp\control01.ctl’,’C:\oracle\product\10.2.0\oradata\symp\control02.ctl’,’C:\oracle\product\10.2.0\oradata\symp\control03.ctl’
Please follow the Metalink Doc ID 1014751.6
