This discussion is archived
7 Replies Latest reply: Feb 13, 2013 9:50 PM by - A - RSS

ORA-01578: ORACLE data block corrupted

- A - Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points