[ORA-00600 [4194], [30], [24 整理

故障如下:

Mon Oct 22 19:49:27 2012

Trace dumping is performing id=[cdmp_20121022194927]

Errors in file /u01/oracle/diag/rdbms/tj/tj/trace/tj_cjq0_4048.trc  (incident=120235):

ORA-00600: internal error code, arguments: [600], [ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

], [], [], [], [], [], [], [], [], [], []

Incident details in: /u01/oracle/diag/rdbms/tj/tj/incident/incdir_120235/tj_cjq0_4048_i120235.trc

Errors in file /u01/oracle/diag/rdbms/tj/tj/trace/tj_m003_4038.trc  (incident=120223):

ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

ORA-06512: at "SYS.PRVT_ADVISOR", line 6007

ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

ORA-06512: at line 1

Flush retried for xcb 0xbed31658, pmd 0xbb0f4380

Doing block recovery for file 3 block 550

Resuming block recovery (PMON) for file 3 block 550

Block recovery from logseq 96, block 63 to scn 3945468

Recovery of Online Redo Log: Thread 1 Group 3 Seq 96 Reading mem 0

  Mem# 0: /u01/oracle/oradata/tj/redo03.log

Block recovery completed at rba 96.68.16, scn 0.3945474

Errors in file /u01/oracle/diag/rdbms/tj/tj/trace/tj_m003_4038.trc  (incident=120224):

ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

ORA-06512: at "SYS.PRVT_ADVISOR", line 6007

ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

ORA-06512: at line 1

opidrv aborting process M003 ospid (4038_46936976460992) due to error ORA-600

Flush retried for xcb 0xbed31658, pmd 0xbb0f4380

Doing block recovery for file 3 block 550

Resuming block recovery (PMON) for file 3 block 550

Block recovery from logseq 96, block 63 to scn 3945468

Recovery of Online Redo Log: Thread 1 Group 3 Seq 96 Reading mem 0

  Mem# 0: /u01/oracle/oradata/tj/redo03.log

Block recovery completed at rba 96.68.16, scn 0.3945474

Errors in file /u01/oracle/diag/rdbms/tj/tj/trace/tj_cjq0_4048.trc  (incident=120236):

ORA-00600: internal error code, arguments: [4194], [31], [26], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [600], [ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

], [], [], [], [], [], [], [], [], [], []

Errors in file /u01/oracle/diag/rdbms/tj/tj/trace/tj_pmon_3950.trc  (incident=120050):

ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

Errors in file /u01/oracle/diag/rdbms/tj/tj/trace/tj_pmon_3950.trc:

ORA-00600: internal error code, arguments: [4194], [30], [24], [], [], [], [], [], [], [], [], []

PMON (ospid: 3950): terminating the instance due to error 472

Instance terminated by PMON, pid = 3950

处理方法如下：

因为ORA-600[4194]错误导致数据库无法打开，设置以下事件:

 

select FILE#,name from v$datafile; --查出是那个文件出问题了，日志得出是undo datafile 出问题。

 

SQL> alter system set event='10513 trace name context forever,level 2 : 10512 trace name context forever,level 1: 10511 trace name context forever,level 2: 10510 trace name context forever,level 1' scope=spfile;

System altered.

/* 10513事件用以阻止SMON在启动数据库后执行事务恢复(transaction recovery) */

/

/* 10512事件用以阻止SMON shrink rollback segment */

/

/* 10511事件用以阻止SMON check to cleanup undo dictionary */

/

/* 10500事件用以阻止SMON check to offline pending offline rollback segment */

SQL> alter system set undo_management=MANUAL scope=spfile;

System altered.

SQL> shutdown immediate;

ORA-03113: end-of-file on communication channel

SQL> startup mount;

ORACLE instance started.

Total System Global Area 2634022912 bytes

Fixed Size                  2086288 bytes

Variable Size            2382367344 bytes

Database Buffers          234881024 bytes

Redo Buffers               14688256 bytes

Database mounted.

SQL> alter database open;

Database altered.

SQL>alter  tablespace undotbs02 add datafile

'/u01/oracle/oradata/tj/undotbs02_1.dbf' size 1G;

 

SQL> alter system set undo_management=AUTO scope=spfile;

 

System altered.

SQL>  alter system set undo_tablespace=undotbs02 scope=spfile;

 

System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 2634022912 bytes
Fixed Size                  2086288 bytes

Variable Size            2382367344 bytes

Database Buffers          234881024 bytesR
Redo Buffers               14688256 bytes

Database mounted.
SQL> alter database open;
Database altered.

补充：
在metalink看到这错误是个bug,需要打13343461 可以修复！
Bug 13343461  11.1.0.7.10 Patch Set Update (PSU)
This note gives a brief overview of Patch:13343461
The content was last updated on: 17-APR-2012
Click here for details of each of the sections below.

Affects:
Product (Component)        Oracle Server (Critical Patch Update)
Version/s this patch is for        ?        11.1.0.7

Platforms affected        Generic (all / most platforms affected)

Note that this fix has been superceded by the fix in Bug:13621679
Symptoms:        Related To:
?        (None Specified)        ?        (None Specified)
Description
This is a marker bug for the 11.1.0.7.10 Patch Set Update (PSU).
This Patch Set Update can be downloaded here: Patch:13343461

For information about Patch Set Updates please read Note:854428.1 .

This Patch Set Update includes:

- All the fixes from the 11.1.0.7.9 Patch Set Update (Bug 12827740)

- Plus all fixes which are included in the Critical Patch Update for
   January 2012 (CPUJan2012) - for details see Note:1374524.1

- Plus a number of other fixes (listed below)

For a cumulative list of fixes in the latest 11.1.0.7 PSU see Note:1337836.1

Known Issues
See Note:1374729.1 for details of Known Issues with this Patch Set Update

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

转载于:http://blog.itpub.net/25448460/viewspace-747336/