[Oracle] ORA-600[KDBLKCHECKERROR]LOB Bad block handling

Tag: ROM ble operation code Sep erro Column View object

[Oracle] ORA-600[KDBLKCHECKERROR]LOB Bad block handling

The customer environment reported the following error:

Ora-00600:internal error code, arguments: [Kdblkcheckerror], [2], [10388], [63068], [], [], [], [], [], [], [], []

The alert log has this information:

Thu Sep 07 19:14:00 2017
Corrupt Block Found
CONT = 0, TSN = 1, tsname = Sysaux
RFN = 2, BLK = 10123, rdba = 7364815
Objn = 10388, OBJD = 10388, OBJECT = sys_lob0000010129c00001$$, subobject =
SEGMENT OWNER = SYS, SEGMENT TYPE = Lob SEGMENT

View the trace and see the associated SQL question also Opatch_xinv_tab table.

-----current SQL Statement to this session (SQL_ID=20X4SKYM5BSKJ)-----
INSERT into Opatch_xinv_tab (xml_inventory) SELECT * from OPATCH_XML_INV

Query related intelligence, you can see Opatch_xinv_tab's xml_inventory column, using the LOB field.

Sql> set pages 10000 line 200
Sql> SELECT * from dba_lobs where segment_name = ' sys_lob0000010129c00001$$ ';

OWNER
----------------
table_name
----------------
column_name
--------------------------------
Segment_name tablespace_name ...
---------------- ------------------------------
SYS
Opatch_xinv_tab
Xml_inventory
sys_lob0000010129c00001$$ Sysaux

Because there is no backup, only the LOB should be considered for cleanup. However, it is recommended that the customer make a backup of the site before the cleanup process.

Then, perform a cleanup operation:

ALTER TABLE SYS. Opatch_xinv_tab move LOB (xml_inventory) store as (Tablespace sysaux);

After this is cleared, the bad block becomes a non-object, knowing that it is again formatted as a free block when used again.

However, before this bad block is formatted, if Rman's bad block check is performed, or DBV, the block is found and the error is made.
If you are uncomfortable with this mistake, you can try to format it manually.

Specific practices need to refer to the documentation:

How to Format corrupted Block not part of the any Segment (Doc ID 336133.1)

[Oracle] ORA-600[KDBLKCHECKERROR]LOB Bad block handling