如何处理 Ora-600 4193 错误

核心提示：在解决2662错误之后，经常会出现Ora-00600 4193错误，如何处理 Ora-600 4193 错误，经常可以在alert文件中看到的错误号类似:Fri Dec 16 22:37:27 2005Errors in file /opt/oracle/admin/conner/bdump/conner_smon_2

在解决2662错误之后，经常会出现Ora-00600 4193错误，经常可以在alert文件中看到的错误号类似:

Fri Dec 16 22:37:27 2005
Errors in file /opt/oracle/admin/conner/bdump/conner_smon_22817.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [1171], [1187], [], [], [], [], []
Fri Dec 16 23:28:40 2005
Errors in file /opt/oracle/admin/conner/bdump/conner_smon_22817.trc:
ORA-00600: internal error code, arguments: [4193], [1171], [1187], [], [], [], [], []

4193错误通常是因为恢复时redo与undo不一致所导致。

Oracle的解释如下:

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.

检查具体的Trace文件，可以发现类似如下错误：

*** 2005-12-16 20:54:53.496
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4193], [1171], [1187], [], [], [], [], []
Current SQL statement for this session:
UPDATE SMON_SCN_TIME SET SCN_WRP=:1, SCN_BAS=:2, TIME_MP=:3, TIME_DP=:4
WHERE TIME_MP = :5　AND　 THREAD = :6　AND　 ROWNUM <= 1

由于是UNDO存在不一致，可以通过重建UNDO表空间来解决:

SQL> create undo tablespace undotbs2
　 2 datafile '/opt/oracle/oradata/conner/undotbs2.dbf' size 10m;
Tablespace created.
SQL> alter system set undo_tablespace=undotbs2 scope=both;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area　114365800 bytes
Fixed Size　　　　　　　　　 451944 bytes
Variable Size　　　　　　　50331648 bytes
Database Buffers　　　　　 62914560 bytes
Redo Buffers　　　　　　　　 667648 bytes
Database mounted.
Database opened.
SQL> show parameter undo
NAME　　　　　　　　　　　　　　　　 TYPE　　　　VALUE
------------------------------------ ----------- ------------------------------
undo_management　　　　　　　　　　　string　　　AUTO
undo_retention　　　　　　　　　　　 integer　　 10800
undo_suppress_errors　　　　　　　　 boolean　　 FALSE
undo_tablespace　　　　　　　　　　　string　　　UNDOTBS2
SQL> drop tablespace undotbs1 including contents and datafiles;
Tablespace dropped.

至此，Ora-600 4193错误不再出现。

从alert文件中，可以看到Oracle9i.New.Feature.Spfile.04.htm">自动控制文件备份生效：

Sun Dec 18 22:37:59 2005
drop tablespace undotbs1 including contents and datafiles
Sun Dec 18 22:37:59 2005
Deleted file /opt/oracle/oradata/conner/undotbs01.dbf
Starting control autobackup
Control autobackup written to DISK device
　　　　handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20051218-01'
Completed: drop tablespace undotbs1 including contents and da