7 Replies Latest reply: Feb 13, 2013 11:50 PM by - A - RSS

    ORA-01578: ORACLE data block corrupted

    - A -
      Hi,
      we are running oracle 9iR2 ( 9.2.0.1.0) on windows server 2003 R2 and facing ORA-01578: ORACLE data block corrupted (file # 17, block # 312316)

      SQL> select * from payrol.slip;
      select * from payrol.slip
      *
      ERROR at line 1:
      ORA-01578: ORACLE data block corrupted (file # 17, block # 312316)
      ORA-01110: data file 17: 'E:\ORACLE\ORADATA\MTMA\SYSMTM.ORA'
      ORA-26040: Data block was loaded using the NOLOGGING option

      1) SELECT name FROM v$datafile WHERE file#=17;
      output
      E:\ORACLE\ORADATA\MTMA\SYSMTM.ORA

      2) SELECT block_size FROM dba_tablespaces
      WHERE tablespace_name =
      (SELECT tablespace_name FROM dba_data_files WHERE file_id=17);
      output
      8192

      3) SELECT tablespace_name, segment_type, owner, segment_name
      FROM dba_extents
      WHERE file_id = &AFN
      and &BL between block_id AND block_id + blocks - 1;

      file_id=17, BL=312316
      output
      SYSMTM TABLE PAYROL SLIP

      I am not using RMAN.
      How to recover payrol.slip table ?

      Any suggestion...

      Thanks in advance.