Skip to Content
author's profile photo Former Member
Former Member

SAP ORA-01122 in dbcheck result

Dear gurus,

I am facing following error as a result of DBCHECK in db13.Please suggest me Action. Thanks a lot in advance.

BR0976W Database message alert - level: ERROR, line: 234410, time: 2012-04-16 07.03.32, mess

ORA-01114: IO error writing block to file 14 (block # 1)

BR0976W Database message alert - level: ERROR, line: 234420, time: 2012-04-16 07.03.32, mess

ORA-01122: database file 14 failed verification check

BR0976W Database message alert - level: ERROR, line: 234427, time: 2012-04-16 07.03.33, mess

ORA-01122: database file failed verification check

BR0976W Database message alert - level: ERROR, line: 234431, time: 2012-04-16 07.03.33, mess

ORA-01122: database file failed verification check

BR0976W Database message alert - level: ERROR, line: 234435, time: 2012-04-16 07.03.33, mess

ORA-01122: database file failed verification check

BR0976W Database message alert - level: ERROR, line: 234439, time: 2012-04-16 07.03.33, mess

ORA-01122: database file failed verification check

BR0976W Database message alert - level: ERROR, line: 234443, time: 2012-04-16 07.03.33, mess

ORA-01122: database file failed verification check

BR0976W Database message alert - level: ERROR, line: 234447, time: 2012-04-16 07.03.33, mess

ORA-01122: database file failed verification check

BR0976W Database message alert - level: ERROR, line: 234452, time: 2012-04-16 07.03.33, mess

ORA-01122: database file failed verification check

BR0976W Database message alert - level: ERROR, line: 234456, time: 2012-04-16 07.03.33, mess

ORA-01122: database file failed verification check

BR0976W Database message alert - level: ERROR, line: 234460, time: 2012-04-16 07.03.33, mess

ORA-01122: database file failed verification check

BR0976W Database message alert - level: ERROR, line: 234466, time: 2012-04-16 07.03.33, mess

ORA-01122: database file failed verification check

BR0976W Database message alert - level: ERROR, line: 234470, time: 2012-04-16 07.03.34, mess

Regards,

Sahil

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Apr 30, 2012 at 05:41 AM

    hi Sahil,

    hopefully, your problem will be resolved after recreate the temp tablespace, please find procedure to recreate temp tablespace.

    ORA-01114

    For ORA-01122

    File verification check failed [BRCONNECT]

    Cause: There is the following message in the Oracle alert log:

    ORA-01122: Database file failed verification check

    Action: Make sure you are using the correct data file and control file for the database and check the last recovery or database copy.

    the following note might be helpful

    SAP Note: 696141

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 30, 2012 at 07:32 AM

    Hi Sahil,

    have you launched a Restore on your System, or are you trying to perform an Homogeneous System Copy. This kind of message could appear if you made an incomplete Recovery of your DB.

    If not, launch a DBVerify of your DB and consider other checks explained in this OSS Note:

    Note 23345 - Consistency check of ORACLE database

    Regards

    Leo Capasso

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.