SAP Knowledge Base Article - Preview

2493858 - ORA-10567 Redo is inconsistent with data block (file# %s, block# %s, file offset is %s bytes)

Symptom

ORA-00600: internal error code, arguments: [3020], [19], [2909271], [82601047],
[], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 19, block# 2909271, file
offset is 2357911552 bytes)
ORA-10564: tablespace PSAPSR3
ORA-01110: data file 19: '/oracle/XYZ/sapdata1/sr3_16/sr3.data16'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 240707

Note: This kind of corruption can not be detected with any tools. Only an active recovery can detect this error.

Above error happens 

either

  1. in Standby Database (Data Guard Configuration)
    1. Oracle Alert Log
    2. Oracle Data Guard "Broker Log File"
       

or

  1. during a Recovery Scenario in SQLPLUS Prompt

 


Read more...

Environment

  • SAP Release Independent
  • Oracle RDBMS Release Independent
  • UNIX / Linux
  • Windows

Keywords

corruption, logical, physical, restore, recovery, ORA-00600, ORA-600, consistency check, RMAN, DBV, export, import, BR*Tools, brtools, brrestore, brrecover , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.