Data Block corruption

From: Rich <rich.bevan_at_bt.com>
Date: Thu, 23 Jan 2003 17:09:25 +0000
Message-ID: <3E3021C5.70F699E0@bt.com>

There was a disk errror on our system (Sun Sparc 2.6) which was repaired using format->analysis->read. However, before this was run the database was shutdown causing data block corruption - the message below was reported by TOAD

ORA-01578: Oracle data block corruted (file# 11, block # 27874} ORA-01110: datafile 11: '/u03/oradata/BAA/data04.dbf'

Is it possible from the above information to repair the damage either by deleting the segment which is corrupted and restoring the data or do I have to restore the whole datafile and use the archive logs ?

I am running Oracle 8.1.7.1 on 32 bit

Thanks for any help

Richard Received on Thu Jan 23 2003 - 11:09:25 CST