ORA-00600 [4194]的解决

最新推荐文章于 2024-08-29 10:19:21 发布

xionglang7

最新推荐文章于 2024-08-29 10:19:21 发布

阅读量4.9k

点赞数 1

分类专栏： oracle 文章标签： undo ora-600 4193 or

本文链接：https://blog.csdn.net/xionglang7/article/details/25408701

版权

在将standby数据库转为测试库并重建控制文件后，遭遇数据库崩溃，出现ORA-00600 [4194]错误。此问题与ORA-00600 [4193]类似，根源在于undo管理。解决方案包括将undo模式切换为手动，并重新创建undo表空间。

摘要由CSDN通过智能技术生成

今天遇到一个standby 拷贝出来的库，要建成测试库！

重建控制文件，用resetlogs起库后，数据库直接down掉了。

报了一堆ora-600 [4194]的问题出来

Fri May 09 11:38:24 2014
opidrv aborting process M000 ospid (20091) as a result of ORA-603
Fri May 09 11:38:27 2014
Flush retried for xcb 0x44053b268, pmd 0x43f7e9628
Errors in file /paic/t2fls/rdbms/oracle/diag/rdbms/t2fls/t2fls/trace/t2fls_pmon_16902.trc  (incident=17):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /paic/t2fls/rdbms/oracle/diag/rdbms/t2fls/t2fls/incident/incdir_17/t2fls_pmon_16902_i17.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri May 09 11:38:29 2014
Dumping diagnostic data in directory=[cdmp_20140509113829], requested by (instance=1, osid=16902 (PMON)), summary=[incident=17].
Errors in file /paic/t2fls/rdbms/oracle/diag/rdbms/t2fls/t2fls/trace/t2fls_pmon_16902.trc:
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
PMON (ospid: 16902): terminating the instance due to error 472
System state dump requested by (instance=1, osid=16902 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /paic/t2fls/rdbms/oracle/diag/rdbms/t2fls/t2fls/trace/t2fls_diag_16973.trc
Dumping diagnostic data in directory=[cdmp_20140509113834], requested by (instance=1, o