ORA-00214: control file error ? How to solve version inconsistency error on control files?
meda Changed status to publish 16/07/2022
Control file version inconsistency occurs when CONTROL_FILES parameter file contains two different versions of controlfiles at the time of instance startup. And the solution is , drop the control file having less version number and copy from controlfile having latest version number and re-name it to its original name.
Example:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 | ---Shutdown your database and manually replace the controlfile 'CONTROL01.CTL' below with old controlfile.SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down. --- startup your database from pfile, at mount state, then ORA-00214 error will displaySQL> startup pfile='D:\app\Admin\virtual\virtual\product\12.2.0\dbhome_1\database\INITPRIMARY.ORA' mount;ORACLE instance started. Total System Global Area 2499805184 bytesFixed Size 8749920 bytesVariable Size 687869088 bytesDatabase Buffers 1795162112 bytesRedo Buffers 8024064 bytesORA-00214: control file'D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL' version 8686inconsistent with file 'D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\CONTROL01.CTL'version 3955 ----Again shutdown the database and drop the controlfile 'CONTROL01.CTL' above and re-create it from 'CONTROL02.CTL' and rename it again to 'CONTROL01.CTL' SQL> shutdown immediate;ORA-01507: database not mounted ORACLE instance shut down. -- Then startup mount the database and create spfile from pfile.SQL> startup pfile='D:\app\Admin\virtual\virtual\product\12.2.0\dbhome_1\database\INITPRIMARY.ORA' mount;ORACLE instance started. Total System Global Area 2499805184 bytesFixed Size 8749920 bytesVariable Size 687869088 bytesDatabase Buffers 1795162112 bytesRedo Buffers 8024064 bytesDatabase mounted.SQL> create spfile from pfile; File created. ----shutdown the databaseSQL> shutdown immediate;ORA-01109: database not open Database dismounted.ORACLE instance shut down. ----Finally, Startup the database and will work perfectly.SQL> startup;ORACLE instance started. Total System Global Area 2499805184 bytesFixed Size 8749920 bytesVariable Size 687869088 bytesDatabase Buffers 1795162112 bytesRedo Buffers 8024064 bytesDatabase mounted.Database opened. |
meda Edited answer 22/02/2022