ORA-00214: controlfile inconsistant
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-00214: controlfile inconsistant

  1. #1
    Join Date
    Aug 2006
    Posts
    6

    ORA-00214: controlfile inconsistant

    hello Dear oracle masters

    The story is below plz tell me solution i am very new to oracle
    i dont have any cold backup of data,log or controle files.

    after electric failure when i tried to startup my db it return following error

    Plz give my simple solution

    SVRMGR> startup
    ORACLE instance started.
    Total System Global Area 83605532 bytes
    Fixed Size 75804 bytes
    Variable Size 57016320 bytes
    Database Buffers 26435584 bytes
    Redo Buffers 77824 bytes
    ORA-00214: controlfile 'D:\ORACLE\ORADATA\DATA\CONTROL01.CTL' version 11541 inco
    nsistent with file 'D:\ORACLE\ORADATA\DATA\CONTROL03.CTL' version 11538




    thanks in advance
    nawaz

  2. #2
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    ohhh boy, then start doing a cold backup now at least u will have
    a fallback if u encounter more error afterwards.
    I guess the system was writing on the first control file when the
    power failed, so it was not able to sync in to the other control files.
    You may try to startup mount and recover database.
    But wait for davey and the other gurus they might have a better
    solution but as far as my knowlegde is concerned, i guess this
    will also what they will tell you
    Last edited by yxez; 09-04-2006 at 06:33 AM.

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    hi,
    you have a slim chance of recovering your db since you don't have a backup.

    Try to backup it up now b4 anything else, in case you commit mistake during recovery you got something to draw back.

    Move one of the controlfile out, then try to copy one of the control file to the other and restart your db with mount option. If it does not work, copy the controlfile you have moved out to the 2 controlfiles. And restart the db again with mount option.

    Notice the naming convention like control01, control02
    ---------------

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width