ORA-01092: ORACLE 例程终止故障恢复----惜分飞

来源：这里教程网时间：2026-03-03 16:50:42 作者：

数据库启动报ORA-01092: ORACLE 例程终止。强行断开连接错误

SQL> RECOVER DATABASE;

完成介质恢复。

SQL> ALTER DATABASE OPEN;

ALTER DATABASE OPEN

*

ERROR 位于第 1 行:

ORA-01092: ORACLE 例程终止。强行断开连接

查看alert日志

Wed Jul 21 12:32:04 2021

SMON: enabling cache recovery

Wed Jul 21 12:32:04 2021

Errors 
in 
file 
c:\oracle\admin\dcpdm\udump\dcpdm_ora_3004.trc:

ORA-00600: ?????????: [4194], [34], [8], [], [], [], [], []

Wed Jul 21 12:32:05 2021

Recovery of Online Redo Log: Thread 1 Group 2 Seq 495 Reading mem 0

  
Mem
# 0 errs 0: C:\ORACLE\ORADATA\DCPDM\REDO02.LOG

Recovery of Online Redo Log: Thread 1 Group 2 Seq 495 Reading mem 0

  
Mem
# 0 errs 0: C:\ORACLE\ORADATA\DCPDM\REDO02.LOG

Wed Jul 21 12:32:05 2021

Errors 
in 
file 
c:\oracle\admin\dcpdm\udump\dcpdm_ora_3004.trc:

ORA-00604: ?? SQL ? 1 ????

ORA-00607: ?????????????

ORA-00600: ?????????: [4194], [34], [8], [], [], [], [], []

Error 604 happened during db 
open
, shutting down database

USER: terminating instance due to error 604

Wed Jul 21 12:32:05 2021

Errors 
in 
file 
c:\oracle\admin\dcpdm\bdump\dcpdm_pmon_13020.trc:

ORA-00604: error occurred at recursive SQL level 

Instance terminated by USER, pid = 3004

ORA-1092 signalled during: ALTER DATABASE OPEN...

trace文件信息

*** 2021-07-21 12:32:04.000

ksedmp: internal or fatal error

ORA-00600: ?????????: [4194], [34], [8], [], [], [], [], []

Current SQL statement 
for 
this session:

update undo$ 
set 
name=:2,
file
#=:3,block#=:4,status$=:5,user#=:6,undosqn=:7,xactsqn=:8,

scnbas=:9,scnwrp=:10,inst
#=:11,ts#=:12,spare1=:13 where us#=:1

----- Call Stack Trace -----

calling              call     entry                argument values 
in 
hex      

location             
type     
point                (? means dubious value)     

-------------------- -------- -------------------- ----------------------------

_ksedmp+147          CALLrel  _ksedst+0            

_ksfdmp.108+e        CALLrel  _ksedmp+0            3

_kgeriv+89           CALLreg  00000000             4E59D98 3

_kseipre.107+3f      CALLrel  _kgeriv+0            

_ksesic2+24          CALLrel  _kseipre.107+0       

__VInfreq__kturdb+8  CALLrel  _ksesic2+0           1062 0 22 0 8

b                                                  

_kcoapl+1df          CALLreg  00000000             2BB0F94 2BB100A 11 6C37C014

_kcbapl+71           CALLrel  _kcoapl+0            2BB0F90 6C37C000 1 0 2000

_kcrfwr+734          CALLrel  _kcbapl+0            2BB0F90 6C3FC788 50D4FA0

_kcbchg1+7ec         CALLrel  _kcrfwr+0            

_ktuchg+630          CALLrel  _kcbchg1+0           0 4 50D5228 50D5240 0 0

_ktbchg2+75          CALLrel  _ktuchg+0            2 66F589A4 1 2C8CD14 2C8CD1C

2BB0F90 2C8C32C 2BB0ED0 0 0

_kddchg+18f          CALLrel  _ktbchg2+0           0 66F589A4 2C8CD14 2C8CD1C

2BB0F90 2C8C324 2BB0ED0 0 0

_kduovw.53+6e3       CALLrel  _kddchg+0            2C8C2E8 2C8CD14 2C8CD1C

2BB0F90 2BB0ED0 0 0

_kduurp.53+61a       CALLrel  _kduovw.53+0         2C8C2E8

_kdusru+aa5          CALLrel  _kduurp.53+0         2C8C2E8 66F589FC

_kauupd+12e          CALLrel  _kdusru+0            2C8C71C 66F589FC 2C8C2E8 0

_updrow+729          CALLrel  _kauupd+0            2C8C718 66F589FC 2C8C2E8 0

66F58448 E F 66F60EE0 12

50DBBA4 50DBBA8

_qerupFetch+107      CALLrel  _updrow+0            

_updaul+202          CALL???  00000000             66F58660 0 66F6BC3C 7FFF

_updThreePhaseExe+b  CALLrel  _updaul+0            66F6B9D0 50DBD34 0

6                                                  

_updexe+105          CALLrel  _updThreePhaseExe+0  66F6B9D0 0 2C8C2E8 50DBE10

66F6B9D0 1 50DBE10 0

_opiexe+f97          CALLrel  _updexe+0            66F6B9D0 50DBF4C

_opiodr+4cd          CALLreg  00000000             4 3 50DC898

_rpidrus.43+99       CALLrel  _opiodr+0            4 3 50DC898 A

_skgmstack+71        CALLreg  00000000             50DC488

_rpidru+6d           CALLrel  _skgmstack+0         50DC4A0 4E59C20 F618 778198

50DC488

_rpiswu2+17e         CALLreg  00000000             50DC7C0

_rpidrv+109          CALLrel  _rpiswu2+0           

_rpiexe+33           CALLrel  _rpidrv+0            A 4 50DC898 8

_ktuscu+2a8          CALLrel  _rpiexe+0            A

_kqrcmt+2c2          CALL???  00000000             66F6D654 3

..1.18_2.filter.95+  CALLrel  _kqrcmt+0            67B88CD4 1 0 4E59D98 4E59D98

159                                                FF 0 0 0

..1.23_5.filter.99+  CALLrel  _ktcrcm+0            67B88CD4 0 0 0 0 1 0 0

14d                                                

_ktuini+64           CALLrel  _ktuiup.99+0         50DD994

_adbdrv+2665         CALLrel  _ktuini+0            50DD994

..1.5_1.filter.29+2  CALLrel  _adbdrv+0            

9d                                                 

_opiosq0+9a4         CALLrel  _opiexe+0            4 0 50DDDDC

_kpooprx+c6          CALLrel  _opiosq0+0           3 E 50DDE74 24

_kpoal8+225          CALLrel  _kpooprx+0           50DE73C 50DE684 13 1 0 24

_opiodr+4cd          CALLreg  00000000             5E 14 50DE738

_ttcpip+a86          CALLreg  00000000             5E 14 50DE738 0

_opitsk+2f4          CALLrel  _ttcpip+0            

_opiino+5fc          CALLrel  _opitsk+0            0 0 4E5FEE8 2BDF044 F3 0

_opiodr+4cd          CALLreg  00000000             3C 4 50DFBD8

_opidrv+233          CALLrel  _opiodr+0            3C 4 50DFBD8 0

_sou2o+19            CALLrel  _opidrv+0            

_opimai+10a          CALLrel  _sou2o+0             

_OracleThreadStart@  CALLrel  _opimai+0            

4+35c                                              

7C824826             CALLreg  00000000             

--------------------- Binary Stack Dump ---------------------

比较明显时候由于在更新undo$的时候需要找前镜像信息

Block image after block recovery:

buffer tsn: 0 rdba: 0x0040018b (1
/395
)

scn: 0x0000.07d52871 
seq
: 0x01 flg: 0x04 
tail
: 0x28710201

frmt: 0x02 chkval: 0xc85e 
type
: 0x02=KTU UNDO BLOCK

********************************************************************************

UNDO BLK:  

xid: 0x0000.05a.0000002d  
seq
: 0x33  cnt: 0x22  irb: 0x22  icl: 0x0   flg: 0x0000

Rec Offset      Rec Offset      Rec Offset      Rec Offset      Rec Offset

---------------------------------------------------------------------------

0x01 0x1f04     0x02 0x1e20     0x03 0x1d3c     0x04 0x1c58     0x05 0x1b74     

0x06 0x1a90     0x07 0x19ac     0x08 0x18c8     0x09 0x17e4     0x0a 0x1700     

0x0b 0x161c     0x0c 0x1538     0x0d 0x1454     0x0e 0x1370     0x0f 0x128c     

0x10 0x11a8     0x11 0x10c4     0x12 0x0fe0     0x13 0x0efc     0x14 0x0e18     

0x15 0x0d34     0x16 0x0c50     0x17 0x0b6c     0x18 0x0a88     0x19 0x09a4     

0x1a 0x08c0     0x1b 0x07dc     0x1c 0x06f8     0x1d 0x0614     0x1e 0x0530     

0x1f 0x044c     0x20 0x0368     0x21 0x0284     0x22 0x01a0     

*-----------------------------

* Rec 
#0x1  slt: 0x0b  objn: 15(0x0000000f)  objd: 15  tblspc: 0(0x00000000)

*       Layer:  11 (Row)   opc: 1   rci 0x00   

Undo 
type
:  Regular undo    Begin trans    Last buffer 
split
:  No 

Temp Object:  No 

Tablespace Undo:  No 

rdba: 0x00000000

*-----------------------------

uba: 0x0040018a.0033.22 ctl max scn: 0x0000.07853941 prv tx scn: 0x0000.07853943

KDO undo record:

KTB Redo 

op
: 0x04  ver: 0x01  

op
: L  itl: xid:  0x0000.042.0000002d uba: 0x0040018a.0033.22

flg: C---    lkc:  0     scn: 0x0000.07d23460

KDO Op code: URP row dependencies Disabled

xtype: XA  bdba: 0x0040006a  hdba: 0x00400069

itli: 1  ispac: 0  maxfr: 4863

tabn: 0 slot: 7(0x7) flag: 0x2c lock: 0 ckix: 0

ncol: 17 nnew: 12 size: 0

col  1: [ 9]  5f 53 59 53 53 4d 55 37 24

col  2: [ 2]  c1 02

col  3: [ 2]  c1 03

col  4: [ 3]  c2 02 06

col  5: [ 6]  c5 02 20 14 40 24

col  6: [ 1]  80

col  7: [ 4]  c3 0e 21 2d

col  8: [ 3]  c2 1b 34

col  9: [ 1]  80

col 10: [ 2]  c1 03

col 11: [ 2]  c1 02

col 16: [ 2]  c1 02

这部分信息异常,导致数据库update undo$的时候报ORA-00600: ?????????: [4194], [34], [8], [], [], [], [], []错误,通过修改对应的block信息,数据库正常open成功

SQL> alter database 
open
;

数据库已更改。

但是关闭数据库又报ORA-600 4194错误

SQL> 
shutdown 
immediate;

ORA-00607: 当更改数据块时出现内部错误

ORA-00600: 内部错误代码，参数: [4194], [94], [61], [], [], [], [], []

alert日志信息

Wed Jul 21 12:58:42 2021

Shutting down instance: further logons disabled

Shutting down instance (immediate)

License high water mark = 3

Waiting 
for 
dispatcher 
'D000' 
to 
shutdown

All dispatchers and shared servers 
shutdown

Wed Jul 21 12:58:45 2021

ALTER DATABASE CLOSE NORMAL

Wed Jul 21 12:58:45 2021

Errors 
in 
file 
c:\oracle\admin\dcpdm\udump\dcpdm_ora_13628.trc:

ORA-00600: 内部错误代码，参数: [4194], [94], [61], [], [], [], [], []

Recovery of Online Redo Log: Thread 1 Group 3 Seq 496 Reading mem 0

  
Mem
# 0 errs 0: C:\ORACLE\ORADATA\DCPDM\REDO03.LOG

Recovery of Online Redo Log: Thread 1 Group 3 Seq 496 Reading mem 0

  
Mem
# 0 errs 0: C:\ORACLE\ORADATA\DCPDM\REDO03.LOG

ORA-607 signalled during: ALTER DATABASE CLOSE NORMAL...