ORA-00600: internal error code, arguments: [4193],

Sun Jul 18 21:47:20 2010
Errors in file /opt/oracle/admin/xxxdb/bdump/xxxdb_j000_4337.trc:
ORA-00600: internal error code, arguments: [4193], [362], [536], [], [], [], [], []
Sun Jul 18 21:47:23 2010
Doing block recovery for file 2 block 3163
Block recovery from logseq 3, block 75 to scn 1713017
Sun Jul 18 21:47:23 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: /opt/oracle/oradata/xxxdb/redo03.log
Block recovery completed at rba 3.78.16, scn 0.1713019
Doing block recovery for file 2 block 25
Block recovery from logseq 3, block 75 to scn 1713039
Sun Jul 18 21:47:23 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: /opt/oracle/oradata/xxxdb/redo03.log
Block recovery completed at rba 3.120.16, scn 0.1713040


SQL> shutdown immediate
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [362], [536], [], [], [],
[], []


Errors in file /opt/oracle/admin/xxxdb/udump/xxxdb_ora_4323.trc:
ORA-00600: internal error code, arguments: [4193], [362], [536], [], [], [], [], []
Sun Jul 18 21:49:22 2010
Doing block recovery for file 2 block 3163
Block recovery from logseq 3, block 150 to scn 1713102
Sun Jul 18 21:49:22 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: /opt/oracle/oradata/xxxdb/redo03.log
Block recovery stopped at EOT rba 3.151.16
Block recovery completed at rba 3.151.16, scn 0.1713101
Doing block recovery for file 2 block 25
Block recovery from logseq 3, block 150 to scn 1713100
Sun Jul 18 21:49:22 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: /opt/oracle/oradata/xxxdb/redo03.log
Block recovery completed at rba 3.151.16, scn 0.1713101
ORA-607 signalled during: ALTER DATABASE CLOSE NORMAL...



ORA-00600: internal error code, arguments: [4193], [362], [536], [], [], [], [], []

show parameter undo
create undo tablespace undotbs2     datafile '/opt/oracle/oradata/xxxdb/undotbs02.dbf' size 10m;
alter system set undo_tablespace=undotbs2 scope=both;
shutdown immediate;
select open_mode from v$database;
shutdown abort
startup
show parameter undo


SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS1
SQL> create undo tablespace undotbs2     datafile '/opt/oracle/oradata/xxxdb/undotbs02.dbf' size 10m;

Tablespace created.

SQL> alter system set undo_tablespace=undotbs2 scope=both;

System altered.

SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS2
SQL> shutdown immediate;
ORA-00450: background process 'EMN0' did not start
ORA-00443: background process "EMN0" did not start
SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1266392 bytes
Variable Size             138415400 bytes
Database Buffers           25165824 bytes
Redo Buffers                2924544 bytes
Database mounted.
Database opened.



ORA-00600：[4193]，[193]，[198]。
[193] Undo record seq number
[198] Undo record seq number
这两个值不一致造成的，是回滚段表空间有问题。


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.
   参考：  
 http://www.eygle.com/archives/2005/12/oracle_howto_deal_with_ora600_4137_error.html  
http://blog.csdn.net/inthirties/archive/2009/10/03/4630889.aspx

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/77164/viewspace-668382/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/77164/viewspace-668382/