Re: ORA-01578 data block corrupted

Yup, there are some nice ways for restoring even parts of a datablock using contents from corresponding indexes... or if it's an index block (just a plain count(*) can use indexes as well if all rows are quaranteed to be indexed), then you can "just" rebuild the index. So, nothing is lost, until it's completely lost ;)

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, January 09, 2004 1:24 AM

> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).