Re: so many corrupt blocks???

"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:<b8bprf$tev$1_at_dackel.pdb.sbs.de>...
> Hi!
> (9i, redhat 8)
> I've recently started to use oracle.
> We plan to go productive by the end
> of the year, so now we're still at the getting
> acquainted phase.
> Now, after large import and table reorgs
> I got a block corruption on my developer db
> and decided to run dbverify.
> which gave me lots of bad blocks (yes, I
> first stumbled over the blocksize but now
> it's correct.).
> 40 blocks un several datafiles!
>
> And one redolog!!!
>
> How can this happen?
>
> Fortunately, our production db still seems to be ok.
>
> Also, I exported the whole db before the
> corruptions became visible.
> Assuming the disks are physically ok,
> can I play this one back into the corrupted files?
>
> Lots of greetings!
> Volker

Volker,

Is it possible that the blocks are marked as corrupt due to nologging operations?
I have seen where a nologging operation has left a block marked as corrupted, when in fact there isn't really a corruption issue.

Are these data segments, or just indexes - can you simply rebuild them?

There are utilities such as DBMS_REPAIR for fixing corrupt blocks. http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/repair.htm#8600

Paul

e.g:

DBVERIFY: Release 8.1.7.4.1 - Production on Fri Apr 25 22:11:44 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = H:\Backup\orcl\hot\INDX01.DBF
Block Checking: DBA = 37780699, Block Type = Found block already marked corrupted Received on Sat Apr 26 2003 - 11:43:29 CDT