Re: ORA-01578 oracle data block corrupted.

In article <NEWTNews.13739.795852464.wittai_at_yeshtlv.netvision.net.il>, wittai_at_netvision.net.il says:
>
>
>
>> rocky termanini (rmte_at_ix.netcom.com)
 wrote:
>> : We have been running into the ORA-01578
 (oracle data block corrupted)
 (SNIP)
>> : We are currently running Oracle

 V6.0.36.1 on SCO Unix V3.2.3.4. If you
>> : know of any solutions, I'd like to hear
 them! Appreciate any help.  

>> : J
>>
>
>
>
>The only real good solution I recomend from
>my experience is to export
>the data out and import it into another
>disk with the same file system
>name .
>

  We once had bad blocks as well at our site. Enclosed is the script that Oracle provided to determine the affected table(s).

spool badblock.lis;
select segment_name,segment_type, block_id, bytes, blocks from dba_extents
where file_id = 11
and block_id <= 685
and block_id + blocks > 685;
exit;

  The numbers in the above script, if memory serves, came from our trace files. This determined WHAT was affected. The solution was to drop and recreate the affected tablespace and re-import the data from our last good export.

					Hope this helps.
					Brian

--
Brian Graham                    .
Programmer / DBA        ._______|_______. Tel: 613-560-5470
Public Service Alliance       \(*)/       Fax: 613-563-3492
of Canada                     o/ \o       Email: grahamb_at_psac.com