Corrupt block relative dba: in alert log
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.
and use dbms_repair to 'fix' the corrupted blocks
Type 6 --- This is a data block.
Originally Posted by minal_yawale
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.
Can u pls tell me how to use tht dbms_repair to fix the corrupted block
search for dbms_repair on maetalink or otn, funnily enough its all documented for you
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
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?
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.
drop and re-create - not rebuild
Can u pls tell me how much time will it take to drop and recreate the index of 10 GB with noparellel clause?
Click Here to Expand Forum to Full Width