转 OGG 部署阶段常见问题

序号 问题 解决方案
1 "2019-04-13 20:23:55 ERROR OGG-00868 Oracle GoldenGate Capture for Oracle, e_db1.prm: The number of Oracle redo threads (2) is not the same as the number of checkpoint threads (1). EXTRACT groups on RAC systems should be created with the THREADS parameter (e.g., ADD EXT <group name>, TRANLOG, THREADS 2, BEGIN...).
2019-04-13 20:23:55 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, e_db1.prm: PROCESS ABENDING.
2019-04-13 20:23:57 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (opdb1):

 

info all." "e进程的参数需要新增theads 2

原因：

add extract e_db1, tranlog,threads 2, begin now"

 

2 "2019-04-14 11:01:17 INFO OGG-01677 Oracle GoldenGate Collector: Waiting for connection (started dynamically).
2019-04-14 11:01:17 INFO OGG-01228 Oracle GoldenGate Collector: Timeout in 300 seconds.
2019-04-14 11:01:17 INFO OGG-01677 Oracle GoldenGate Collector: Waiting for connection (started dynamically).
2019-04-14 11:01:17 INFO OGG-01228 Oracle GoldenGate Collector: Timeout in 300 seconds."

原因：

忽略，会自动重启

 

3 "2019-04-14 11:01:04 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, d_card.prm: Output file ./dirdat/dp is using format RELEASE 10.4/11.1.
2019-04-14 11:01:04 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, d_card.prm: Rolling over remote file ./dirdat/dp000001.
2019-04-14 11:01:04 INFO OGG-01053 Oracle GoldenGate Capture for Oracle, d_card.prm: Recovery completed for target file ./dirdat/dp000001, at RBA 459.
2019-04-14 11:01:04 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, d_card.prm: Recovery completed for all targets.
2019-04-14 11:01:04 ERROR OGG-02171 Oracle GoldenGate Capture for Oracle, d_card.prm: Error reading LCR from data source. Status 500, data source type 0.
2019-04-14 11:01:04 ERROR OGG-01091 Oracle GoldenGate Capture for Oracle, d_card.prm: Unable to open file ""./dirdat/lt000000032"" (error 2, No such file or directory).
2019-04-14 11:01:04 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, d_card.prm: PROCESS ABENDING.
2019-04-14 11:01:04 WARNING OGG-06600 Oracle GoldenGate Capture for Oracle, d_symb.prm: The remote peer for remote trail ./dirdat/dr does not support 9 digit seqlen feature. Continuing with 6 digit se"

 

原因：

删除d进程，重新添加d进程

 

4 "2019-04-14 12:22:11 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, r_card.prm: Failed to retrieve column list handle for table CARD.CBSD_SOCKET_CONFIG.
2019-04-14 12:22:11 ERROR OGG-00199 Oracle GoldenGate Delivery for Oracle, r_card.prm: Table CARD.CBSD_SOCKET_CONFIG does not exist in target database.
2019-04-14 12:22:11 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, r_card.prm: PROCESS ABENDING.

 

原因：
" "1.、在e进程中排除相关报错表
2.查找r进程最后一个日志rba号，修改rba号，启动r进程
[opdb1@sdb1db07:/db/db1/app/ogg/dirdat]$ ls -la
total 1520
drwxrwxr-x 2 opdb1 oinstall 4096 Apr 14 11:20 .
-rw-rw-rw- 1 opdb1 oinstall 3388 Apr 14 14:26 dp000006

[opdb1@sdb1db07:/db/db1/app/ogg/dirdat]$ ../logdump
Logdump 152 >open dp000002
Current LogTrail is /db/db1/app/ogg/dirdat/dp000002
Logdump 153 >n

2019/04/14 11:06:04.410.714 FileHeader Len 451 RBA 0
Name: *FileHeader*
3000 01a7 3000 0008 4747 0d0a 544c 0a0d 3100 0002 | 0...0...GG..TL..1...
0002 3200 0004 4000 0000 3300 0008 02f2 aca8 45be | ..2...@...3.......E.
335a 3400 002b 0029 7572 693a 7363 6f72 6564 6230 | 3Z4..+.)uri:sdb1db0
313a 3a63 7262 616e 6b3a 636f 7265 3a61 7070 3a6f | 1::db:db1:app:o
6767 3a44 5f43 4152 4436 0000 1300 112e 2f64 6972 | gg:D_CARD6....../dir
6461 742f 6470 3030 3030 3032 3700 0001 0138 0000 | dat/dp0000027....8..
0400 0000 0239 0000 0800 0000 0000 0002 083a ff00 | .....9...........:..

Logdump 154 >n

2019/04/14 11:07:42.835.745 RestartAbend Len 0 RBA 459
Name:
After Image: Partition 0 G s

Logdump 155 >n ---跳转到最后一个，找到RBA

---GGSCI中执行如下：
GGSCI (sdb1db07) 48> alter r_symb,extrba 2238
REPLICAT altered.
GGSCI (sdb1db07) 51> start r_symb
"
5 "2019-04-14 15:13:04 INFO OGG-01020 Processed extract process RESTART_ABEND record at seq 6, rba 3876 (aborted 0 records).
2019-04-14 15:13:04 ERROR OGG-00665 OCI Error getting OCI_ATTR_NAME for UDT (status = 24328-ORA-24328: illegal attribute value), SQL<Not available>.
Reading ./dirdat/dp000006, current RBA 3937, 0 records"

原因：

不支持raw类型，

排除user.SA_Q_HEADER表

 

6 "2019-04-14 15:33:14 ERROR OGG-01168 Oracle GoldenGate Delivery for Oracle, r_card.prm: Encountered an update for target table CARD.CD_CARD_SIGN_TBL, which has no unique key defined. KEYCOLS can b
e used to define a key. Use ALLOWNOOPUPDATES to process the update without applying it to the target database. Use APPLYNOOPUPDATES to force the update to be applied using all columns in both the SET
and WHERE clause.
2019-04-14 15:33:14 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, r_card.prm: PROCESS ABENDING."

 

原因：

r进程参数文件中新增ALLOWNOOPUPDATES 参数

 

 

7 "2019-04-14 17:20:32 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, r_symb.prm: SQL error 1 mapping user.FM_CCY_GAP_PERIOD to user.FM_CCY_GAP_PERIOD OCI Error ORA-00001: unique constr
aint (user.KCG_PK) violated (status = 1), SQL <INSERT INTO ""user"".""FM_CCY_GAP_PERIOD"" (""GAP_TYPE"",""CCY"",""PERIOD_NO"",""PERIOD_TYPE"",""START_DATE"",""END_DATE"") VALUES (:a0,:a1,:a2,:a3,:a4,:a5)>.
2019-04-14 17:20:32 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, r_symb.prm: Repositioning to rba 590501 in seqno 6.
2019-04-14 17:20:32 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, r_symb.prm: Error mapping from user.FM_CCY_GAP_PERIOD to

user.FM_CCY_GAP_PERIOD."

原因：

truncate表导致两边数据不一致，需要排除truncate表

 

8 "这四张表报错，应用反馈没有truncate，
user1 sa_user_tbl
user ecif_batch_bus_date
user1 sa_user_dbname
user1 sa_user_profile

2019-04-15 09:19:26 INFO OGG-06508 Oracle GoldenGate Capture for Oracle, d_card.prm: Wildcard MAP (TABLE) resolved (entry user1.*): TABLE ""user1"".""SA_USER_TBL"".
2019-04-15 09:19:26 WARNING OGG-06439 Oracle GoldenGate Capture for Oracle, d_card.prm: No unique key is defined for table SA_USER_TBL. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-04-15 09:19:26 INFO OGG-06509 Oracle GoldenGate Capture for Oracle, d_card.prm: Using the following key columns for source table user1.SA_USER_TBL: USER_ID, USER_NAME, USER_LANG, USER_DESC, ACCOUNT_STATUS, ID, USER_TYPE.
2019-04-15 09:19:26 INFO OGG-06508 Oracle GoldenGate Capture for Oracle, d_card.prm: Wildcard MAP (TABLE) resolved (entry user1.*): TABLE ""user1"".""SA_USER_TBL"".
2019-04-15 09:19:26 WARNING OGG-06439 Oracle GoldenGate Capture for Oracle, d_card.prm: No unique key is defined for table SA_USER_TBL. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-04-15 09:19:26 WARNING OGG-02081 Oracle GoldenGate Capture for Oracle, d_card.prm: Detected duplicate TABLE/MAP entry for source table user1.SA_USER_TBL and target table user1.SA_USER_TBL. Using prior TABLE/MAP specification.
" "cause:SA_USER_TBL
two key in this table user1.
add constraint SAUT_PK primary key (USER_ID)
add constraint SAUT_UK unique (ID)
解决办法：
在source和target端，问题表后面都加上keycols选项，告诉ogg真正的主键。

添加keycols参数后解决问题。
MAP XXXXXXXXX_HIS ,TARGET XXXXXXXXX_HIS , keycols(id) ;

总结：如果source端表有2个唯一键，那么一定在extract参数中用keycols参数指出主键列。
target端replicat进程参数也要用keycols参数指出主键列。"