问题：我的数据库重新启动后，出现了Ora-00600 4194错误，具体的日志如下：
Sat Jan 21 13:55:21 2006Errors in file /opt/oracle/admin/conner/bdump/conner_smon_17113.trc:ORA-00600: internal error code, arguments: [4194], [43], [46], [], [], [], [], []Sat Jan 21 13:55:21 2006Errors in file /opt/oracle/admin/conner/udump/conner_ora_17121.trc:ORA-00600: internal error code, arguments: [4194], [45], [44], [], [], [], [], []请问应该用什么办法解决？ |
答：具体的解决办法是通过备份来进行恢复，因为Ora-00600 4194错误的出现说明UNDO段出现了问题，如果你没有备份，业可以通过特殊的初始化参数进行强制启动，下文针对Oracle的隐含参数进行恢复说明（由于你的实际情况可能会有所出入，所以请你进行测试前先行备份）。
◆首先你需要确定当前的回滚段名称，注释：（可以从alert文件中获得）
Sat Jan 21 13:55:21 2006Undo Segment 11 OnlinedUndo Segment 12 OnlinedUndo Segment 13 OnlinedSuccessfully onlined Undo Tablespace 16 |
◆注意：对应的AUM （auto undo management） 下的回滚段名称为：
'_SYSSMU11$'，'_SYSSMU12$'，'_SYSSMU13$'
◆此时你可以修改init.ora参数文件，使用Oracle隐含参数_corrupted_rollback_segments将回滚段标记为损坏，然后启动数据库，Oracle则会跳过对于这些回滚段的相关操作，强制启动数据库。
。_corrupted_rollback_segments='_SYSSMU11$'，'_SYSSMU12$'，'_SYSSMU13$'
◆然后使用init.ora参数文件启动数据库：
[oracle@jumper dbs]$ sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.4.0 - Production on Sat Jan 21 13:56:47 2006Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to an idle instance.SQL> startup pfile=initconner.oraORACLE instance started.Total System Global Area 97588504 bytesFixed Size 451864 bytesVariable Size 33554432 bytesDatabase Buffers 62914560 bytesRedo Buffers 667648 bytesDatabase mounted.Database opened. |
至此数据库正常Open.
◆注意观察alert文件所获得的如下信息：
Sat Jan 21 13:57:03 2006SMON: enabling tx recoverySMON: about to recover undo segment 11SMON: mark undo segment 11 as needs recoverySMON: about to recover undo segment 12SMON: mark undo segment 12 as needs recoverySMON: about to recover undo segment 13SMON: mark undo segment 13 as needs recoverySat Jan 21 13:57:03 2006Database Characterset is ZHS16GBKSat Jan 21 13:57:03 2006SMON: about to recover undo segment 11SMON: mark undo segment 11 as needs recoverySMON: about to recover undo segment 12SMON: mark undo segment 12 as needs recoverySMON: about to recover undo segment 13SMON: mark undo segment 13 as needs recoverySat Jan 21 13:57:04 2006Created Undo Segment _SYSSMU1$Undo Segment 1 OnlinedCompleted: ALTER DATABASE OPENaSat Jan 21 14:02:11 2006SMON: about to recover undo segment 11SMON: mark undo segment 11 as needs recoverySMON: about to recover undo segment 12SMON: mark undo segment 12 as needs recoverySMON: about to recover undo segment 13SMON: mark undo segment 13 as needs recovery |
◆现在你可以重新创建新的UNDO表空间，删除出现问题的表空间，修改参数文件，由参数文件生成新的spfile，然后重新启动数据库：
SQL> create undo tablespace undotbs1 2 datafile '/opt/oracle/oradata/conner/undotbs1.dbf' size 10M;Tablespace created.SQL> alter system set undo_tablespace=undotbs1;System altered.SQL> drop tablespace undotbs2;Tablespace dropped. |
