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


    数据库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

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

  • 相关阅读:
    关于平衡树的一些总结
    bzoj3065 带插入区间K小值
    bzoj2560 串珠子
    bzoj3224 Tyvj 1728 普通平衡树
    bzoj1031 [JSOI2007]字符加密Cipher
    bzoj4571 [Scoi2016]美味
    集合框架—常见的Set集合
    集合框架—两种迭代机制
    集合框架—基础
    网络编程—代码—UDP数据报传输
  • 原文地址:https://www.cnblogs.com/likingzi/p/13884989.html
Copyright © 2020-2023  润新知