CNDBA社区
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 stopped normally.
版权声明：本文为博主原创文章，未经博主允许不得转载。
oracle,linux
