突发!核心系统遭遇逻辑坏块.....
这几天实在太忙,刚弄完文档。业务线的同事就找到我,说一个客户的核心系统昨晚出了故障,还没找到原因,希望能帮忙分析下。
从提供的信息来看是业务跑任务报错,遇到了Oracle-00600和ora-07445 错误。
Doing block recovery for file 408 block 1405699<br>Resuming block recovery (PMON) for file 408 block 1405699<br>Block recovery from logseq 127486, block 19033 to scn 0x00000040ee407ee9<br>Tue Jun 25 02:32:39 2024<br>Recovery of Online Redo Log: Thread 1 Group 46 Seq 127486 Reading mem 0<br> Mem# 0: +DATA1/xxxxx/ONLINELOG/group_46.01.log<br>Block recovery completed at rba 127486.19061.16, scn 0x00000040ee407ef6<br>Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x30044C4E535002C9] [PC:0x100222454, kghrst()+500] [flags: 0x0, count: 1]<br>Errors in file /u01/oracle/app/diag/rdbms/xxxxx/xxxxx1/trace/xxxxx1_ora_16384202.trc (incident=4925384):<br>ORA-07445: exception encountered: core dump [kghrst()+500] [SIGSEGV] [ADDR:0x30044C4E535002C9] [PC:0x100222454] [Address not mapped to object] []<br>ORA-00607: Internal error occurred while making a change to a data block<br>ORA-00600: internal error code, arguments: [17182], [0x121242CE0], [], [], [], [], [], [], [], [], [], []<br>Incident details in: /u01/oracle/app/diag/rdbms/xxxxx/xxxxx1/incident/incdir_4925384/xxxxx1_ora_16384202_i4925384.trc<br>