IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

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

    惜分飞发表于 2023-03-25 13:15:28
    love 0

    联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

    标题:Oracle 启动后一会儿就挂掉故障处理—ORA-600 17182

    作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

    一例正常运行的数据库突然节点不停重启(因为是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 seq 44406 (CKPT)
    Archived Log entry 135343 added for thread 2 sequence 44405 ID 0xcd7086e0 dest 1:
    ARC0: Archiving disabled thread 2 sequence 44406
    Archived Log entry 135344 added for thread 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 for thread 1 sequence 40029 ID 0xcd7086e0 dest 1:
    Fri Mar 24 13:36:30 2023
    Errors in file /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.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Fri Mar 24 13:36:30 2023
    Dumping diagnostic data in directory=[cdmp_20230324133630], requested by (instance=1, osid=188856 (P200)), summary=[incident=1082418].
    Fri Mar 24 13:36:54 2023
    Decreasing number of real time LMS from 6 to 0
    Fri Mar 24 13:36:54 2023
    Block recovery from logseq 40030, block 259 to scn 17199959182
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 40030 Reading mem 0
      Mem# 0: +DATA/xff/onlinelog/group_2.310.1087136761
    Block recovery stopped at EOT rba 40030.317.16
    Block recovery completed at rba 40030.317.16, scn 4.20089998
    Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x97E8579, kghrst()+1835] [flags: 0x0, count: 1]
    Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_p200_188856.trc  (incident=1082419):
    ORA-07445: exception encountered: core dump [kghrst()+1835] [SIGSEGV] [ADDR:0x0] [PC:0x97E8579] [SI_KERNEL(general_protection)] []
    ORA-00600: internal error code, arguments: [17182], [0x7F4D2A13DBF8], [], [], [], [], [], [], [], [], [], []
    Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1082419/xff1_p200_188856_i1082419.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 /oracle/database/diag/rdbms/xff/xff1/trace/xff1_p200_188856.trc  (incident=1082420):
    ORA-00600: internal error code, arguments: [17147], [0x7F4D2A13DBD0], [], [], [], [], [], [], [], [], [], []
    ORA-07445: exception encountered: core dump [kghrst()+1835] [SIGSEGV] [ADDR:0x0] [PC:0x97E8579] [SI_KERNEL(general_protection)] []
    ORA-00600: internal error code, arguments: [17182], [0x7F4D2A13DBF8], [], [], [], [], [], [], [], [], [], []
    Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1082420/xff1_p200_188856_i1082420.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    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 /oracle/database/diag/rdbms/xff/xff1/trace/xff1_p200_188856.trc  (incident=1082421):
    ORA-00600: internal error code, arguments: [kghfrempty:ds], [0x7F4D2A13DBE8], [], [], [], [], [], [], [], [], [], []
    ORA-07445: exception encountered: core dump [kghrst()+1835] [SIGSEGV] [ADDR:0x0] [PC:0x97E8579] [SI_KERNEL(general_protection)] []
    ORA-00600: internal error code, arguments: [17182], [0x7F4D2A13DBF8], [], [], [], [], [], [], [], [], [], []
    Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1082421/xff1_p200_188856_i1082421.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Fri Mar 24 13:36:56 2023
    Dumping diagnostic data in directory=[cdmp_20230324133656], requested by (instance=1, osid=188856 (P200)), summary=[incident=1082420].
    SMON: Restarting fast_start parallel rollback
    Fri Mar 24 13:37:12 2023
    Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_p000_188229.trc  (incident=1080530):
    ORA-00600: internal error code, arguments: [17182], [0x7F3AB22ADBF8], [], [], [], [], [], [], [], [], [], []
    Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1080530/xff1_p000_188229_i1080530.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Fri Mar 24 13:37:12 2023
    Dumping diagnostic data in directory=[cdmp_20230324133712], requested by (instance=1, osid=188229 (P000)), summary=[incident=1080530].
    Fri Mar 24 13:37:24 2023
    Block recovery from logseq 40030, block 259 to scn 17199959182
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 40030 Reading mem 0
      Mem# 0: +DATA/xff/onlinelog/group_2.310.1087136761
    Block recovery completed at rba 40030.317.16, scn 4.20089999
    Fri Mar 24 13:37:37 2023
    Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x97E8579, kghrst()+1835] [flags: 0x0, count: 1]
    Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_p000_188229.trc  (incident=1080531):
    ORA-07445: exception encountered: core dump [kghrst()+1835] [SIGSEGV] [ADDR:0x0] [PC:0x97E8579] [SI_KERNEL(general_protection)] []
    ORA-00600: internal error code, arguments: [17182], [0x7F3AB22ADBF8], [], [], [], [], [], [], [], [], [], []
    Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1080531/xff1_p000_188229_i1080531.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Fri Mar 24 13:37:37 2023
    Dumping diagnostic data in directory=[cdmp_20230324133737], requested by (instance=1, osid=188229 (P000)), summary=[incident=1080531].
    Fri Mar 24 13:38:16 2023
    SMON: slave died unexpectedly, downgrading to serial recovery
    Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_smon_188020.trc  (incident=1080418):
    ORA-00600: internal error code, arguments: [17182], [0x7F9184B445C0], [], [], [], [], [], [], [], [], [], []
    Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1080418/xff1_smon_188020_i1080418.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Block recovery from logseq 40030, block 259 to scn 17199959182
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 40030 Reading mem 0
      Mem# 0: +DATA/xff/onlinelog/group_2.310.1087136761
    Block recovery completed at rba 40030.317.16, scn 4.20089999
    ORACLE Instance xff1 (pid = 56) - Error 600 encountered while recovering transaction (10, 26) on object 242112.
    Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_smon_188020.trc:
    ORA-00600: internal error code, arguments: [17182], [0x7F9184B445C0], [], [], [], [], [], [], [], [], [], []
    Fri Mar 24 13:38:17 2023
    Dumping diagnostic data in directory=[cdmp_20230324133817], requested by (instance=1, osid=188020 (SMON)), summary=[incident=1080418].
    Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x97E8579, kghrst()+1835] [flags: 0x0, count: 1]
    Errors in file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_smon_188020.trc  (incident=1080419):
    ORA-07445: exception encountered: core dump [kghrst()+1835] [SIGSEGV] [ADDR:0x0] [PC:0x97E8579] [SI_KERNEL(general_protection)] []
    ORA-00600: internal error code, arguments: [17182], [0x7F9184B445C0], [], [], [], [], [], [], [], [], [], []
    Incident details in: /oracle/database/diag/rdbms/xff/xff1/incident/incdir_1080419/xff1_smon_188020_i1080419.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Fri Mar 24 13:38:20 2023
    PMON (ospid: 187888): terminating the instance due to error 474
    System state dump requested by (instance=1, osid=187888 (PMON)), summary=[abnormal instance termination].
    System State dumped to trace file /oracle/database/diag/rdbms/xff/xff1/trace/xff1_diag_187902_20230324133820.trc
    Fri Mar 24 13:38:21 2023
    ORA-1092 : opitsk aborting process
    Dumping diagnostic data in directory=[cdmp_20230324133820], requested by (instance=1, osid=187888 (PMON)), summary=[abnormal instance termination].
    Instance terminated by PMON, pid = 187888
    

    这类的故障在多年前处理过几次
    ORA-600 17182导致oracle异常
    ORA-00600[17182],ORA-00600[25027],ORA-00600[kghfrempty:ds]故障处理
    这个故障的原因是由于block逻辑损坏,实例无法正常做回滚恢复,从而异常.处理异常回滚问题,就可以规避掉数据库启动后一会儿就crash问题.

    • ORA-600 17182导致oracle异常
    • ORA-00600[17182],ORA-00600[25027],ORA-00600[kghfrempty:ds]故障处理
    • ORA-07445 opiaba—绑定变量超过65535导致实例crash
    • tab$异常被处理之后报ORA-600 13304故障处理
    • 记录一次200T的数据库恢复经历
    • 正常open库报ORA-600 2662,ORA-600 4097错误
    • Patch SCN工具快速解决ORA-600 2662问题
    • tab$被恶意删除sys用户之外记录
    • Oracle 19c故障恢复
    • Exception [type: SIGSEGV, Address not mapped to object] [] [ kgegpa()+36]
    • 又一例ORA-600 kcratr_nab_less_than_odr
    • ORA-00600 kcratr_scan_rc


沪ICP备19023445号-2号
友情链接