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


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

郑全

该问题，可以参见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.