标签云
asm mount asm 恢复 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 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-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)
- 操作系统 (98)
- 数据库 (1,556)
- DB2 (22)
- MySQL (66)
- Oracle (1,430)
- Data Guard (47)
- EXADATA (7)
- GoldenGate (21)
- ORA-xxxxx (158)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (13)
- ORACLE 21C (3)
- Oracle ASM (65)
- Oracle Bug (7)
- Oracle RAC (46)
- Oracle 安全 (6)
- Oracle 开发 (27)
- Oracle 监听 (26)
- Oracle备份恢复 (505)
- Oracle安装升级 (81)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (74)
- PostgreSQL (13)
- PostgreSQL恢复 (3)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (36)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (19)
-
最近发表
- DBV-00107: Unknown header format 故障处理
- A____Z____RECOVER____DATA勒索恢复
- ORA-1200/ORA-1207数据库恢复
- 存储断电导致ORA-00325故障恢复
- 重建ctl遭遇ORA-01163 ORA-01110和ORA-600 kccccfl_1错误
- RFS[22349]: Database mount ID mismatch
- 触发器找出密码错误应用
- redhat和oracle linux kernel对应关系—202310
- 11.2.0.4最新patch信息(扩展补丁)–202310
- 再现ORA-600 4000故障处理
- ORA-600 12807(CON$.CON#达到最大值) 处理
- 非tns方式登录pdb方法
- ORA-07445: exception encountered: core dump [kdxlin()+4088]处理
- bbed解决ORA-01578
- asm disk被加入到另外一个磁盘组故障恢复
- ORA-600 ksuloget2 恢复
- ORA-10485: Real-Time Query cannot be enabled while applying migration redo.
- Patch SCN一键解决ORA-600 2662故障
- amdu参数详解
- ORA-600 kghstack_underflow_internal_2
友情链接
标签归档:ORA-600 4194
win强制修改盘符导致oracle异常恢复
有客户反馈,他们在系统没有关闭数据库的情况下,强制修改了win系统盘符,然后导致数据库异常,启动报错
Sat Feb 25 12:50:40 2023 Recovery of Online Redo Log: Thread 1 Group 2 Seq 10440 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG Sat Feb 25 12:50:40 2023 Completed redo application Sat Feb 25 12:50:40 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p001_5604.trc: ORA-00600: 内部错误代码, 参数: [2037], [25801018], [2973409798], [6], [255], [25], [1198764346], [100796692] Sat Feb 25 12:50:40 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_7648.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION][_kslwlmod+166][PC:0x469742][ADDR:0x54F8][UNABLE_TO_WRITE][] ORA-04096: 触发器 '' 的 WHEN 子句过大, 限量为 2K Sat Feb 25 12:50:40 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_7252.trc: ORA-00600: internal error code, arguments: [ksuapc2], [258], [0], [2], [1], [2], [], [] Sat Feb 25 12:50:43 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p001_5604.trc: ORA-00081: 地址范围 [0x77240440, 0x77240444) 不可读 ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION][_ksl_cleanup+723][PC:0x46E373][ADDR:0x1C][UNABLE_TO_READ][] ORA-00081: 地址范围 [0x77240440, 0x77240444) 不可读 ORA-00600: 内部错误代码, 参数: [2037], [25801018], [2973409798], [6], [255], [25], [1198764346], [100796692] Sat Feb 25 12:50:45 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_6332.trc: ORA-07445: ??????: ???? [ACCESS_VIOLATION][_kews_idle_wait+378][PC:0x604AE6][ADDR:0xED30C470][UNABLE_TO_WRITE][] Sat Feb 25 12:50:48 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_7648.trc: ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参 Sat Feb 25 12:51:34 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_d000_8116.trc: ORA-07445: ??????: ???? [ACCESS_VIOLATION][_kmcgms+121][PC:0x5D6C71][ADDR:0x50][UNABLE_TO_WRITE][] Sat Feb 25 12:52:04 2023 USER: terminating instance due to error 472 Sat Feb 25 12:52:48 2023 USER: terminating instance due to error 472 Sat Feb 25 12:52:48 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_6252.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION][_ksuitm+631][PC:0x410C07][ADDR:0x1][UNABLE_TO_READ][] Sat Feb 25 12:55:35 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_7656.trc: ORA-07445: ??????: ???? [ACCESS_VIOLATION][_kews_idle_wait+378][PC:0x604AE6][ADDR:0xE530C470][UNABLE_TO_WRITE][]
通过恢复一些恢复之后,数据库open之后又挂掉
Sat Feb 25 15:05:49 2023 SMON: enabling tx recovery Sat Feb 25 15:05:49 2023 Database Characterset is ZHS16GBK Sat Feb 25 15:05:50 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_5308.trc: ORA-00600: 内部错误代码, 参数: [4194], [34], [31], [], [], [], [], [] Sat Feb 25 15:05:50 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_7568.trc: ORA-00600: 内部错误代码, 参数: [kcbgtcr_13], [], [], [], [], [], [], [] Sat Feb 25 15:05:51 2023 Non-fatal internal error happenned while SMON was doing logging scn->time mapping. SMON encountered 1 out of maximum 100 non-fatal internal errors. Sat Feb 25 15:05:51 2023 Doing block recovery for file 2 block 2951 Block recovery from logseq 10441, block 78 to scn 109906860017 Sat Feb 25 15:05:51 2023 Recovery of Online Redo Log: Thread 1 Group 3 Seq 10441 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG Block recovery stopped at EOT rba 10441.81.16 Block recovery completed at rba 10441.81.16, scn 25.2532677517 Doing block recovery for file 2 block 113 Block recovery from logseq 10441, block 78 to scn 109906859718 Sat Feb 25 15:05:52 2023 Recovery of Online Redo Log: Thread 1 Group 3 Seq 10441 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG Block recovery completed at rba 10441.80.16, scn 25.2532677516 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=30, OS id=6904 Sat Feb 25 15:05:53 2023 db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Sat Feb 25 15:05:53 2023 Completed: alter database open Sat Feb 25 15:05:53 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_5400.trc: ORA-00600: 内部错误代码, 参数: [4194], [6], [4], [], [], [], [], [] Sat Feb 25 15:05:54 2023 DEBUG: Replaying xcb 0xac458698, pmd 0x8d7e9b9c for failed op 8 Doing block recovery for file 2 block 1515 No block recovery was needed Sat Feb 25 15:05:55 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_5400.trc: ORA-00600: 内部错误代码, 参数: [4194], [6], [4], [], [], [], [], [] ORA-00600: 内部错误代码, 参数: [4194], [6], [4], [], [], [], [], [] Sat Feb 25 15:05:56 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_5400.trc: ORA-00603: ORACLE server session terminated by fatal error ORA-00600: internal error code, arguments: [4194], [6], [4], [], [], [], [], [] ORA-00600: internal error code, arguments: [4194], [6], [4], [], [], [], [], [] Sat Feb 25 15:05:57 2023 Doing block recovery for file 2 block 2951 Block recovery from logseq 10441, block 78 to scn 109906860017 Sat Feb 25 15:05:57 2023 Recovery of Online Redo Log: Thread 1 Group 3 Seq 10441 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG Block recovery completed at rba 10441.81.16, scn 25.2532677620 Doing block recovery for file 2 block 113 Block recovery from logseq 10441, block 78 to scn 109906860083 Sat Feb 25 15:05:57 2023 Recovery of Online Redo Log: Thread 1 Group 3 Seq 10441 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG Block recovery completed at rba 10441.138.16, scn 25.2532677684 Sat Feb 25 15:05:57 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j003_1716.trc: ORA-12012: 自动执行作业 42568 出错 ORA-00607: 当更改数据块时出现内部错误 ORA-00607: 当更改数据块时出现内部错误 Sat Feb 25 15:05:59 2023 Flush retried for xcb 0xac4c5a80, pmd 0x8c0cec74 Doing block recovery for file 2 block 2951 Block recovery from logseq 10441, block 78 to scn 109906860017 Sat Feb 25 15:05:59 2023 Recovery of Online Redo Log: Thread 1 Group 3 Seq 10441 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG Sat Feb 25 15:05:59 2023 DEBUG: Replaying xcb 0xac458698, pmd 0x8d7e9b9c for failed op 8 Doing block recovery for file 2 block 1515 No block recovery was needed Sat Feb 25 15:05:59 2023 Block recovery completed at rba 10441.81.16, scn 25.2532677620 Sat Feb 25 15:06:00 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j002_6400.trc: ORA-00600: internal error code, arguments: [4194], [6], [4], [], [], [], [], [] Sat Feb 25 15:06:02 2023 DEBUG: Replaying xcb 0xac458698, pmd 0x8d7e9b9c for failed op 8 Doing block recovery for file 2 block 1515 No block recovery was needed Sat Feb 25 15:06:02 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_1076.trc: ORA-00600: 内部错误代码, 参数: [4194], [6], [4], [], [], [], [], [] Sat Feb 25 15:06:03 2023 PMON: terminating instance due to error 472 Sat Feb 25 15:06:03 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j007_7188.trc: ORA-00472: PMON 进程因错误而终止 Sat Feb 25 15:06:03 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j006_7624.trc: ORA-00472: PMON 进程因错误而终止 Sat Feb 25 15:06:03 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j005_5688.trc: ORA-00472: PMON process terminated with error Sat Feb 25 15:06:10 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_7568.trc: ORA-00472: PMON 进程因错误而终止 Instance terminated by PMON, pid = 1076
这个ORA-600 4194错误主要是由于undo异常,从而引起pmon异常,报ORA-00472错误.对undo进行处理,数据库稳定open,逻辑导出数据,完成恢复工作,完美帮忙客户恢复数据.
发表在 Oracle备份恢复
标签为 ksuapc2, ORA-00081, ORA-00472, ORA-600 2037, ORA-600 4194, _kews_idle_wait, _kmcgms, _kslwlmod, _ksuitm
评论关闭
Patch SCN工具快速解决ORA-600 2662问题
有一个数据库由于redo异常,强制拉库启动的时候报ORA-600 2662
SQL> ALTER DATABASE OPEN RESETLOGS; ALTER DATABASE OPEN RESETLOGS * ERROR at line 1: ORA-00603: ORACLE server session terminated by fatal error ORA-00600: internal error code, arguments: [2662], [9], [1784167757], [9], [1784229886], [12583040], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [2662], [9], [1784167756], [9], [1784229886], [12583040], [], [], [], [], [], [] ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [2662], [9], [1784167754], [9], [1784229886], [12583040], [], [], [], [], [], [] Process ID: 8500 Session ID: 2647 Serial number: 1
Sun Oct 23 06:51:13 2022 SMON: enabling cache recovery ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\trace\xff01_ora_5016.trc (incident=264609): ORA-00600: ??????, ??: [2662], [9], [1784167754], [9], [1784229886], [12583040], [], [], [], [], [], [] Incident details in: C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\incident\incdir_264609\xff01_ora_5016_i264609.trc Sun Oct 23 06:51:17 2022 Dumping diagnostic data in directory=[cdmp_20221023065117],requested by (instance=1,osid=5016),summary=[incident=264609]. Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\trace\xff01_ora_5016.trc: ORA-00600: ??????, ??: [2662], [9], [1784167754], [9], [1784229886], [12583040], [], [], [], [], [], [] Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\trace\xff01_ora_5016.trc: ORA-00600: ??????, ??: [2662], [9], [1784167754], [9], [1784229886], [12583040], [], [], [], [], [], [] Error 600 happened during db open, shutting down database USER (ospid: 5016): terminating the instance due to error 600 Sun Oct 23 06:51:22 2022 Instance terminated by USER, pid = 5016 ORA-1092 signalled during: alter database open resetlogs...
报错比较明显由于scn问题导致,对于这个问题通过以前研发的Patch_SCN工具一键解决
解决给问题之后,open数据库遭遇ora-600 4194错误
Database Characterset is ZHS16GBK ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\trace\xff01_smon_4388.trc (incident=296569): ORA-00600: 内部错误代码, 参数: [4194], [], [], [], [], [], [], [], [], [], [], [] Incident details in: C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\incident\incdir_296569\xff01_smon_4388_i296569.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. No Resource Manager plan active Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\trace\xff01_ora_1628.trc (incident=296617): ORA-00600: 内部错误代码, 参数: [4193], [], [], [], [], [], [], [], [], [], [], [] Incident details in: C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\incident\incdir_296617\xff01_ora_1628_i296617.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Sun Oct 23 08:23:02 2022 Block recovery from logseq 1, block 568 to scn 41438874500 Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0 Mem# 0: E:\ORADATA\ONLINELOG\GROUP_1.261.840661629 Mem# 1: E:\ORADATA\ONLINELOG\GROUP_1.269.840661631 Block recovery stopped at EOT rba 1.570.16 Block recovery completed at rba 1.570.16, scn 9.2784168835 Block recovery from logseq 1, block 568 to scn 41438874497 Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0 Mem# 0: E:\ORADATA\ONLINELOG\GROUP_1.261.840661629 Mem# 1: E:\ORADATA\ONLINELOG\GROUP_1.269.840661631 Block recovery completed at rba 1.568.16, scn 9.2784168834 Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\trace\xff01_smon_4388.trc: ORA-01595: 释放区 (2) 回退段 (1) 时出错 ORA-00600: 内部错误代码, 参数: [4194], [], [], [], [], [], [], [], [], [], [], []
处理异常undo问题,数据库open成功,建议业务安排导出数据导入新库,完成本次恢复
Patch_SCN下载:Patch_SCN下载
Patch_SCN使用说明:Patch_SCN使用说明
发表在 Oracle, Oracle备份恢复
标签为 ORA-600 4193, ORA-600 4194, patch scn ORA-600 2662, patch scn 修改scn, 一键修改scn
评论关闭
又一例ORA-600 kcratr_nab_less_than_odr
数据库启动报错ORA-600 kcratr_nab_less_than_odr
alter database open Sat Jul 23 21:38:32 2022 Beginning crash recovery of 1 threads parallel recovery started with 19 processes Sat Jul 23 21:38:33 2022 Started redo scan Sat Jul 23 21:38:33 2022 Completed redo scan read 244 KB redo, 64 data blocks need recovery Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_5748.trc (incident=309845): ORA-00600: ??????, ??: [kcratr_nab_less_than_odr], [1], [10343], [67442], [67454], [], [], [], [], [], [], [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:34 2022 Slave encountered ORA-10388 exception during crash recovery Sat Jul 23 21:38:38 2022 Aborting crash recovery due to error 600 Sat Jul 23 21:38:38 2022 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_5748.trc: ORA-00600: ??????, ??: [kcratr_nab_less_than_odr], [1], [10343], [67442], [67454], [], [], [], [], [], [], [] Sat Jul 23 21:38:39 2022 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_5748.trc: ORA-00600: ??????, ??: [kcratr_nab_less_than_odr], [1], [10343], [67442], [67454], [], [], [], [], [], [], [] ORA-600 signalled during: alter database open...
这个错误比较简单,参考:
12c启动报kcratr_nab_less_than_odr
ORA-600 kcratr_nab_less_than_odr故障解决
解决该问题之后,数据库启动报ORA-600 4194错误
Mon Jul 25 12:18:04 2022 SMON: enabling tx recovery Starting background process SMCO Mon Jul 25 12:18:05 2022 SMCO started with pid=26, OS id=8164 Mon Jul 25 12:18:06 2022 Database Characterset is ZHS16GBK ORA-00600: ??????, ??: [4194], [46], [44], [], [], [], [], [], [], [], [], [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Mon Jul 25 12:18:14 2022 Doing block recovery for file 5 block 1267 Mon Jul 25 12:18:14 2022 Resuming block recovery (PMON) for file 5 block 1267 Block recovery from logseq 1, block 67 to scn 217083444 Mon Jul 25 12:18:15 2022 Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0 Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL12C\REDO01.LOG Block recovery stopped at EOT rba 1.68.16 Block recovery completed at rba 1.68.16, scn 0.217083444 Doing block recovery for file 5 block 272 Resuming block recovery (PMON) for file 5 block 272 Block recovery from logseq 1, block 67 to scn 217083443 Mon Jul 25 12:18:18 2022 Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0 Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL12C\REDO01.LOG Block recovery completed at rba 1.68.16, scn 0.217083444 Mon Jul 25 12:18:19 2022 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_smon_7100.trc: ORA-01595: 释放区 (5) 回退段 (10) 时出错 ORA-00600: ??????, ??: [4194], [46], [44], [], [], [], [], [], [], [], [], [] Mon Jul 25 12:18:19 2022 No Resource Manager plan active Mon Jul 25 12:18:23 2022 Sweep [inc][317000]: completed Sweep [inc2][317000]: completed Starting background process FBDA Mon Jul 25 12:18:40 2022 FBDA started with pid=28, OS id=7828 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_5804.trc (incident=317056): ORA-00600: 内部错误代码, 参数: [4194], [46], [44], [], [], [], [], [], [], [], [], [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Mon Jul 25 12:18:53 2022 Doing block recovery for file 5 block 1267 Resuming block recovery (PMON) for file 5 block 1267 Block recovery from logseq 1, block 67 to scn 217083444 Mon Jul 25 12:18:53 2022 Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0 Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL12C\REDO01.LOG Block recovery completed at rba 1.68.16, scn 0.217083454 Doing block recovery for file 5 block 272 Resuming block recovery (PMON) for file 5 block 272 Block recovery from logseq 1, block 67 to scn 217083454 Mon Jul 25 12:18:54 2022 Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0 Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL12C\REDO01.LOG Block recovery completed at rba 1.69.16, scn 0.217083455 Mon Jul 25 12:18:55 2022 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_5804.trc: ORA-00600: 内部错误代码, 参数: [4194], [46], [44], [], [], [], [], [], [], [], [], [] Mon Jul 25 12:18:55 2022 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl12c\orcl12c\trace\orcl12c_ora_5804.trc: ORA-00600: 内部错误代码, 参数: [4194], [46], [44], [], [], [], [], [], [], [], [], [] Error 600 happened during db open, shutting down database USER (ospid: 5804): terminating the instance due to error 600 Mon Jul 25 12:19:07 2022 Instance terminated by USER, pid = 5804 ORA-1092 signalled during: alter database open resetlogs...
该错误也比较简单,对异常undo段进行处理即可,参考类似操作:How to resolve ORA-600 [4194] errors