SAP Knowledge Base Article - Preview

1812719 - Eliminate DBV-00201 and ORA-26040


I. During a recovery or a system refresh  one of the following messages occurs:

  1. DBV shows the following error:

    BR0398W DBVERIFY has detected corrupt blocks
    DBV-00201: Block, DBA 1154567432, marked corrupt for invalid redo

  2. V$DATABASE_BLOCK_CORRUPTION contains such a row:

       9       5     129573          4       3253280299   NOLOGGING

II. Or you observe the following messages in Oracle Alert Log


          ORA-01578: ORACLE data block corrupted (file # 343, block # 383621)

          ORA-01110: data file 343: '/oracle/BP1/sapdata21/sr3_326/sr3.data326'

          ORA-26040: Data block was loaded using the NOLOGGING option


                              Here the last ORA- message is very important!



  • SAP Release independent
  • Oracle Database Release independent
  • Operating System independent


Logging while Index,SPRO,IMG,corruption,RMAN,DBV,ANALYZE,verification,check,consistency,ORA-26040,DBV-00201,DBV-201,soft corruption,nologging,dbv,rman,datapump,data pump,expdp,impdp,exp,imp,blockcorruption,block corruption , KBA , BW-SYS-DB-ORA , BW ORACLE , BC-DB-ORA , Oracle , How To

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.