再现ORA-600 4000故障处理---惜分飞

标签：11 CALLrel 600 23 4000 18 分飞 eais ORA

有一个10g的库，由于redo损坏导致无法正常recover成功
20231018111911

正常途径无法open成功,尝试强制打开库

Wed Oct 18 11:23:25 2023 alter database open resetlogs Wed Oct 18 11:23:25 2023 RESETLOGS is being done without consistancy checks. This may result in a corrupted database. The database should be recreated. RESETLOGS after incomplete recovery UNTIL CHANGE 236715370 Resetting resetlogs activation ID 4009817354 (0xef00f50a) Wed Oct 18 11:23:26 2023 Setting recovery target incarnation to 3 Wed Oct 18 11:23:26 2023 Assigning activation ID 4271120987 (0xfe94225b) Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: D:\ORADATA\EAIS\REDO01.LOG Successful open of redo thread 1 Wed Oct 18 11:23:26 2023 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Oct 18 11:23:26 2023 SMON: enabling cache recovery Wed Oct 18 11:23:27 2023 Errors in file d:\hys_db\admin\eais\udump\eais_ora_10916.trc: ORA-00600: 内部错误代码, 参数: [4000], [9], [], [], [], [], [], [] Wed Oct 18 11:23:28 2023 Errors in file d:\hys_db\admin\eais\udump\eais_ora_10916.trc: ORA-00704: 引导程序进程失败 ORA-00704: 引导程序进程失败 ORA-00600: 内部错误代码, 参数: [4000], [9], [], [], [], [], [], [] Wed Oct 18 11:23:28 2023 Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Wed Oct 18 11:23:28 2023 Errors in file d:\hys_db\admin\eais\bdump\eais_pmon_1764.trc: ORA-00704: bootstrap process failure Wed Oct 18 11:23:29 2023 Errors in file d:\hys_db\admin\eais\bdump\eais_reco_9628.trc: ORA-00704: bootstrap process failure Wed Oct 18 11:23:29 2023 Errors in file d:\hys_db\admin\eais\bdump\eais_smon_9884.trc: ORA-00704: bootstrap process failure Wed Oct 18 11:23:29 2023 Errors in file d:\hys_db\admin\eais\bdump\eais_ckpt_10096.trc: ORA-00704: bootstrap process failure Wed Oct 18 11:23:29 2023 Errors in file d:\hys_db\admin\eais\bdump\eais_lgwr_8932.trc: ORA-00704: bootstrap process failure Wed Oct 18 11:23:29 2023 Errors in file d:\hys_db\admin\eais\bdump\eais_dbw0_9892.trc: ORA-00704: bootstrap process failure Wed Oct 18 11:23:29 2023 Errors in file d:\hys_db\admin\eais\bdump\eais_mman_9472.trc: ORA-00704: bootstrap process failure Wed Oct 18 11:23:29 2023 Errors in file d:\hys_db\admin\eais\bdump\eais_psp0_7692.trc: ORA-00704: bootstrap process failure Instance terminated by USER, pid = 10916 ORA-1092 signalled during: alter database open resetlogs...

resetlogs失败,报ora-600 4000错误,查看相关trace文件

*** 2023-10-18 11:23:27.103 ksedmp: internal or fatal error ORA-00600: 内部错误代码, 参数: [4000], [9], [], [], [], [], [], [] Current SQL statement for this session: select ctime, mtime, stime from obj$ where obj# = :1 ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- _ksedst+38 CALLrel _ksedst1+0 0 1 _ksedmp+898 CALLrel _ksedst+0 0 _ksfdmp+14 CALLrel _ksedmp+0 3 603A816A CALLreg 00000000 6AE8258 3 603A8550 CALLrel 603A80D8 6AE8258 4FB1090 FA0 1 8C886B0 __VInfreq__ktudba+1 CALLrel _kgeasi+0 6AE8258 4FB1090 FA0 2 1 0 9 0 26 _ktrgcm+851 CALLrel _ktudba+0 9 8C88B68 0 0 _ktrgtc+526 CALLrel _ktrgcm+0 4FC753C _kdsgrp+937 CALLrel _ktrgtc+0 4FC753C 4FC74E0 1F1FB00 8C88CB4 240 2AED19C 1F1F71C _kdsfbrcb+432 CALLrel _kdsgrp+0 4FC7538 0 4FC7538 _qertbFetchByRowID+ CALLrel _kdsfbrcb+0 4FC7538 4FDF004 0 1 0 0

4344                                               4FC74E0 22E8078 8C88E14 0

_opifch2+3104 CALL??? 00000000 8DA05838 20135FC 8C890AC 1 _opifch+51 CALLrel _opifch2+0 89 5 8C891F0 _opiodr+1099 CALLreg 00000000 5 2 8C89938 _rpidrus+178 CALLrel _opiodr+0 5 2 8C89938 5 _rpidru+88 CALLrel _rpidrus+0 8C894C4 _rpiswu2+426 CALLreg 00000000 8C8988C _rpidrv+1461 CALLrel _rpiswu2+0 90F3CCB4 0 8C89860 2 8C89880 0 8C89860 0 84DF58 84E018 8C8988C 8 _rpifch+44 CALLrel _rpidrv+0 5 5 8C89938 8 _kqdpts+166 CALLrel _rpifch+0 5 5 5 3 90AE2383 7 C 0 0 0 0 0 0 0 5 2 90AE237C 7 C 0 0 0 0 0 0 0 _kqrlfc+478 CALLrel _kqdpts+0 90AE21F4 _kqlbplc+102 CALLrel _kqrlfc+0 _kqlblfc+240 CALLrel _kqlbplc+0 0 _adbdrv+12911 CALLrel _kqlblfc+0 0 8C8D034 _opiexe+11778 CALLrel _adbdrv+0 _opiosq0+6088 CALLrel _opiexe+0 4 0 8C8D894 _kpooprx+232 CALLrel _opiosq0+0 3 E 8C8D9AC A4 _kpoal8+775 CALLrel _kpooprx+0 8C8F6CC 8C8E248 1D 1 0 A4 _opiodr+1099 CALLreg 00000000 5E 17 8C8F6C8 60FEFF8D CALLreg 00000000 5E 17 8C8F6C8 0 _opitsk+1017 CALL??? 00000000 _opiino+1087 CALLrel _opitsk+0 0 0 _opiodr+1099 CALLreg 00000000 3C 4 8C8FC60 _opidrv+819 CALLrel _opiodr+0 3C 4 8C8FC60 0 _sou2o+45 CALLrel _opidrv+0 3C 4 8C8FC60 _opimai_real+112 CALLrel _sou2o+0 8C8FC54 3C 4 8C8FC60 _opimai+92 CALLrel _opimai_real+0 2 8C8FC8C _OracleThreadStart@ CALLrel _opimai+0 4+708 74A93438 CALLptr 00000000 76F09830 CALLreg 00000000 76F09800 CALLrel 76F0980B --------------------- Binary Stack Dump ---------------------

通过一些技巧处理数据库正常open,导出数据完成本次恢复，参考以前恢复类似case:

重现ORA-600 4000异常
 通过bbed解决ORA-00600[4000]案例
 记录一次ORA-600 4000数据库故障恢复
 ORACLE 8.1.7 数据库ORA-600 4000故障恢复

标签：11,CALLrel,600,23,4000,18,分飞,eais,ORA
From： https://www.cnblogs.com/xifenfei/p/17772485.html

再现ORA-600 4000故障处理---惜分飞

相关文章

赞助商

阅读排行