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

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...

*** 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 ---------------------