触发器引起的ADG备库同步错误

2020年10月27日 600点热度 0人点赞 0条评论

数据库alert日志报错ORA-16000,查看对应的trc文件,大致如下报错:

 2020-10-27 14:09:03.340
 SESSION ID:(3340.75) 2020-10-27 14:09:03.340
 CLIENT ID:() 2020-10-27 14:09:03.340
 SERVICE NAME:(SYS$USERS) 2020-10-27 14:09:03.340
 MODULE NAME:(rman@jkadg (TNS V1-V3)) 2020-10-27 14:09:03.340
 ACTION NAME:() 2020-10-27 14:09:03.340

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

或者

*** 2020-10-27 14:17:36.669
*** SESSION ID:(3196.279) 2020-10-27 14:17:36.669
*** CLIENT ID:() 2020-10-27 14:17:36.669
*** SERVICE NAME:() 2020-10-27 14:17:36.669
*** MODULE NAME:(plsqldev.exe) 2020-10-27 14:17:36.669
*** ACTION NAME:() 2020-10-27 14:17:36.669

Skipped error 604 during the execution of RMW_INSPUR_ZONGZI.LOGON_TRIGGER

*** 2020-10-27 14:17:36.669
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)
----- Error Stack Dump -----
ORA-00604: µÝ¹é SQL ¼¶±ð 1 ³öÏÖ´íÎó
ORA-16000: ´ò¿ªÊý¾Ý¿âÒÔ½øÐÐÖ»¶Á·ÃÎÊ
ORA-06512: ÔÚ line 2

可见最终的错误线索均指向了备库连接时或登录触发器动作时,将主库的登录或连接触发器关闭,再次打开备库同步成功。

liking

我是雪人

文章评论