startup failed , ora-1122
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: startup failed , ora-1122

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    startup failed , ora-1122

    did a startup. got the below

    ORA-01122: database file 7 failed verification check
    ORA-01110: data file 7: '/oracle/SID/data10/myfile/myfile.data1'
    ORA-01207: file is more recent than controlfile - old controlfile



    select * from v$recover_file;
    got 15 rows selected.


    what can i do to get it started up?

  2. #2
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    You're going to have to do some media recovery as its likely your datafiles and controlfiles are out of sync:
    start the DB up using the current controlfile
    Apply media recovery if the current archive logs are available
    Or
    restore a backup of the controlfile and perform media recovery using the USING BACKUP CONTROLFILE COMMAND

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    more importantly what cause this error? did you have some sort of failure? abnomral termination of instance? what happened?
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Oct 2002
    Posts
    391
    its abnormal termination of instance. it went down just like that.

    checked my alert file, lots of ora-600 before it went down

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by yls177
    its abnormal termination of instance. it went down just like that.

    checked my alert file, lots of ora-600 before it went down
    Don't waste time here, raise a iTAR.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    Oct 2002
    Posts
    391
    mine is on sap environment. still can raise itar?

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