BUG:ORA-00600 の 一 [kdBlkCheckError]
在一次维护操作中，进行手动区的分配。中途中止DDL语句，导致如下bug，有人问，区的申请，不是oracle自动进行的么？
没错。何况我还是assm管理。但是由于我们的系统存在 enq: HW- contention 高水位争用问题。LOB的每次区的申请，会导致竞争事件。
而做测试之后，定了手工分配区的一个方案。
select * from dba_registry_history
ACTION_TIME ACTION NAMESPAC VERSION ID BUNDL COMMENTS
------------------------------ -------- -------- ---------- ---------- ----- --------------------
07-DEC-15 06.56.10.389955 PM APPLY SERVER 11.2.0.1 6 PSU PSU 11.2.0.1.6
alert 日志，pmon进程不断循环恢复逻辑损坏的数据块。但是始终无法修复。
MOS 上已经明确了此BUG：
Bug 8198906 - OERI [kddummy_blkchk] / OERI [5467] for an aborted transaction of allocating extents (文档 ID 8198906.8)
Description
Further details on this issue can be found in Note:1229669.1This is a regression introduced by bug 8198906. Note: This fix replaces the fix in bug 8198906. ORA-600 [ktsptrn_fix-extmap] or ORA-600 [kdblkcheckerror] [18039] caused by a metadata corruption in a LOB segment that is stored in an ASSM tablespace when there is a manual extent allocation through: ALTER TABLE MODIFY LOB .. ALLOCATE EXTENT.Getting a Fix Use one of the "Fixed" versions listed above (for Patch Sets / bundles use the latest version available as contents are cumulative - the "Fixed" version listed above is the first version where the fix is included) or You can check for existing interim patches here: Patch:9711859
| Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support. |
References
Bug:9711859 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article
补丁程序：p9711859_112016_Linux-x86-64
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30182853/viewspace-1878002/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Oracle补丁知识
请登录后发表评论
登录
全部评论
