ORA-01578: ORACLE data block corrupted (on system01.dbf datafile)
609230Nov 23 2007 — edited Nov 24 2007when i try to take export its show error
EXP-00008: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 1, block # 1434)
ORA-01110: data file 1: '/u04/BURST/system01.dbf'
EXP-00000: Export terminated unsuccessfully
i check system01.dbf datafile
dbv file=/u04/BURST/system01.dbf feedback=100
DBVERIFY: Release 10.1.0.3.0 - Production on Fri Nov 23 15:29:36 2007
Copyright (c) 1982, 2004, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = /u04/BURST/system01.dbf
..............
DBV-00200: Block, dba 4195738, already marked corrupted
..................................................................
................................................................................
................................................................................
................................................................................
................................................................................
................................................................................
................................................................................
................................................................................
....................
DBVERIFY - Verification complete
Total Pages Examined : 66560
Total Pages Processed (Data) : 39779
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 8121
Total Pages Failing (Index): 0
Total Pages Processed (Other): 1607
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 17053
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 398349542 (0.398349542)
i Execute the following query to Identify the object owning the
corrupted block.
SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id = 1
and 1434 between block_id AND block_id + blocks - 1;
output of query
tablespace_name=system
segment_type=table
owner=sys
segment_name=job$
i Run analyze on the object returned by the above query
sql> Analyze table job$ validate structure cascade;
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 1, block # 1434)
ORA-01110: data file 1: '/u04/BURST/system01.dbf'
i chect it again in the system01.dbf datafile through dbv it will not repair...
suggest me what i can do ..as soon as possible..