SAP ORA-01122 in dbcheck result

[Former Member]

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

[Former Member]

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

[former_member182034]

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,