ORA-00600 [1880]

本文主要是介绍ORA-00600 [1880]，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

-----环境信息
[oracle@trsen02 bdump]$ uname -a
Linux trsen02.yto.com 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

SQL> select * from registry$history;
no rows selected

双节点RAC ，

--日志信息
2节点一直报如下错误
Errors in file /opt/app/oracle/admin/trsendb/bdump/trsendb2_arc0_19489.trc:
ORA-00600: internal error code, arguments: [1880], [0x00B60A258], [0x00B609EE8], [1], [0], [], [], []
Fri Oct 17 15:07:29 CST 2014
Errors in file /opt/app/oracle/admin/trsendb/bdump/trsendb2_arc0_19489.trc:
ORA-00600: internal error code, arguments: [1880], [0x00B60A258], [0x00B609EE8], [1], [0], [], [], []
Fri Oct 17 15:07:29 CST 2014
Errors in file /opt/app/oracle/admin/trsendb/bdump/trsendb2_arc0_19489.trc:
ORA-00600: internal error code, arguments: [1880], [0x00B60A258], [0x00B609EE8], [1], [0], [], [], []
Fri Oct 17 15:07:31 CST 2014
ARCH: Detected ARCH process failure
ARCH: STARTING ARCH PROCESSES
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0 started with pid=50, OS id=19533
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Fri Oct 17 15:07:34 CST 2014
Errors in file /opt/app/oracle/admin/trsendb/bdump/trsendb2_arc0_19533.trc:
ORA-00600: internal error code, arguments: [1880], [0x01E99E258], [0x01E99DEE8], [1], [0], [], [], []
Fri Oct 17 15:07:35 CST 2014

1节点
ri Oct 17 15:08:27 CST 2014
Trace dumping is performing id=[cdmp_20141017151006]
Fri Oct 17 15:08:31 CST 2014
Trace dumping is performing id=[cdmp_20141017151012]
Fri Oct 17 15:08:34 CST 2014
Trace dumping is performing id=[cdmp_20141017151013]
Fri Oct 17 15:08:37 CST 2014
Trace dumping is performing id=[cdmp_20141017151018]
Fri Oct 17 15:10:26 CST 2014
Trace dumping is performing id=[cdmp_20141017151206]
Fri Oct 17 15:10:32 CST 2014
Trace dumping is performing id=[cdmp_20141017151213]
Fri Oct 17 15:10:38 CST 2014
Trace dumping is performing id=[cdmp_20141017151219]
Fri Oct 17 15:10:44 CST 2014
Trace dumping is performing id=[cdmp_20141017151225]
Fri Oct 17 15:10:50 CST 2014
Trace dumping is performing id=[cdmp_20141017151230]
Fri Oct 17 15:12:27 CST 2014
Trace dumping is performing id=[cdmp_20141017151408]
Fri Oct 17 15:12:33 CST 2014
Trace dumping is performing id=[cdmp_20141017151414]
Fri Oct 17 15:12:39 CST 2014
Trace dumping is performing id=[cdmp_20141017151420]
Fri Oct 17 15:12:45 CST 2014
Trace dumping is performing id=[cdmp_20141017151426]
Fri Oct 17 15:12:51 CST 2014
Trace dumping is performing id=[cdmp_20141017151432]
Fri Oct 17 15:13:48 CST 2014
Thread 1 advanced to log sequence 109008 (LGWR switch)
  Current log# 4 seq# 109008 mem# 0: +DATADG/trsendb/redo04.l

--trc内容及其堆栈调用
ORA-00600: internal error code, arguments: [1880], [0x00B60A258], [0x00B609EE8], [1], [0], [], [], []
ksedst,ksedmp,ksfdmp,geriv,kgesiv,ksesic4,ksfqwat,kcrrulf,kcrrcda,kcrrmar,kcrrdmx,kcrrdim,kcrrwkx,kcrrwk,ksbabs,ksbrdp,opirip,opidrv,sou2o,opimai_real,main,__libc_start_main,_start


Bug 4541506 : RMAN: ORA-600 [1880] [0X8..] [0X8...] [1] [0] DOING "BACKUP AS COPY" W/ MAXPC
RELATED BUGS:
-------------
Bug 4460877 : same Oracleversion and platform
STACK TRACE:
------------
ksedmp ksfdmp kgeriv kgesiv ksesic4 ksfqwat
ksfqfcls krbbCloseOutput krbbpc krbibpc pevm_icd_call_commo pfrinstr_ICAL
pfrrun_no_tool pfrrun plsql_run pricar pricbr prient2
prient kkxrpc kporpc opiodr ttcpip opitsk
opiino opiodr opidrv sou2o main

Bug 5680787 : ARCHIVE COMPRESSION CAUSES ORA-00600[1880]
-> Db version: 10.2.0.2
-> Status: 92 - Closed, Not a Bug
They indeed used 'alter database archivelog compress enable;'.
They got to know of this feature by a presentation on Oracle new features the beginning of this year.
This presentation is not official documentation and was given by an Oracle partner, not Oracle.

Bug 3204794 : ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [1880], [0X104754578], [0X1047543C0],
-> Db version: 10.1.0.1
-> 35 - To Filer for Review
This problem is releated to archival compression and is fixed in BETA2.
Note: The archival compression feature will *not* ship in the 10g release.  
Workaround: To disable archival compression use the following - ALTER DATABASE ARCHIVELOG COMPRESS DISABLE

    
Bug 17589158 : PRODUCT ENHANCEMENT REQUEST FOR COMPRESSING ARCHIVE LOGS
-> Db version: 11.2.0.3
-> Status: 15 - Enhancement Req. Internal (Oracle) Review


--之前开启了归档日志压缩功能    
SQL> select archivelog_compression from v$database ;

ARCHIVEL
--------
ENABLED

--此ORA-600错误非bug导致，而是10gr2版本不支持压缩功能，虽然可以开启使用，当时没有报错
ALTER DATABASE ARCHIVELOG COMPRESS DISABLE;
采用此语句关闭此功能，数据库恢复正常

总结:这类问题的报错一般是日志问题

这篇关于ORA-00600 [1880]的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---