联系:手机/微信(+86 17813235971) QQ(107644445)
标题: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并且稳定运行
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· 单线程的Redis速度为什么快?
2022-09-23 又一例asm disk 加入vg故障