Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    3

    Question Unanswered: Problem while starting database

    Hi,

    we treid to restore our database from tape backup. After restoring all files we tried to startup the datebase. We gor the following error messages.

    ora-01122
    ora-01110
    ora-01207

    Can someone tell us what to do to get the database to work again.

    Thanx!

  2. #2
    Join Date
    Jul 2002
    Posts
    8
    Hi,



    here is the output of the progam oerr.

    It looks, that your controlfiles does not fit to the database files ....

    Did you do a complete restore?
    ... all datafiles AND controlfiles and redologs etc?


    greetings, klaus




    oerr ora 01122


    01122, 00000, "database file %s failed verification check"


    // *Cause: The information in this file is inconsistent with information


    // from the controlfile. See accompanying message for reason.


    // *Action: Make certain that the db files and controlfiles are the correct


    // files for this database.





    oerr ora 01110


    01110, 00000, "data file %s: '%s'"


    // *Cause: Reporting file name for details of another error


    // *Action: See associated error message


    oerr ora 01207


    // *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.

  3. #3
    Join Date
    Jul 2002
    Posts
    8
    Hi,



    here is the output of the progam oerr.

    It looks, that your controlfiles do not fit into the database files ....

    Did you do a complete restore?
    ... all datafiles AND controlfiles and redologs etc?


    greetings, klaus




    oerr ora 01122


    01122, 00000, "database file %s failed verification check"


    // *Cause: The information in this file is inconsistent with information


    // from the controlfile. See accompanying message for reason.


    // *Action: Make certain that the db files and controlfiles are the correct


    // files for this database.





    oerr ora 01110


    01110, 00000, "data file %s: '%s'"


    // *Cause: Reporting file name for details of another error


    // *Action: See associated error message


    oerr ora 01207


    // *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.

Posting Permissions

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