联系:手机/微信(+86 17813235971) QQ(107644445)
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
一个oracle 19.3版本数据库异常关机之后直接启动数据库报ORA-07445 [kdxlin()+4824]相关错误
alter database open 2025-09-27T13:45:25.877298+08:00 Ping without log force is disabled: instance mounted in exclusive mode. 2025-09-27T13:45:25.924174+08:00 Beginning crash recovery of 1 threads parallel recovery started with 11 processes Thread 1: Recovery starting at checkpoint rba (logseq 2188 block 62125), scn 0 2025-09-27T13:45:26.049176+08:00 Started redo scan 2025-09-27T13:45:26.174177+08:00 Completed redo scan read 1070 KB redo, 536 data blocks need recovery 2025-09-27T13:45:26.465482+08:00 Started redo application at Thread 1: logseq 2188, block 62125, offset 0 2025-09-27T13:45:26.481107+08:00 Recovery of Online Redo Log: Thread 1 Group 1 Seq 2188 Reading mem 0 Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\Nxff\REDO01.LOG 2025-09-27T13:45:26.496732+08:00 Completed redo application of 0.58MB 2025-09-27T13:45:26.699860+08:00 Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xC] [PC:0x7FF77DBBF2F8, kdxlin()+4824] Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xff\xff\trace\xff_p003_4996.trc (incident=131272): ORA-07445: 出现异常错误: 核心转储 [kdxlin()+4824][ACCESS_VIOLATION][ADDR:0xC][PC:0x7FF77DBBF2F8][UNABLE_TO_READ][] Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\xff\xff\incident\incdir_131272\xff_p003_4996_i131272.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. 2025-09-27T13:45:30.776913+08:00 Slave encountered ORA-10388 exception during crash recovery 2025-09-27T13:45:30.776913+08:00 Slave encountered ORA-10388 exception during crash recovery 2025-09-27T13:45:30.776913+08:00 Slave encountered ORA-10388 exception during crash recovery 2025-09-27T13:45:30.776913+08:00 Slave encountered ORA-10388 exception during crash recovery 2025-09-27T13:45:30.776913+08:00 Slave encountered ORA-10388 exception during crash recovery 2025-09-27T13:45:30.792538+08:00 Slave encountered ORA-10388 exception during crash recovery 2025-09-27T13:45:30.792538+08:00 Slave encountered ORA-10388 exception during crash recovery 2025-09-27T13:45:31.792552+08:00 Slave encountered ORA-10388 exception during crash recovery 2025-09-27T13:45:32.802610+08:00 Slave encountered ORA-10388 exception during crash recovery 2025-09-27T13:45:33.818250+08:00 Slave encountered ORA-10388 exception during crash recovery 2025-09-27T13:45:33.833875+08:00 Aborting crash recovery due to slave death, attempting serial crash recovery 2025-09-27T13:45:33.833875+08:00 Beginning crash recovery of 1 threads Thread 1: Recovery starting at checkpoint rba (logseq 2188 block 62125), scn 0 2025-09-27T13:45:33.865126+08:00 Started redo scan 2025-09-27T13:45:33.912001+08:00 Completed redo scan read 1070 KB redo, 536 data blocks need recovery 2025-09-27T13:45:33.912001+08:00 Started redo application at Thread 1: logseq 2188, block 62125, offset 0 2025-09-27T13:45:33.927627+08:00 Recovery of Online Redo Log: Thread 1 Group 1 Seq 2188 Reading mem 0 Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\Nxff\REDO01.LOG Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xC] [PC:0x7FF77DBBF2F8, kdxlin()+4824] Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xff\xff\trace\xff_ora_4880.trc (incident=131240): ORA-07445: ??????: ???? [kdxlin()+4824] [ACCESS_VIOLATION] [ADDR:0xC] [PC:0x7FF77DBBF2F8] [UNABLE_TO_READ] [] Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\xff\xff\incident\incdir_131240\xff_ora_4880_i131240.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. 2025-09-27T13:45:36.386177+08:00 Dumping diagnostic data in directory=[cdmp_20250927134536],requested by(instance=1,osid=4880),summary=[incident=131240] 2025-09-27T13:45:39.745686+08:00 PMON (ospid: ): terminating the instance due to ORA error 2025-09-27T13:45:39.745686+08:00 Cause - 'Instance is being terminated due to fatal process death (pid: 33, ospid: 4880, )' 2025-09-27T13:45:39.745686+08:00 System state dump requested by (instance=1, osid=4652 (PMON)), summary=[abnormal instance termination]. System State dumped to trace file D:\APP\ADMINISTRATOR\diag\rdbms\xff\xff\trace\xff_diag_4696.trc 2025-09-27T13:45:44.013452+08:00 Instance terminated by PMON, pid = 4652
这次运气爆棚,直接尝试recover database,然后open库成功,完成数据库恢复任务
检查数据库没有发现其他问题,完成本次恢复业务