Oracle数据库报错ORA-00600[4193][4194]的解决方法与处理过程

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:47

Oracle 数据库出现报错ORA-00600[4193][4194]的解决方法

ORA-00600 4193一般来说是undo表空间的问题,通常是因为恢复时redo与undo不一致所导致。ORA-00600 4194错误一般是由于undo表空间损坏导致部分事务无法回滚,因而导致数据库无法启动或启动后又被PMON中止。

官方的原话如下:[color=green]While backing out an undo record (i.e. at the time of rollback) we found a transaction id mis-match indicating either a corruption in the rollback segment or corruption in an object which the rollback segment is trying to apply undo records on. This would indicate a corrupted rollback segment.
[color=green]A mismatch has been detected between Redo records and rollback (Undo) records.We are validating the Undo record number relating to the change being applied against the maximum undo record number recordedinthe undo block.This error is reported when the validation fails.

4193:表示undo和redo不一致(Arg [a] Undo record seq number,Arg Redo record seq number );
4194:表示也是undo和redo不一致(Arg [a] Maximum Undo record number in Undo block,Arg Undo record number from Redo block)

下面是一套几个TB的数据库存储损坏后,数据库修复的过程中出现的ORA-00600 4193与4194报错,如下:
Fri Jul 03 13:55:03 BEIST 2013Errors in file /app/oracle/admin/rac/bdump/rac_mmon_6881294.trc:ORA-00600: internal error code, arguments: [4194], [32], [35], [], [], [], [], []Fri Jul 03 13:55:04 BEIST 2013Errors in file /app/oracle/admin/rac/udump/rac_ora_6160740.trc:ORA-00600: internal error code, arguments: [4194], [36], [39], [], [], [], [], []
Fri Jul 03 13:55:07 BEIST 2013Errors in file /app/oracle/admin/rac/bdump/rac1_q000_2163192.trc:ORA-00600: internal error code, arguments: [4193], [3033], [3388], [], [], [], [], []Fri Jul 03 13:55:18 BEIST 2013Errors in file /app/oracle/admin/rac/bdump/rac1_mmon_6881294.trc:ORA-00600: internal error code, arguments: [4193], [1764], [3385], [], [], [], [], []

以上ORA-00600 4193与4194报错的解决办法是:

1、修改参数
undo_management= MANUAL
undo_tablespace= SYSTEM
2、打开数据库,删除当前undo空间,重建新undo空间
3、修改参数
undo_management= AUTO
undo_tablespace= UNDOTBSNEW[color=green](新的回滚段表空间名)
4、重新启动数据库

5、如果出现极端的情况可能需要做如下处理:
1)使用_offline_rollback_segments和_corrupted_rollback_segments屏蔽掉有问题的undo segment
2)继续可能出现ora-600[2662],需要推进scn。

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】