Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    102

    Unanswered: cannot open database

    Hi all,

    I installed oracle 9i in RedHat 9 and created tablespaces . but when i startup database then the following errors occured.

    database mounted
    ORA-01122: database file 11 failed verification check
    ORA-01110: data file 11: '/ora_proj/user_tablespace/user.dat'
    ORA-01251: Unknown file Header Version read for file number 11

    Now i what to know why the error occured and Is there any way to solve the problem and what is the solution.

    Thanks in advance for your help.
    Working Together...

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    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.

    ORA-01110 data file string: 'string'
    Cause: This message reports the file name involved with other messages.
    Action: See the associated messages for a description of the problem.


    My first thought, therefore, would be to check your control file.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jul 2004
    Posts
    102
    Waht is the command to execute control file after it edit ?
    Working Together...

  4. #4
    Join Date
    Oct 2004
    Posts
    4

    Thumbs up Restore the old backup

    Dear friend,

    You have a need of the restore the datafiles from the last good backup.
    Nothing else.

    Thanks have best of luck

    Gitesh Trivedi
    Sr.Oracle DBA
    Lubi Electronics

Posting Permissions

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