ORA - 01122 Database file 1 failed verification check
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA - 01122 Database file 1 failed verification check

Hybrid View

  1. #1
    Join Date
    Feb 2002
    Posts
    4

    Unhappy

    Hi,
    I am new to Oracle.
    During start up i get the following message:

    ORA - 01122 Database file 1 failed verification check
    ORA - 01110 : DATA FILE 1 :
    "/home/oracle/product/9.0.1/oradata/oralin/system01.dbf"
    ORA - 01207 : File is more recent than controlfile - old controlfile

    Please let me know how can i fix that.
    Thank you.
    GK

  2. #2
    Join Date
    Sep 2002
    Posts
    21

    Hi list

    U have the old controlfile instead the current one so, the datafile can't sync with it(Mismatch in Ckpt no.). Check ur controlfile and restore the current one..
    bye
    Saravanan Oracle DBA(8i OCP)


  3. #3
    Join Date
    Feb 2002
    Posts
    4
    I am sorry for the rookie question, but how do you restore the current one ?
    Thanks for your time .
    GK

  4. #4
    Join Date
    Nov 2000
    Posts
    224
    It looks like the old controlfile is restored. If you can find copy of current control file then it is fine. Otherwise you may have to recover using the option USING BACKUP CONTROL FILE;

    I think this operation should not be perfomed by Rookie. But again, it is just a my opinion.

  5. #5
    Join Date
    Sep 2002
    Posts
    5

    Wink

    ORA-01122 database file string failed verification check
    Cause: The information in this file is inconsistent with information from the control file. See accompanying message for reason.
    Action: Make certain that the database files and control files are the correct files for this database.
    Ajmal Chishti

  6. #6
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by gk
    Hi,
    I am new to Oracle.
    During start up i get the following message:

    ORA - 01122 Database file 1 failed verification check
    ORA - 01110 : DATA FILE 1 :
    "/home/oracle/product/9.0.1/oradata/oralin/system01.dbf"
    ORA - 01207 : File is more recent than controlfile - old controlfile

    Please let me know how can i fix that.
    Thank you.
    GK
    Do the following.

    1. Take a trace of controlfile.

    SQL > alter database backup controlfile to trace;

    2. You can find the file in userdump dest. Open the trace file and edit for neccesary changes.

    3. Startup the database in nomount state.

    SQL > startup nomoun

    4. Run the controlfile script create in step 2

    SQL > @cfile.sql

    5. Recover the db

    SQL > recover database using backup controlfile

    6. Open the database.

    SQL > alter database open;

    I guess this works..
    -nagarjuna

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