Handle ORA-00600 kcbz_check_objd_typ_3 errors

Today, the rac database query database encountered the ORA-00600 kcbz_check_objd_typ_3 error, and the disk queue process is very high, the system pressure is very high
After the alter system flush buffer_cache statement is executed, the error disappears;

After a data recovery, encountered the ORA-00600 kcbz_check_objd_typ_3 error, record here.

First, the error kcbz_check_objd_typ_3 indicates:
When Oracle checks the data block in the memory, it finds that the object number on the data block is incorrect, and then throws the kcbz_check_objd_typ_3 exception.
This error usually means data corruption.

In our case, the user first introduced the problem due to storage corruption. This error occurs after we fix it. This error is triggered when AWR sampling is executed in the background and is temporary, we can disable AWR sampling to avoid this problem. We can completely fix problems caused by AWR dictionary tables by recreating AWR objects.

The error is similar to the following:

ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_1], [0], [0], [1], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_1], [0], [0], [1], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], [], []

Sometimes this error may be related to the Space Advisor task. Disabling this JOB can also temporarily eliminate this problem. Some bugs must be patched to solve the problem:

Exec dbms_scheduler.disable ('Auto _ SPACE_ADVISOR_JOB ');
Alter system flush buffer_cache;

The related BUG is:
Bug 4430244-Segment advisor can load blocks of dropped objects into buffer cache (kcb oeri errors) (Doc ID 4430244.8)

When this error occurs, you should view the trace file and use the trace file for further judgment.