Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Overview

Below is an incomplete list of places and tools that provides essential information. Please note, basically every SAP application can provide some hints or information in their own output or logfiles.

Logs / Traces / Places / Transactions

  • Oracle Alert Log

    Example:
    Corrupt Block Found
             TSN = 56, TSNAME = PSAPDBERCHZ1D
             RFN = 587, BLK = 3464569, RDBA = -1829446279         
             OBJN = 2, OBJD = -1, OBJECT = , SUBOBJECT =         
             SEGMENT OWNER = , SEGMENT TYPE =
    Errors in file  
    /oracle/PRP/saptrace/diag/rdbms/prp/PRP1/trace/PRP1_ora_17564.trc  
    (incident=159257):
    ORA-01578: ORACLE data block corrupted (file # 587, block # 3464569)
    ORA-01110: data file 587:   '/oracle/PRP/sapdata70/dberchz1d_99/dberchz1d.data99'
    Incident details in: /oracle/PRP/saptrace/diag/rdbms/prp/PRP1/incident/incdir_159257/PRP1_ora_17564_i159257.trc

     
  • Oracle Trace File
     
  • SAP System Log (SM21)
     
    Example:
    08:38:38 DIA  002 300 J2EE_ADMIN                BY  2 Database error 1578 at FET
    08:38:38 DIA  002 300 J2EE_ADMIN                BY  0 > ORA-01578: ORACLE data block corrupted (file # 39, block #
    08:38:38 DIA  002 300 J2EE_ADMIN                BY  0 > 735843)#ORA-01110: data file 39:
    08:38:38 DIA  002 300 J2EE_ADMIN                BY  0 > '/oracle/BWP/sapdata6/bwpfact_5/bwpfact.data5'#ORA-26040:
    08:38:38 DIA  002 300 J2EE_ADMIN                BY  0 > Data block was loaded using the NOLOGGING option
    08:38:38 DIA  002 300 J2EE_ADMIN                BY  1 Database error 1578
    08:38:39 DIA  004 300 J2EE_ADMIN                BY  2 Database error 1578 at FET
    08:38:39 DIA  004 300 J2EE_ADMIN                BY  0 > ORA-01578: ORACLE data block corrupted (file # 231, block #
    08:38:39 DIA  004 300 J2EE_ADMIN                BY  0 > 759667)#ORA-01110: data file 231:
    08:38:39 DIA  004 300 J2EE_ADMIN                BY  0 > '/oracle/BWP/sapdata6/bwpfact_12/bwpfact.data12'#ORA-26040:
    08:38:39 DIA  004 300 J2EE_ADMIN                BY  0 > Data block was loaded using the NOLOGGING option
    08:38:39 DIA  004 300 J2EE_ADMIN                BY  1 Database error 1578

  • SAP Job Log (SM37)
     
  • SAP System Dump (ST22)
     
  • SAP WP Trace (ST11)
     
    Example:
    C  OCI-call failed with -1=OCI_ERROR C     SQL error 1578: 'ORA-01578: ORACLE data block corrupted (file # 39, block # 735843)
    C  ORA-01110: data file 39: '/oracle/BWP/sapdata6/bwpfact_5/bwpfact.data5'
    C  ORA-26040: Data block was loaded using the NOLOGGING option'
    C  *** ERROR => Error 1578 in stmt_fetch() from oci_execute_stmt(), orpc=0 [dbsloci.c    12861]
    C  *** ERROR => ORA-1578 occurred when executing SQL stmt (parse error offset=0)
    B  ***LOG BY0=> ORA-01578: ORACLE data block corrupted (file # 39, block # 735843)
    ORA-01110: data file 39: '/oracle/BWP/sapdata6/bwpfact_5/bwpfact.data5'
    ORA-26040: Data block was loaded using the NOLOGGING option [dbds#1 @ 592] [dbds    0592 ]
    B  ***LOG BY1=> sql error 1578       [dbacds#2 @ 1433] [dbacds  1433 ]
     
  • SAP Tool LOGCA (SAP note 2090832)
     
  • SWPM Logs

    Example:
    DbSl Trace: Error 1578 in stmt_fetch() from oci_execute_stmt(), orpc=0

    DbSl Trace: ORA-1578 occurred when executing SQL stmt (parse error offset=0)

    (EXP) ERROR: DbSlExeRead failed  
    rc = 99, table "/BIC/FCC_OTNSAL"  
    (SQL error 1578)  
    error message returned by DbSl:
    ORA-01578: ORACLE data block corrupted (file # 65, block # 70107)
    ORA-01110: data file 65: '/oracle/GBP/sapdata1/gbp_51/gbp.data51'
    ORA-26040: Data block was loaded using the NOLOGGING option
    (DB) INFO: disconnected from DB
     

  • SUM Logs

    Example:
    Request: Create Index VBHDR-0 (SANDIP/10.07.09/22:10)
    Process: devsetco_4
    sql:
    CREATE UNIQUE INDEX "VBHDR~0" ON "VBHDR"
    ("VBKEY")
    PCTFREE 10
    INITRANS 002
    TABLESPACE PSAPSR3
    STORAGE (INITIAL 0000000016 K
    NEXT 0000000016 K
    MINEXTENTS 0000000001
    MAXEXTENTS UNLIMITED
    PCTINCREASE 0000
    FREELISTS 001)
    ORA-01578: ORACLE data block corrupted (file # 21, block # 151632)
    ORA -01110: data file 21: '/oracle/QLY/sapdata4/sr3_18/sr3.data18' DDL time(___1): ........72 milliseconds
    The SQL statement was not executed
    Index   could not be created completely in the database Index
    VBHDR-0 could not be created
    Request for VBHDR could not be executed 

Navigating to other Chapters

General Information

Consistency Check with 'ANALYZE' command

Consistency Check with DBV

Consistency Check with RMAN

Consistency Check with Data Pump

Which object is stored in the corrupted block(s)

Checks found corrupted blocks. What to do now