触发器引起的ADG备库同步错误
数据库alert日志报错ORA-16000,查看对应的trc文件,大致如下报错:
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<strong><em> 2020-10-27 14:09:03.340 </em></strong> SESSION ID:(3340.75) 2020-10-27 14:09:03.340 <strong><em> CLIENT ID:() 2020-10-27 14:09:03.340 </em></strong> SERVICE NAME:(SYS$USERS) 2020-10-27 14:09:03.340 <strong><em> MODULE NAME:(rman@jkadg (TNS V1-V3)) 2020-10-27 14:09:03.340 </em></strong> ACTION NAME:() 2020-10-27 14:09:03.340</p> <p>Error in executing triggers on connect internal *** 2020-10-27 14:09:03.340 dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0) ----- Error Stack Dump ----- ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access ORA-06512: at line 2 |
或者
[crayon-6006950da8f38146[……]