Re: ORA-01578 data block corrupted

If the restore/recovery thing from backup doesn't work (it usually does), it's time to panic in a controlled fashion...

Dump the block to see if it's a hard or soft corruption.

A hard corruption is when some kind of "stray write" has hit the block, causing one of many checks against eg the rows to fail.

A soft corruption happens when Oracle decides it doesn't have faith in the block anymore, so better corrupt it by zero'ing out part of the footer field.

There's no easy way to tell whether it's a hard or soft corruption. You can dump the block and study the header and footer fields to see if they match. If not, it's probably a soft corruption.

Or get Peter Gram to look at such stuff. He's crazy.

Mogens

Nguyen, David M wrote:

> I got ORA-01578 error while querrying info for below table. How do I
> fix this error?
>
>
> SQL>Select count(*) from GATEWAYCALLSTATS;
>
> *
>
> ERROR at line 2:
>
> ORA-01578: ORACLE* data block corrupted* (file # 3, block # 2683299)
>
> ORA-01110: data file 3: '/apps/oracle/oradata/SIDB/rtesvr01.dbf'
>
> Thanks,
>
> David
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).