Oracle database fails to start, error message: ORA-00214: control file control02.ctl [...] inconsistent with file control01.ctl
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Problem Symptoms:
Example: Aleph
When trying to start the Oracle database the following error message appears:
ORA-00214: control file '/exlibris/oradata/aleph20/aleph20_control02.ctl' version 3084012
inconsistent with file '/exlibris/oradata/aleph20/aleph20_control01.ctl' version 3084010
The error message appears before the database can be mounted.
Cause:
The database crashed while the mirrored copies of the Control File were being updated, causing them to be out of sync.
Resolution:
Important note:
===============
The following steps should be carried out by an experienced Oracle DBA who is familiar with backing up and recovering databases.
Outline of solution:
--------------------
-- open the database with a single valid copy of the Control File
-- shut down the database
-- copy that version of the Control File onto the other mirrored copies
Steps:
------
Example: Aleph
(1)
Assuming that the Control File aleph20_control01.ctl is the valid one, change the database initialization parameter control_files
from:
*.control_files='/exlibris/oradata/aleph20/aleph20_control01.ctl','/exlibris/oradata/aleph20/aleph20_control02.ctl','/exlibris/oradata/aleph20/aleph20_control03.ctl'
to:
*.control_files='/exlibris/oradata/aleph20/aleph20_control01.ctl'
(2)
Start the Oracle database. Make sure that no error messages appear.
(3)
Shut down the database.
(4)
Copy the Control File aleph20_control01.ctl onto the Files aleph20_control02.ctl and aleph20_control03.ctl.
(5)
Change the database initialization parameter control_files back to:
*.control_files='/exlibris/oradata/aleph20/aleph20_control01.ctl','/exlibris/oradata/aleph20/aleph20_control02.ctl','/exlibris/oradata/aleph20/aleph20_control03.ctl'
(6)
Start the Oracle database for normal operation.
Additional Info
Source: My Oracle Support Note 1014751.6 "ORA-00214: On Startup Or Shutdown"
- Article last edited: 02-Mar-2016