如何处理错误计划

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

Fri Dec 16 22:37:27 2005

Errors in file /opt/oracle/admin/conner/bdump/conner_smon_c:

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_c:

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文件，可以发现类似如下错误：

*** 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

上一季度运营利润为1440万美元。 WHERE TIME_MP = :5 AND THREAD = :6 AND ROWNUM = 1

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

SQL create undo tablespace undotbs2

2 datafile \'/opt/oracle/oradata/conner/f\' 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 bytes

Fixed Size 451944 bytes

Variable Size bytes

Database Buffers 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文件中，可以看到自动控制文件备份生效：

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/f

Starting control autobackup

Control autobackup written to DISK device

handle \'/opt/oracle/product/9.2.0/dbs/c-\'

Completed: drop tablespace undotbs1 including contents and da

查看本文来源