ogg OGG-02422错误

1.在ogg源端执行命令同步数据时候,初始化数据一直无法完成,目标端ogg抛出如下错误。
GGSCI (node01) 1> start extinit

[oracle@node02:/ogg]$ tail -f ggserr.log
2021-09-29T08:55:13.431+0800  INFO    OGG-02695  Oracle GoldenGate Delivery for Oracle:  ANSI SQL parameter syntax is used for parameter parsing.
2021-09-29T08:55:13.442+0800  INFO    OGG-01360  Oracle GoldenGate Delivery for Oracle:  REPLICAT is running in Remote Task mode.
2021-09-29T08:55:13.489+0800  ERROR   OGG-02422  Oracle GoldenGate Delivery for Oracle:  Could not open checkpoint file /ogg/dirchk/REPINIT.cpr (error 2, No such file or directory).
2021-09-29T08:55:18.491+0800  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle:  PROCESS ABENDING.

2.分析

从目标端的错误信息来看,很明显是文件或者路径不存在。在mgr 配置里,如果有 usecheckpoint , 那么replicate 一定要可以生成cpr文件(检查点文件),文件名规则为 replicate_name.cpr。

解决
在目标端

[oracle@node02:/]$ cd /ogg/dirchk
[oracle@node02:/ogg/dirchk]$ cp REPINST.cpr REPINIT.cpr

如果dirchk目录下有其他的检查点文件, 根据命名规则复制一个新文件,即可解决。 或者重新添加replication 进程:

add replication repinit,specialrun

再次在源端启动ogg

2021-09-29T09:03:43.114+0800  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from EXTRACT on host [10.32.88.151]:60066 (START REPLICAT repinit CPU -1 PRI -1 PARAMS ).
2021-09-29T09:03:43.114+0800  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #1).
2021-09-29T09:03:43.175+0800  INFO    OGG-01888  Oracle GoldenGate Delivery for Oracle:  TCP network is configured as

                                                OS DEFAULT          SPECIFIED           ACTUAL VALUE        
                                       IP_DSCP    0                   N/A                 0                 
                                        IP_TOS    0                   N/A                 0                 
                                   TCP_NODELAY    0                   N/A                 0                 
                                  TCP_QUICKACK    1                   N/A                 1                 
                                      TCP_CORK    0                   N/A                 0                 
                                     SO_SNDBUF    8192                N/A                 8192              
                                     SO_RCVBUF    43690               N/A                 43690.
2021-09-29T09:03:43.208+0800  INFO    OGG-01025  Oracle GoldenGate Delivery for Oracle:  REPLICAT task started by manager (port 7820).
2021-09-29T09:03:43.194+0800  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from RMTTASK on host [::1]:14710 (REPORT 5137 7820).
2021-09-29T09:03:43.194+0800  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #1).
2021-09-29T09:03:43.194+0800  INFO    OGG-00973  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started replicat task process (Port 7820).
2021-09-29T09:03:48.250+0800  INFO    OGG-01229  Oracle GoldenGate Delivery for Oracle:  Connected to ::ffff:10.32.88.151:41145.
2021-09-29T09:03:48.261+0800  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle:  REPLICAT repinit starting.
2021-09-29T09:03:48.261+0800  INFO    OGG-03059  Oracle GoldenGate Delivery for Oracle:  Operating system character set identified as UTF-8.
2021-09-29T09:03:48.261+0800  INFO    OGG-02695  Oracle GoldenGate Delivery for Oracle:  ANSI SQL parameter syntax is used for parameter parsing.
2021-09-29T09:03:48.273+0800  INFO    OGG-01360  Oracle GoldenGate Delivery for Oracle:  REPLICAT is running in Remote Task mode.
2021-09-29T09:03:48.599+0800  INFO    OGG-06451  Oracle GoldenGate Delivery for Oracle:  Triggers will be suppressed by default.
2021-09-29T09:03:48.603+0800  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle:  Virtual Memory Facilities for: COM
                                  anon alloc: mmap(MAP_ANON)  anon free: munmap
                                  file alloc: mmap(MAP_SHARED)  file free: munmap
                                  target directories:
                                  /ogg/dirtmp.
2021-09-29T09:03:48.606+0800  INFO    OGG-25340  Oracle GoldenGate Delivery for Oracle:  
                              Database Version:
                              Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production.
2021-09-29T09:03:48.608+0800  INFO    OGG-25341  Oracle GoldenGate Delivery for Oracle:  
                              Database Language and Character Set:
                              NLS_LANGUAGE     = "AMERICAN" 
                              NLS_TERRITORY    = "AMERICA" 
                              NLS_CHARACTERSET = "AL32UTF8".
2021-09-29T09:03:48.608+0800  INFO    OGG-06604  Oracle GoldenGate Delivery for Oracle:  Database CXMTDB CPU info: CPU Count 8, CPU Core Count 8, CPU Socket Count 2.
2021-09-29T09:03:48.618+0800  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle:  REPLICAT repinit started.
2021-09-29T09:03:48.764+0800  INFO    OGG-06506  Oracle GoldenGate Delivery for Oracle:  Wildcard MAP resolved (entry hbhe.*): MAP "HBHE"."t1",target hbhe."t1".
2021-09-29T09:03:49.851+0800  INFO    OGG-02756  Oracle GoldenGate Delivery for Oracle:  The definition for table t1 is obtained from the trail file.
2021-09-29T09:03:49.851+0800  INFO    OGG-06511  Oracle GoldenGate Delivery for Oracle:  Using following columns in default map by name: LOT_ID, MAINPD_ID, OPE_NO, LCRECIPE_ID, ASSIGNED_EQP_ID, ASSIGNED_RECIPE_ID, ASSIGNED_PROCRSC_LST, ASSIGNED_RETICLE_ID, FCST_ARRIVAL_TIME, STEP_SEQ_NO, PRE_FORM_ID, UPDATE_TIME, INSERT_TIME.
2021-09-29T09:03:49.851+0800  INFO    OGG-06510  Oracle GoldenGate Delivery for Oracle:  Using the following key columns for target table HBHE.t1: LOT_ID, MAINPD_ID, OPE_NO, INSERT_TIME.
2021-09-29T09:03:49.979+0800  INFO    OGG-06506  Oracle GoldenGate Delivery for Oracle:  Wildcard MAP resolved (entry hbhe.*): MAP "HBHE"."HBHE",target hbhe."HBHE".
2021-09-29T09:03:50.053+0800  WARNING OGG-06439  Oracle GoldenGate Delivery for Oracle:  No unique key is defined for table HBHE. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2021-09-29T09:03:50.053+0800  INFO    OGG-02756  Oracle GoldenGate Delivery for Oracle:  The definition for table HBHE.HBHE is obtained from the trail file.
2021-09-29T09:03:50.053+0800  INFO    OGG-06511  Oracle GoldenGate Delivery for Oracle:  Using following columns in default map by name: ID.
2021-09-29T09:03:50.053+0800  INFO    OGG-06510  Oracle GoldenGate Delivery for Oracle:  Using the following key columns for target table HBHE.HBHE: ID.
2021-09-29T09:03:50.053+0800  INFO    OGG-06506  Oracle GoldenGate Delivery for Oracle:  Wildcard MAP resolved (entry hbhe.*): MAP "HBHE"."TEST",target hbhe."TEST".
2021-09-29T09:03:50.159+0800  WARNING OGG-06439  Oracle GoldenGate Delivery for Oracle:  No unique key is defined for table TEST. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2021-09-29T09:03:50.159+0800  INFO    OGG-02756  Oracle GoldenGate Delivery for Oracle:  The definition for table HBHE.TEST is obtained from the trail file.
2021-09-29T09:03:50.159+0800  INFO    OGG-06511  Oracle GoldenGate Delivery for Oracle:  Using following columns in default map by name: ID.
2021-09-29T09:03:50.159+0800  INFO    OGG-06510  Oracle GoldenGate Delivery for Oracle:  Using the following key columns for target table HBHE.TEST: ID.
2021-09-29T09:03:55.164+0800  INFO    OGG-00994  Oracle GoldenGate Delivery for Oracle:  REPLICAT repinit sto
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值