联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
数据库由于ORA-600 kcvent_intcic_zero_half错误导致实例重启
Reconfiguration started (old inc 8, new inc 10) List of instances: 1 2 (myinst: 2) Nested reconfiguration detected. Global Resource Directory frozen Communication channels reestablished * domain 0 valid = 1 according to instance 1 Master broadcasted resource hash value bitmaps Non-local Process blocks cleaned out LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived Set master node info Submitted all remote-enqueue requests Dwn-cvts replayed, VALBLKs dubious All grantable enqueues granted Fri Jan 30 22:07:08 2026 minact-scn: Master returning as live inst:1 has inc# mismatch instinc:0 cur:10 errcnt:0 Submitted all GCS remote-cache requests Fix write in gcs resources Reconfiguration complete Fri Jan 30 22:07:17 2026 Errors in file /u01/oracle11g/diag/rdbms/hisdb/hisdb2/trace/hisdb2_ckpt_1748.trc (incident=228496): ORA-00600: internal error code, arguments: [kcvent_intcic_zero_half], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /u01/oracle11g/diag/rdbms/hisdb/hisdb2/incident/incdir_228496/hisdb2_ckpt_1748_i228496.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Errors in file /u01/oracle11g/diag/rdbms/hisdb/hisdb2/trace/hisdb2_ckpt_1748.trc: ORA-00600: internal error code, arguments: [kcvent_intcic_zero_half], [], [], [], [], [], [], [], [], [], [], [] CKPT (ospid: 1748): terminating the instance due to error 469 Fri Jan 30 22:07:18 2026 ORA-1092 : opitsk aborting process Fri Jan 30 22:07:19 2026 System state dump requested by (instance=2, osid=1748 (CKPT)), summary=[abnormal instance termination].
初步分析该错误是由于oracle bug引起,在11.2.0.4版本中比较少见,主要常见于19c版本中
正常情况下,实例重启即可,这个客户比较不幸,数据库重启遭遇ORA-600 3716错误
ALTER DATABASE OPEN /* db agent *//* {0:11:28647} */
This instance was first to open
Beginning crash recovery of 2 threads
parallel recovery started with 15 processes
Started redo scan
Completed redo scan
read 1120 KB redo, 386 data blocks need recovery
Started redo application at
Thread 2: logseq 847, block 641786
Recovery of Online Redo Log: Thread 2 Group 3 Seq 847 Reading mem 0
Mem# 0: +DATADISK/hisdb/onlinelog/group_3.267.1109863469
Mem# 1: +ARCHIVEDISK/hisdb/onlinelog/group_3.261.1109863469
Completed redo application of 0.38MB
Completed crash recovery at
Thread 2: logseq 847, block 644027, scn 20674490933
386 data blocks read, 0 data blocks written, 1120 redo k-bytes read
ARCH: STARTING ARCH PROCESSES
Fri Jan 30 22:07:47 2026
ARC0 started with pid=53, OS id=332
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Fri Jan 30 22:07:48 2026
ARC1 started with pid=54, OS id=364
Fri Jan 30 22:07:48 2026
ARC2 started with pid=55, OS id=366
Fri Jan 30 22:07:48 2026
ARC3 started with pid=56, OS id=368
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Errors in file /u01/oracle11g/diag/rdbms/hisdb/hisdb2/trace/hisdb2_ora_29981.trc (incident=240679):
ORA-00600: ??????, ??: [3716], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/oracle11g/diag/rdbms/hisdb/hisdb2/incident/incdir_240679/hisdb2_ora_29981_i240679.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Abort recovery for domain 0
Aborting crash recovery due to error 600
Errors in file /u01/oracle11g/diag/rdbms/hisdb/hisdb2/trace/hisdb2_ora_29981.trc:
ORA-00600: ??????, ??: [3716], [], [], [], [], [], [], [], [], [], [], []
Abort recovery for domain 0
Errors in file /u01/oracle11g/diag/rdbms/hisdb/hisdb2/trace/hisdb2_ora_29981.trc:
ORA-00600: ??????, ??: [3716], [], [], [], [], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN /* db agent *//* {0:11:28647} */...
接手客户故障尝试启动数据库也报ORA-600 3716错误
SQL> startup ORACLE instance started. Total System Global Area 2.0176E+10 bytes Fixed Size 2261928 bytes Variable Size 3288337496 bytes Database Buffers 1.6844E+10 bytes Redo Buffers 41463808 bytes Database mounted. ORA-00600: internal error code, arguments: [3716], [], [], []
根据官方描述该问题
那解决该问题相对比较简单
SQL>@rectl.sql Control file created. SQL> recover database; Media recovery complete. SQL> alter database open; Database altered.
完美恢复这次故障,实现数据0丢失,业务直接使用
