Re: ORA-01578: Miracle healing of corrupted datablock?

From: <yong321_at_yahoo.com>
Date: 30 Dec 2005 14:51:58 -0800
Message-ID: <1135983118.374666.128900@o13g2000cwo.googlegroups.com>

Caja wrote:
> Hi all,
>
> we encountered a strange behaviour or miracle with Oracle 8.1.7 under
> AIX 5.2
>
> We got an corrupted datafile (this was not the miracle):
>
> ORA-01578: ORACLE data block corrupted (file # 3, block # 89918)
>
> We examined the datafile with db verify (dbv ) and got the result that
> everything is ok. Why?

Carsten,

Can you show us the full output of dbv? If possible, dump the datafile for that block and post here the part about the header of the block.

Yong Huang Received on Fri Dec 30 2005 - 16:51:58 CST