重庆思庄Oracle、Redhat认证学习论坛

标题: DG备库报警文件中出现ORA-00600: internal error code, arguments: [2730] [打印本页]

作者: 郑全 时间: 2020-12-4 00:20
标题: DG备库报警文件中出现ORA-00600: internal error code, arguments: [2730]
1.问题现象：

ORACLE 11.2.0.4 DG切换后，发现主库报归档错误，
检查 dest_id=2 的信息：

SQL> select dest_name,status,error from v$archive_dest where dest_id=2;
DEST_NAME
--------------------------------------------------------------------------------
STATUS ERROR
--------- -----------------------------------------------------------------
LOG_ARCHIVE_DEST_2
ERROR    ORA-16099: internal error ORA-00600 occurred at standby database

备库报警文件中报：
Errors in file D:\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_rfs_6304.trc  (incident=1222):
ORA-00600: internal error code, arguments: [2730], [331], [1], [5], [75809], [75809], [512], [512], [], [], [], []

具体的文件：
*** 2020-12-03 21:33:33.911
*** SESSION ID:(12.37) 2020-12-03 21:33:33.911
*** CLIENT ID:() 2020-12-03 21:33:33.911
*** SERVICE NAME:(orcl) 2020-12-03 21:33:33.911
*** MODULE NAME:(oracle@ydhldbsvr (TNS V1-V3)) 2020-12-03 21:33:33.911
*** ACTION NAME:() 2020-12-03 21:33:33.911

Redo Shipping Client Established Network Login
Redo Shipping Client Established Network Login
Identified standby redo log 6 for implicit mid-log reconnect
Redo Shipping Client Established Network Login
DDE: Problem Key 'ORA 600 [2730]' was flood controlled (0x2) (incident: 302233)
ORA-00600: internal error code, arguments: [2730], [331], [1], [6], [75810], [75810], [512], [512], [], [], [], []
Exception 600 received while writing lno 6 thread 1 seq 75810
*** 2020-12-03 21:33:34.099 4639 krsb.c
krsb_stream_write: Error 600 while attempting to write buffer
Redo Shipping Client Established Network Login
krsv_dsga: Dispatching RFS shutdown notification

2.问题原因为：
  主备库兼容参数不一致导致的，主库是新安装的，备库是通过11.2.0.3升级上来的：

SQL> show parameter compatible
NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
compatible                         string    11.2.0.0.0

SQL> show parameter compatible
NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
compatible                         string    11.2.0.4.0

解决办法：
把备库兼容参数修改为和主库一致，即可解决。

作者: 郑全 时间: 2020-12-4 00:24
该问题，可以参见MOS:Doc ID 602015.1

ORA-00600: [2730], [331] after Switchover in New Standby Database (Doc ID 602015.1)
In this Document
Symptoms
Cause
Solution
References
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.1.0.6 [Release 10.1 to 11.1]
Information in this document applies to any platform.
This problem can occur on any platform.

SYMPTOMS
Alert.log
========
Errors in file /<PATH>/<FILE_NAME>.trc:
ORA-00600: internal error code, arguments: [2730], [331], [2], [25], [102132], [102132], [], []
Functions in Call stack
========
kgeriv kgesiv ksesic5 kcrfwh kcrr_write_redo_header
CAUSE
Unmatched compatibility setup on the primary and the standby.
Value of compatible parameter in primary and standby is different.
SOLUTION
1. Change the value of the compatible parameter on standby

SQL> ALTER SYSTEM SET COMPATIBLE= <same as value of primary> SCOPE=SPFILE;

If you are using pfile then edit pfile and change the value of the parameter
*. COMPATIBLE= <same as value of primary>
2. Shutdown and Restart the standby database in mount stage
3. Restart Managed recovery process.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)