标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (102)
- 数据库 (1,682)
- DB2 (22)
- MySQL (73)
- Oracle (1,544)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (67)
- Oracle Bug (8)
- Oracle RAC (53)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (565)
- Oracle安装升级 (92)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (79)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- 断电引起的ORA-08102: 未找到索引关键字, 对象号 39故障处理
- ORA-00227: corrupt block detected in control file
- 手工删除19c rac
- 解决oracle数据文件路径有回车故障
- .wstop扩展名勒索数据库恢复
- Oracle Recovery Tools工具一键解决ORA-00376 ORA-01110故障(文件offline)
- OGG-02771 Input trail file format RELEASE 19.1 is different from previous trail file form at RELEASE 11.2.
- OGG-02246 Source redo compatibility level 19.0.0 requires trail FORMAT 12.2 or higher
- GoldenGate 19安装和打patch
- dd破坏asm磁盘头恢复
- 删除asmlib磁盘导致磁盘组故障恢复
- Kylin Linux 安装19c
- ORA-600 krse_arc_complete.4
- Oracle 19c 202410补丁(RUs+OJVM)
- ntfs MFT损坏(ntfs文件系统故障)导致oracle异常恢复
- .mkp扩展名oracle数据文件加密恢复
- 清空redo,导致ORA-27048: skgfifi: file header information is invalid
- A_H_README_TO_RECOVER勒索恢复
- 通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评
- ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME
标签归档:ORA-00604 ORA-00607 ORA-00600
ORA-01092: ORACLE 例程终止 故障恢复
数据库启动报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...
通过重建undo,数据库启动关闭正常,也没有再报其他错误,建议逻辑方式重建库
参考以前的类似文章:
数据库报ORA-00607/ORA-00600[4194]错误
使用bbed解决ORA-00607/ORA-00600[4194]故障
使用bbed解决ORA-00607/ORA-00600[4194]故障