再现ORA-600 4000故障处理
惜分飞发表于 2023-10-18 07:22:20
联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
有一个10g的库，由于redo损坏导致无法正常recover成功
正常途径无法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故障恢复