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

    ORA-07445: exception encountered: core dump [kdxlin()+4088]处理

    惜分飞发表于 2023-09-23 14:54:36
    love 0

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

    标题:ORA-07445: exception encountered: core dump [kdxlin()+4088]处理

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

    abort方式关闭数据库,启动报错

    Tue Sep 19 21:52:56 2023
    NOTE: dependency between database orcl and diskgroup resource ora.DATA.dg is established
    Tue Sep 19 21:52:57 2023
    Reconfiguration started (old inc 4, new inc 6)
    List of instances:
     1 (myinst: 1) 
     Global Resource Directory frozen
     * dead instance detected - domain 0 invalid = TRUE 
     Communication channels reestablished
     Master broadcasted resource hash value bitmaps
     Non-local Process blocks cleaned out
    Tue Sep 19 21:52:57 2023
    Tue Sep 19 21:52:57 2023
     LMS 3: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
    Tue Sep 19 21:52:57 2023
     LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
     LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
    Tue Sep 19 21:52:57 2023
     LMS 2: 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
     Post SMON to start 1st pass IR
     Submitted all GCS remote-cache requests
     Post SMON to start 1st pass IR
     Fix write in gcs resources
    Reconfiguration complete
    Tue Sep 19 21:53:05 2023
    Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_28917.trc  (incident=492333):
    ORA-00600: internal error code, arguments: [2131], [33], [32], [], [], [], [], [], [], [], [], []
    Incident details in:/u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_492333/orcl1_ora_28917_i492333.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    ORA-600 signalled during: ALTER DATABASE MOUNT /* db agent *//* {1:34652:2} */...
    

    重建ctl之后,尝试recover数据库报错ORA-600 3020和ORA-07445 kdxlin等错误

    SQL> recover database;
    ORA-00600: internal error code, arguments: [3020], [41], [3142531],
    [175108995], [], [], [], [], [], [], [], []
    ORA-10567: Redo is inconsistent with data block (file# 41, block# 3142531, file
    offset is 4268777472 bytes)
    ORA-10564: tablespace XIFENFEI
    ORA-01110: data file 41: '+DATA/orcl/datafile/xifenfei07.dbf'
    ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK'
    
    Wed Sep 20 00:15:00 2023
    ALTER DATABASE RECOVER  database  
    Media Recovery Start
     started logmerger process
    Parallel Media Recovery started with 64 slaves
    Wed Sep 20 00:15:02 2023
    Recovery of Online Redo Log: Thread 2 Group 6 Seq 67008 Reading mem 0
      Mem# 0: +DATA/orcl/onlinelog/group_6.268.942097791
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 81767 Reading mem 0
      Mem# 0: +DATA/orcl/onlinelog/group_2.262.942097651
    Recovery of Online Redo Log: Thread 1 Group 5 Seq 81768 Reading mem 0
      Mem# 0: +DATA/orcl/onlinelog/group_5.263.942097651
    Wed Sep 20 00:15:08 2023
    Hex dump of (file 41, block 3142531) in trace file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_pr1m_45463.trc
    Reading datafile '+DATA/orcl/datafile/ts_his3bz07.dbf' for corruption at rdba: 0x0a6ff383 (file 41, block 3142531)
    Reread (file 41, block 3142531) found different corrupt data (logically corrupt)
    Hex dump of (file 41, block 3142531) in trace file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_pr1m_45463.trc
    Wed Sep 20 00:15:08 2023
    Exception [type: SIGSEGV, Address not mapped to object][ADDR:0xC] [PC:0x95FB582, kdxlin()+4088][flags: 0x0,count:1]
    Wed Sep 20 00:15:08 2023
    Exception [type: SIGSEGV, Address not mapped to object][ADDR:0xC] [PC:0x95FB582, kdxlin()+4088][flags: 0x0,count:1]
    Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_pr10_45419.trc  (incident=564584):
    ORA-07445: exception encountered:core dump [kdxlin()+4088][SIGSEGV][ADDR:0xC][PC:0x95FB582][Address not mapped to object]
    Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_564640/orcl1_pr17_45433_i564640.trc
    

    尝试随机恢复文件,也遭遇ORA-07445 kdxlin异常

    SQL> recover datafile 34;
    ORA-00283: recovery session canceled due to errors
    ORA-10562: Error occurred while applying redo to data block (file# 34, block#
    1999809)
    ORA-10564: tablespace XIFENFEI
    ORA-01110: data file 34: '+DATA/orcl/datafile/xifeifenfei06'
    ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 97961
    ORA-00607: Internal error occurred while making a change to a data block
    ORA-00602: internal programming exception
    ORA-07445: exception encountered: core dump [kdxlin()+4088] [SIGSEGV]
    [ADDR:0xC] [PC:0x95FB582] [Address not mapped to object] []
    

    出现这种情况是由于redo和数据文件块不一致导致无法正常应用日志,人工对于异常的block进行处理,数据库open成功,然后遭遇undo回滚段异常,对其进行规避,数据库open并且稳定运行

    • ORA-01172 ORA-01151 故障恢复
    • ORA-10562 故障恢复—allow 1 corruption
    • ORA-600 3417和ORA-600 3005故障处理
    • Oracle 19c 断电异常恢复
    • ORA-600 3417故障处理
    • 硬件故障数据库异常恢复
    • Oracle 启动后一会儿就挂掉故障处理—ORA-600 17182
    • 非归档数据库异常恢复一例
    • ORA-01172 ORA-01151 故障恢复
    • 某医院存储掉线导致Oracle数据库故障恢复
    • Patch SCN一键解决ORA-600 2662故障
    • ORA-600 kcbzpbuf_1故障恢复


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