oracle select ora-16000,oracle DG库 使用with temp as()查询报ORA-00604、ORA-16000问题

Tue Nov 06 17:37:44 2018

Errors in file e:\app\administrator\diag\rdbms\jxnetorclst\jxnetorclst\trace\jxnetorclst_ora_2864.trc:

ORA-00604: error occurred at recursive SQL level 2

ORA-16000: database open for read-only access

Tue Nov 06 17:38:06 2018

Errors in file e:\app\administrator\diag\rdbms\jxnetorclst\jxnetorclst\trace\jxnetorclst_ora_2864.trc:

ORA-00604: error occurred at recursive SQL level 2

ORA-16000: database open for read-only access

Tue Nov 06 17:38:20 2018

Errors in file e:\app\administrator\diag\rdbms\jxnetorclst\jxnetorclst\trace\jxnetorclst_ora_2864.trc:

ORA-00604: error occurred at recursive SQL level 2

ORA-16000: database open for read-only access

Tue Nov 06 17:38:36 2018

Errors in file e:\app\administrator\diag\rdbms\jxnetorclst\jxnetorclst\trace\jxnetorclst_ora_816.trc:

ORA-00604: 递归 SQL 级别 2 出现错误

ORA-16000: 打开数据库以进行只读访问

Errors in file e:\app\administrator\diag\rdbms\jxnetorclst\jxnetorclst\trace\jxnetorclst_ora_816.trc:

ORA-00604: 递归 SQL 级别 2 出现错误

ORA-16000: 打开数据库以进行只读访问

Tue Nov 06 17:40:14 2018

Errors in file e:\app\administrator\diag\rdbms\jxnetorclst\jxnetorclst\trace\jxnetorclst_ora_1440.trc:

ORA-00604: error occurred at recursive SQL level 2

ORA-16000: database open for read-only access

今天开发同事联系说报表库查询不出数据了(报表库是在放在dg上)，发现生产环境报了如上一堆错误，检查SQL语句都是含有with XXX as ()，SQL没有别的DML及DDL语句，奇怪，手动写一条with tmp as()的语句，也会报这个错误。那问题就是with tmp as这条sql上了。

赶紧上网查查，https://blog.csdn.net/lihao2372/article/details/6445039

发现这边文章说with temp as查询会被认为是ddl语句的，把原SQL放到主库执行，再到备库执行，没问题了？？

这个不是10G的一个BUG吗？我的数据库是11.2.0.3，为什么还是会有这个问题？

第二天再到备库测试，之前报错的SQL再执行或者自己写一条完全不一样的依然没有问题？

难道这个BUG在11G还没修复？