Corrupt block relative dba: in alert log

[minal_yawale]

hi,
in our production database I've found following error in alert log

Corrupt block relative dba: 0x0bc0e06f (file 47, block 57455)
Fractured block found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x0bc0e06f
last change scn: 0x0846.c10e6c06 seq: 0x1 flg: 0x06
consistency value in tail: 0x0c2a1045
check value in block header: 0xcf4a, computed block checksum: 0xc74
spare1: 0x0, spare2: 0x0, spare3: 0x0

***

Reread of rdba: 0x0bc0e06f (file 47, block 57455) found same corrupted data
Fri Aug 18 09:57:01 2006
Thread 1 advanced to log sequence 83159
Current log# 3 seq# 83159 mem# 0

***
then I tried this query to find out corrupted block:
select tablespace_name, segment_type, owner, segment_name from dba_extents
where file_id =47
and 57455 between block_id and block_id + blocks - 1;

After tht I've found tht it is index.

Now whether i've rebuild tht index or drop and then create again to solve this error.

Thanks in advance.

[davey23uk]

either

and use dbms_repair to 'fix' the corrupted blocks

[ixion]

Fractured block found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x0bc0e06f
last change scn: 0x0846.c10e6c06 seq: 0x1 flg: 0x06
consistency value in tail: 0x0c2a1045
check value in block header: 0xcf4a, computed block checksum: 0xc74
spare1: 0x0, spare2: 0x0, spare3: 0x0

Type 6 --- This is a data block.
Format 2: -- Contains Index data.
Format 1: -- Contains table data.

You could run
"analyze index validate structure" Just to be sure...

A split block can occur due to restoring from a hot backup. Did you do this?

I'd also validate the table as well.

Simple solution: drop and recreate the bad index.

[minal_yawale]

Can u pls tell me how to use tht dbms_repair to fix the corrupted block

[davey23uk]

search for dbms_repair on maetalink or otn, funnily enough its all documented for you

[SANJAY_G]

Can u pls tell me how to use tht dbms_repair to fix the corrupted block

Detecting and Repairing Data Block Corruption

[ixion]

Why do you want to use dbms_repair? drop and re-create the index will be simpler, and your guaranteed the problem is resolved.

Not only should he "fix" the block (pick a solution). But also ask the question why was it corrupted in the first place?

[minal_yawale]

When I tried to rebuild the index I got following error:

ORA-01578: ORACLE data block corrupted (file # 47, block # 57455)

ORA-01110: data file 47: 'INDX2_12.DBF'

Please let me know your views on same and also the steps to resolve this error.

Thanks for your time.

[davey23uk]

drop and re-create - not rebuild

[minal_yawale]

Can u pls tell me how much time will it take to drop and recreate the index of 10 GB with noparellel clause?