故障如下:
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.
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.
在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/296377/viewspace-747756/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/296377/viewspace-747756/