Re: ORA-01578: Datablock corruption

From: Pascal Byrne <byrne_at_icada.com>
Date: Wed, 22 Jan 2003 16:48:53 +0100
Message-ID: <b0medq$r0dtl$1@ID-147008.news.dfncis.de>

cris wrote:
> Pascal Byrne wrote:
>

>> He was lucky the problem happened in a rollback segment tablespace
>> rather than one with data since the database is *not* running in
>> archivelog mode (don't ask) and they don't make cold datafile
>> backups (don't ask)!

>
>
> Did you run dbv againts *all* datafiles? Just to make sure there are no
> other corrupted blocks somewhere.

Yes. No other problems

>

>> My boss wants to know the reason why this happend and how *I* can
>> prevent it from happening again. Any help would be gratfully accepted.

>
>
> Have you tried to perform a complete RAM check? Some time ago I run into
> a corruption issue, I found out the RAM was defective and after
> replacing it the corrupted blocks magically disappeared.

Unfortunatly I don't have physical access to the machine to do any low level tests but it passed a memcheck test.

>
> HTH
>
> Kind regards, Cris
>

Thanks,
Pascal Received on Wed Jan 22 2003 - 09:48:53 CST