Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    10

    Unanswered: Abnormal shutdown database

    hi

    My system is abnormally shutdown due to UPS fail.when i starting the database there is an error " control file3 version inconsisstant with control file 1"
    how to rectify the problem?

  2. #2
    Join Date
    Jan 2004
    Location
    Hyderabad, India
    Posts
    37
    Hi,

    You can try the following..

    1. Take the backup of all the control files.

    2. Then copy controlfile1 to all the remaining controlfiles. Then try starting the database.

    IF the problem still exist, then try copying controlfile2 to all the remaining files and try again.

    Suneel
    Regards
    Suneel

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    The simpliest way to correct it is to use operating system COPY command and copy a good control file into directory that contains bad (damaged) control file.

    But, if the disk that contains your damaged control file is also damaged due to loss of power, you'll have to restore a good control file elsewhere. In such a case, you'll also have to redefine CONTROL_FILES initialization parameter so that it'll point to the right (new) place of your control file.

Posting Permissions

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