【Bug】Spurious ORA-1555 in RAC Active Dataguard(ADG)

在搭建好的11.2.0.3的ADG(Active DataGuard)中,standby端的alert日志中

总是不定期出现同一个sql id的sql语句报ora-1555的错误,经确认,发现是bug,简单做下记录。

Affects:

Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected (Not specified)
Versions confirmed as being affected
Platforms affected Generic (all / most platforms affected)

Fixed:

The fix for 13814252 is first included in
Description
This bug is only relevant when using RAC (Real Application Clusters) / OPS and Active Dataguard (ADG)
 
Spurious ORA-1555 errors may be seen in RAC Active Dataguard
 

解决方法
           文档中并没有给出workaround的方法,既然在11.2.0.4或者更高的版本已经修复了该bug。也就是可以升级到11.2.0.4 来解决
           这个问题。因为这个ora-1555是spurious(虚假的),这里我选择了忽略该错误。

参考
Bug 13814252 - Spurious ORA-1555 in RAC Active Dataguard (文档 ID 13814252.8)

请使用浏览器的分享功能分享到微信等