ORA-00214: control file error

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:

---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 display
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 bytes
Fixed Size                  8749920 bytes
Variable Size             687869088 bytes
Database Buffers         1795162112 bytes
Redo Buffers                8024064 bytes
ORA-00214: control file
'D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL' version 8686
inconsistent 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 bytes
Fixed Size                  8749920 bytes
Variable Size             687869088 bytes
Database Buffers         1795162112 bytes
Redo Buffers                8024064 bytes
Database mounted.
SQL> create spfile from pfile;
 File created.

 ----shutdown the database
SQL> 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 bytes
Fixed Size                  8749920 bytes
Variable Size             687869088 bytes
Database Buffers         1795162112 bytes
Redo Buffers                8024064 bytes
Database mounted.
Database opened.

Laptop USB C Docking Station Dual Monitor 14 in 1 Triple Display USB C Hub for MacBook/Dell/HP/Lenovo Dual HDMI 4K, DP 8K, PD Charger, Gigabit Ethernet, 6 USB Ports, SD/TF Card Reader, Mic/Audio

$69.99 (as of 02/07/2024 16:04 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

【14 in 1 USB C Docking Station】Plug and play, Easy to Use. NO additional driver required.This USB-C docking station dual monitor easily convert your laptop’s USB-C/thunderbolt 3/Type C Port into 14 Ports:Dual Monitor 4K HDMI, DP Display port（8K@30Hz）... read more

PC Gaming Headset Headphone Hook Holder Hanger Mount, Headphones Stand with Adjustable & Rotating Arm Clamp, Under Desk Design, Universal Fit, Built in Cable Clip Organizer EURPMASK

(27325)

$12.99 (as of 02/07/2024 16:14 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

🎧【Clamp-on Headphone Stand】The E-Hold Series headphone holder fits desks from 0.31 inch to 1.57 inch thick, making it a versatile choice for most setups. The spring clamp is a breeze to remove and reattach. No glue, no mess. It blends seamlessly into... read more

Laptop Cleaning Kit Keyboard Cleaner, Keyboard Cleaning Kit Electronics Cleaning Tool for MacBook iPad Phone iPhone Pro, Brush Tool for Tablet, Computer, PC, TV Camera Lens Computer Vacuum Keyboard

(2045)

$16.98 (as of 02/07/2024 16:14 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

DEEP CLEAN YOUR DEVICE The electronics cleaner kit can effectively deep clean all your electronic devices such as mobile phones, tablets, TVs, etc. It comes with retractable large keyboard brush, polishing cleaning cloth X 2, keycap puller, metal pen... read more

HUANUO 2 Tier Monitor Stand, Metal Monitor Riser with Drawer, Desk Organizer, Monitor Stand with Storage, Desktop Computer Stand for PC, Laptop, Printer

$29.99 (as of 02/07/2024 16:32 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

【Sturdy Desk Stand with Strengthened Construction】- The "H" shape construction increases the duration. This monitor stand easily hold monitors, printers up to 33lbs. Never worry about the drawer will not be easy to open. 【Ergonomic Monitor Stand Rise... read more