数据库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 |
或者
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
*** 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 |
可见最终的错误线索均指向了备库连接时或登录触发器动作时,将主库的登录或连接触发器关闭,再次打开备库同步成功。