Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-01578: ORACLE data block corrupted (on system01.dbf datafile)

609230Nov 23 2007 — edited Nov 24 2007
when 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..

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 22 2007
Added on Nov 23 2007
8 comments
3,510 views