一例正常运行的数据库突然节点不停重启(因为是rac,启动一会儿就crash,然后又被crs给启动起来,然后有crash,依次循环),告警日志类似:
Fri Mar 24 13:36:07 2023 QMNC started with pid=124, OS id=188397 ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Completed: ALTER DATABASE OPEN Fri Mar 24 13:36:08 2023 minact-scn: Inst 1 is now the master inc#:2 mmon proc-id:188028 status:0x7 minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000 gcalc-scn:0x0000.00000000 Fri Mar 24 13:36:08 2023 Starting background process CJQ0 Fri Mar 24 13:36:08 2023 CJQ0 started with pid=144, OS id=188451 Fri Mar 24 13:36:09 2023 Redo thread 2 internally disabled at seq44406 (CKPT) Archived Log entry 135343 added forthread 2 sequence 44405 ID 0xcd7086e0 dest 1: ARC0: Archiving disabled thread 2 sequence 44406 Archived Log entry 135344 added forthread 2 sequence 44406 ID 0xcd7086e0 dest 1: Thread 1 advanced to log sequence 40030 (LGWR switch) Current log# 2 seq# 40030 mem# 0: +DATA/xff/onlinelog/group_2.310.1087136761 Archived Log entry 135345 added forthread 1 sequence 40029 ID 0xcd7086e0 dest 1: Fri Mar 24 13:36:30 2023 Errors infile/oracle/database/diag/rdbms/xff/xff1/trace/xff1_p200_188856.trc (incident=1082418): ORA-00600: internal error code, arguments: [17182], [0x7F4D2A13DBF8], [], [], [], [], [], [], [], [], [], [] Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1082418/xff1_p200_188856_i1082418.trc Use ADRCI or Support Workbench to package the incident. |

数据库集群中的一个节点不断重启,日志显示出现ORA-00600内部错误,关联代码包括17182、25027和kghfrempty:ds。这表明可能由块逻辑损坏导致回滚恢复失败,进而引起实例崩溃。解决异常回滚问题能防止数据库反复崩溃。
最低0.47元/天 解锁文章
703

被折叠的 条评论
为什么被折叠?



