Corrupt block relative dba

[Former Member]

Dear:

Running the CheckDB in the transaction DB13 and i get the following

message of error:

BR0976W Database message alert - level: ERROR, line: 16991, time: 2008-02-05 23.16.19, message:

Corrupt block relative dba: 0x00c02702 (file 3, block 9986)

Other Details :-

OS :- Win 2003 server

DB :- Oracle 10g

So please help on this issue.

Thanks.

Regards.

[Former Member]

Dear:

In today to executethe transaction DB13 and the disappeared warning database message alert.

Thank You.

[former_member204746]

your problem is not fixed!

the next time you hit the same ORale datablock, it will fail again.

you need to investigate this error and fix it before it blows up again.

follow Stefan's advice.

[stefan_koehler]

Hello,

>> Corrupt block relative dba: 0x00c02702 (file 3, block 9986)

you have to check, if the block 9986 in file 3 is allocated and used in an active segment.

If it is an index ... you can easily rebuild it and the problem is gone... but if it is a table segment it is more complicated... but first check the block....

> sqlplus "/ as sysdb"

> alter system dump datafile 3 block 9986

> cd /oracle/<SID>/saptrace/usertrace

Take a look at the tracefile and check the seg/obj .. convert the hex value to a decimal ...after that query dba_objects;

> sqlplus "/ as sysdba"

> SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE DATA_OBJECT_ID = <OBJN>;

Regards

Stefan