本文主要是介绍ora - 00600 undo文件破坏重建，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
今天碰到了ora-600 的错误，数据库open后，马上又当掉，
看一下alert 日志：
Errors in file /u01/pp/oracle/admin/ezhou/bdump/ezhou_j003_5692.trc:
ORA-00600: internal error code, arguments: [4194], [30],[27],
看一下metalink 得来的信息：
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 recorded in the undo block.
This error is reported when the validation fails.
ARGUMENTS:
Arg [a] Maximum Undo record number in Undo block
Arg [b] Undo record number from Redo block
IMPACT:
PROCESS FAILURE
POSSIBLE ROLLBACK SEGMENT CORRUPTION
SUGGESTIONS:
This error may indicate a rollback segment corruption.
This may require a recovery from a database backup depending on
the situation.
三、解决办法
1、修改参数
undo_management= MANUAL
undo_tablespace= SYSTEM
2、打开数据库，删除当前undo空间，重建新undo空间：
SQL> alter tablespace UNDOTBS1 offline;
Tablespace altered.
SQL> DROP TABLESPACE UNDOTBS1;
Tablespace dropped.
create undo tablespace undotbs02 datafile '/u02/ezhou/undotbs02.dbf' size 100m;
3、修改参数
undo_management= AUTO
undo_tablespace= UNDOTBSNEW
4、重新启动数据库
startup pfile='/tmp/pfile' force
这篇关于ora - 00600 undo文件破坏重建的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
