• 【OGG 故障处理】OGG-01031


    故障原因
    --------------------
    网络异常,导致DP进程异常中断
     
    故障现象
    --------------------
    源端DP 进程全部挂起,且启动失败
    GGSCI 34> info all
    Program Status Group Lag at Chkpt Time Since Chkpt
    MANAGER RUNNING
    EXTRACT ABENDED DP_XXXX1 00:00:00 00:49:33
    EXTRACT ABENDED DP_XXXX2 00:00:00 00:49:40
    EXTRACT ABENDED DP_XXXX3 00:00:00 00:49:32
    EXTRACT ABENDED DP_XXXX4 00:00:00 00:49:37
    EXTRACT ABENDED DP_XXXX5 00:00:00 00:49:34
    EXTRACT RUNNING EX_XXXX1 00:00:01 00:00:09
    EXTRACT RUNNING EX_XXXX2 00:00:01 00:00:09
    EXTRACT RUNNING EX_XXXX3 00:00:01 00:00:00
    EXTRACT RUNNING EX_XXXX4 00:00:01 00:00:10
    EXTRACT RUNNING EX_XXXX5 00:00:01 00:00:00
     
    错误描述
    --------------------
    源端:
    GGSCI 34> view report dp_XXXX1
    2018-02-07 22:24:27 ERROR OGG-01031 There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable
    to open file "/ogg/dirdat/ra000128" (error 11, Resource temporarily unavailable)).
    2018-02-07 22:24:27 ERROR OGG-01668 PROCESS ABENDING.
     
    目标端
    [ogg@target ogg]$ tail -200 ggserr.log | grep WARNING
    2018-02-07 22:56:27 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to lock file "/ogg/dirdat/rb000075" (error 11, Resource temporarily unavailable). Lock currently held by process id (PID) 28854.
    2018-02-07 22:56:32 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to lock file "/ogg/dirdat/rc001573" (error 11, Resource temporarily unavailable). Lock currently held by process id (PID) 28915.
    2018-02-07 22:56:37 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to lock file "/ogg/dirdat/rd000476" (error 11, Resource temporarily unavailable). Lock currently held by process id (PID) 28926.
    2018-02-07 22:56:42 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to lock file "/ogg/dirdat/re000005" (error 11, Resource temporarily unavailable). Lock currently held by process id (PID) 28936.
     
    处理方案
    --------------------
    目标端:
    根据上面的目标端报错Lock currently held by process id (PID) 28854.
    kill -9 pid
     
    源端:
    启动DP 进程,完成恢复
  • 相关阅读:
    关于最近
    Cryptography Application Block
    关于修改SQL SERVER 登陆模式
    我与软件工程
    JAVA之路(一)
    C#基础:类的继承与多态
    简述java语言的特点
    简述java虚拟机的工作原理
    阿里云盾特点及防DDoS攻击服务介绍
    智能DNS
  • 原文地址:https://www.cnblogs.com/plluoye/p/10950958.html
Copyright © 2020-2023  润新知