Re: Logical block corruption

From: Mladen Gogala <>
Date: Wed, 1 Apr 2009 18:20:32 +0000 (UTC)
Message-ID: <gr0b9e$r7f$>

On Wed, 01 Apr 2009 19:17:42 +0200, Ste wrote:

> Mladen Gogala wrote:

>> On Tue, 31 Mar 2009 17:38:17 -0700, johnbhurley wrote: Or just rebuild
>> them? AFAIK, "rebuild" was supported back then in 8i

> I've rebuilt all of them in another tablespace dedicated to indexes.
> After this I've run dbv and I've got the same error
> Steve

DBV is notoriously unreliable, especially in the old versions. Try using RMAN backup database verify. Do you see any corrupt block errors in the alert log? Did you recently do a recovery on the database? If you create an index with the NOLOGGING clause, you will not be able to recover it, you will have to rebuild it. Did you do analyze index validate structure?

Received on Wed Apr 01 2009 - 13:20:32 CDT

Original text of this message