help me regarding " database file 1 failed verification check" error
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: help me regarding " database file 1 failed verification check" error

  1. #1
    Join Date
    May 2007
    Posts
    5

    help me regarding " database file 1 failed verification check" error

    hi all
    I tried to exceute the
    1.Alter index ORDERLINEITEMJOURNAL_IX1 rebuild;
    2.Alter index ORDERLINEITEMJOURNAL_PK rebuild;
    on my database on the database server which is at remote location ,so i am accessing it through putty.During the second alter indexd command my server got hanged so i closed the the session(putty) and when again i tried to start the oracle, i got the following error

    SQL> startup
    ORACLE instance started.

    Total System Global Area 227455136 bytes
    Fixed Size 73888 bytes
    Variable Size 58576896 bytes
    Database Buffers 167772160 bytes
    Redo Buffers 1032192 bytes
    Database mounted.
    ORA-01122: database file 1 failed verification check
    ORA-01110: data file 1: '/data1/seek01/system01.dbf'
    ORA-01207: file is more recent than controlfile - old controlfile


    can anybody please help me to solve this error. is there any recovery option? so that i am able to start the oracle as it was working fine befor running the alter index command. It's very urgent.


    Regards
    pandurang

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    why was the database down - what did you do to get it into that state

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    oerr ORA 1207
    01207, 00000, "file is more recent than controlfile - old controlfile"
    // *Cause: The controlfile change sequence number in the data file is
    // greater than the number in the controlfile. This implies that
    // the wrong controlfile is being used. Note that repeatedly causing
    // this error can make it stop happening without correcting the real
    // problem. Every attempt to open the database will advance the
    // controlfile change sequence number until it is great enough.
    // *Action: Use the current controlfile or do backup controlfile recovery to
    // make the controlfile current. Be sure to follow all restrictions
    // on doing a backup controlfile recovery.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  4. #4
    Join Date
    May 2007
    Posts
    5
    actually the database not got down the whole server got down as we are facing the problem from last few days. please tell me the solution how to recover from those errors

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you need to explain what you did to get it into that state (and dont say nothing)

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    What's your backup/recovery strategy?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    May 2007
    Posts
    5
    as i am not able to recover the current database but i have backup of whole database so i am thinking to create the new database eventhough i have current database on my database server.
    Whether it will crash my oracle if i will create new database in addition to database that i have not able to recover

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Shall we understand that you have a cold backup?
    Is it good enough for you?
    Have you previously tested your recovery strategy?

    You can have multiple Oracle instances in your box pointing to the same ORACLE_HOME, no problem.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  9. #9
    Join Date
    May 2007
    Posts
    5
    can you will tell me steps how to create the new database in oracle which is on linux through command mode as i am not able to access the UI mode of the linux.can i able to create the new sid for this new database through the command mode. please help me it is really critical

    regards
    pandurang

  10. #10
    Join Date
    May 2007
    Posts
    5
    i have the backup as dmp file of my whole database

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