Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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
    • Was this article helpful?