ORA-600 [4194] 说明
来源:互联网 发布:淘宝粉红色高跟鞋 编辑:程序博客网 时间:2024/05/01 13:11
一. 说明
朋友的一个库不能打开,错误信息如下:
Errors in filef:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_1200.trc (incident=89062):
ORA-00600: 内部错误代码, 参数: [4194],[78], [8], [], [], [], [], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [4194],[78], [8], [], [], [], [], [], [], [], [], []
Incident details in:f:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_89062\orcl_ora_1200_i89062.trc
Trace dumping is performingid=[cdmp_20120730184640]
Errors in file f:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_1200.trc:
ORA-00600: 内部错误代码, 参数: [4194],[78], [8], [], [], [], [], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [4194],[78], [8], [], [], [], [], [], [], [], [], []
Mon Jul 30 18:46:41 2012
Errors in filef:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_1200.trc (incident=90109):
ORA-00603: ORACLE server session terminatedby fatal error
ORA-00600: internal error code, arguments:[4194], [78], [8], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments:[4194], [78], [8], [], [], [], [], [], [], [], [], []
Incident details in:f:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_90109\orcl_ora_1200_i90109.trc
Errors in filef:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_90109\orcl_ora_1200_i90109.trc:
ORA-00603: ORACLE server session terminatedby fatal error
ORA-00600: internal error code, arguments:[4194], [78], [8], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments:[4194], [78], [8], [], [], [], [], [], [], [], [], []
有关ORA-600[41XX]格式的都是与UNDO 有关。
二. MOS 关于ORA-600[4194] 说明
ORA-600 [4194] "Undo Record NumberMismatch While Adding Undo Record" [ID 39283.1]
ERROR:
Format: ORA-600 [4194] [a] [b]
VERSIONS:
versions 6.0 to 10.1
DESCRIPTION:
Amismatch has been detected between Redo records and rollback (Undo) records.
--这个错误是检测Redo records和rollback(Undo)records不一致。
Weare validating the Undo record number relating to the change being appliedagainst the maximum undo record number recorded in the undo block.
Thiserror is reported when the validation fails.
ARGUMENTS:
Arg[a] Maximum Undo record number in Undo block
--这里的参数[a] 是undo block中最大的undo record数。
Arg[b] Undo record number from Redo block
--参数[b]是Redo block中的undo records。
FUNCTIONALITY:
Kernel Transaction Undo called from Cache layer
IMPACT:
PROCESSFAILURE
POSSIBLE ROLLBACK SEGMENT CORRUPTION
SUGGESTIONS:
This error may indicate a rollback segment corruption.
This may require a recovery from a database backup depending on thesituation.
三. 解决方法
重建UNDO 表空间。具体操作参考:
Currentonline Redo 和 Undo 损坏的处理方法
http://blog.csdn.net/tianlesoftware/article/details/6261475
相关链接:
Oracle undo 表空间管理
http://blog.csdn.net/tianlesoftware/article/details/5689558
OracleORA-600[4193] 解决方法 说明
http://blog.csdn.net/tianlesoftware/article/details/7238771
-------------------------------------------------------------------------------------------------------
版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!
Skype: tianlesoftware
QQ: tianlesoftware@gmail.com
Email: tianlesoftware@gmail.com
Blog: http://www.tianlesoftware.com
Weibo: http://weibo.com/tianlesoftware
Twitter: http://twitter.com/tianlesoftware
Facebook: http://www.facebook.com/tianlesoftware
Linkedin: http://cn.linkedin.com/in/tianlesoftware
-------加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请----
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群:83829929 DBA5群: 142216823
DBA6 群:158654907 DBA7 群:172855474 DBA总群:104207940
- ORA-600 [4194] 说明
- ORA-600 各个参数含义说明
- ORA-600 各个参数含义说明
- Oracle ORA-600[4193] 解决方法 说明
- ORA-600 各个参数含义说明
- ORA-600 各个参数含义说明
- listener.ora 配置说明
- ORA-607/ORA-600 [4194]异常处理
- ora-600 4194错
- 简单配置 listener.ora tnsname.ora 以及 sqlnet.ora 说明
- oracle listener.ora,sqlnet.ora,tnsnames.ora配置说明
- oracle listener.ora,sqlnet.ora,tnsnames.ora配置说明
- Oracle ORA-04031 错误 说明
- Oracle ORA-04031 错误 说明
- ORA-600[4194]/[4193]解决
- ORA-600 [2662] Block SCN is ahead of Current SCN 处理方法 说明
- ORA-600 [2662] Block SCN is ahead of Current SCN 处理方法 说明
- ORA-600 [2662] Block SCN is ahead of Current SCN 处理方法 说明
- struts2之5--国际化支持
- undo系列学习之undo入门基础知识介绍
- bash shell获取进程的pid
- ASCII中LF与CR区别 ?
- FMDatabase 的使用方法
- ORA-600 [4194] 说明
- ios学习笔记之 类变量与实例变量区别
- C_链表
- FFMpeg 中比较重要的函数以及数据结构
- uva-439 - Knight Moves
- echo 与printf的异同
- Java并发编程实现—Concurrent—初步学习
- 基数排序(桶式排序的扩展?)
- 使用SeaJS实现模块化JavaScript开发