Oracle 启动后一会儿就挂掉故障处理—ORA-600 17182----惜分飞

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

一例正常运行的数据库突然节点不停重启(因为是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.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值