ora 06512是什么错误_ORA-600[4193]解决

ORA-600[4193]解决
在解决了ORA-600 [2662]后，库启动的时候出现ORA-600[4193]错误
Tue Feb 14 09:34:11 2012
Errors in file d:oracleproduct10.2.0admininterlibbdumpinterlib_smon_2784.trc:
ORA-01595: error freeing extent (2) of rollback segment (3))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [6], [30], [], [], [], [], []
Tue Feb 14 09:35:34 2012
Errors in file d:oracleproduct10.2.0admininterlibudumpinterlib_ora_2824.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [4193], [2005], [2008], [], [], [], [], []
ORA-00600: internal error code, arguments: [4193], [2005], [2008], [], [], [], [], []
Tue Feb 14 09:36:30 2012
DEBUG: Replaying xcb 0x1fa24174, pmd 0x1fba06d4 for failed op 8
Doing block recovery for file 2 block 177
No block recovery was needed
Tue Feb 14 09:37:30 2012
Errors in file d:oracleproduct10.2.0admininterlibbdumpinterlib_pmon_2732.trc:
ORA-00600: internal error code, arguments: [4193], [2005], [2008], [], [], [], [], []
Tue Feb 14 09:37:31 2012
Errors in file d:oracleproduct10.2.0admininterlibbdumpinterlib_pmon_2732.trc:
ORA-00600: internal error code, arguments: [4193], [2005], [2008], [], [], [], [], []
从这里可以看到出现了ORA-600[4194]/[4193]，第一感觉就是undo出现问题。
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） 至于为什么有时候会只出现其中一个，我不太清楚，求答案 直接设置了下面参数，数据库就意外的open成功，这位朋友比较幸运undo_tablespace=SYSTEMundo_management=MANUAL既然库已经open，然后新建undo空间，删除出问题的undo，做如下修改，数据库恢复完成undo_tablespace=新undoundo_management=AUTO如果出现极端的情况可能需要做如下处理:1.使用_offline_rollback_segments和_corrupted_rollback_segments屏蔽掉有问题的undo segment 2.继续可能出现ora-600[2662]，需要推进scn