一次Ora-600 4193的解决-优快云博客

本文介绍了如何解决Oracle数据库中出现的ORA-600[4137]错误，该错误通常由于undo与redo不一致引起。解决方案包括通过重建undo表空间来解决此问题。

参考：
http://www.eygle.com/archives/2005/12/oracle_howto_deal_with_ora600_4137_error.html
和
Bug 8240762 - Undo corruptions with ORA-600 [4193]/ORA-600 [4194] or ORA-600 [4137] after SHRINK [ID 8240762.8]

Thu Mar 11 18:34:21 2010


Errors in file /oracle/admin/williamdb/bdump/williamdb_smon_30388.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [396], [399], [], [], [], [], []

原因：
undo与redo不一致

解决方法：
重建undo


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  285212672 bytes
Fixed Size                  1261348 bytes
Variable Size             130023644 bytes
Database Buffers          146800640 bytes
Redo Buffers                7127040 bytes
Database mounted.
Database opened.
SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS2

SQL> drop tablespace undotbs1 including contents and datafiles;

Tablespace dropped.

SQL>

看看alertlog：


Deleted file /oracle/data/williamd/undotbs01.dbf
Starting control autobackup
Control autobackup written to DISK device
        handle '/oracle/product/10.2.0/dbs/oraclebackupc-3047744130-20100311-01'
Completed: drop tablespace undotbs1 including contents and datafiles

另外注意的是，如果经常出现这种情况，应该检查硬盘