1,第一个问题 ---报错---现象,目标mysql库两个表,一个有数据,一个没有数据,切复制进程RBA为0 查看源端ggserr.log 发现端倪 2018-06-27 15:47:42 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all. 2018-06-27 15:47:52 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all. 2018-06-27 15:48:03 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all. 2018-06-27 15:48:13 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all. 2018-06-27 15:48:19 ERROR OGG-06524 Oracle GoldenGate Capture for Oracle, ek_12.prm: The trail or file has reached the 2GB size limit. Add a MAXFILES clause to RMTTFILE or EXTFILE. 2018-06-27 15:48:19 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ek_12.prm: PROCESS ABENDING. 2018-06-27 15:48:23 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all. 2018-06-27 15:48:33 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all. 2018-06-27 15:48:43 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all. 2018-06-27 15:48:53 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all. 2018-06-27 15:49:04 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all. 2018-06-27 15:49:14 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all. 2018-06-27 15:49:24 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all. --解决--- GGSCI (bapdb1) 13> view params ek_12

EXTRACT ek_12 USERID ggskafka, PASSWORD ggskafka RMTHOST xx.1.x.247, MGRPORT 9178 RMTFILE ./dirdat/b2,maxfiles 999, megabytes 500 table xxx; table xxx;

去掉源端初始化进程中RMTFILE ./dirdat/b2,maxfiles 999, megabytes 500,format release 11.2,format relase 12.1即可。

2,第二个问题

2018-06-28 10:37:54 ERROR OGG-00360 FORMAT RELEASE 12.1 cannot be used with RECOVERYOPTIONS OVERWRITEMODE/APPENDMOD E.

2018-06-28 10:37:54 ERROR OGG-01668 PROCESS ABENDING.

解决办法:

1,将投递进程去掉format参数 2018-06-28 10:36:13 ERROR OGG-01416 File ./dirdat/b4000000, with format RELEASE 12.1, does not match current format specification of RELEASE 9.0/9.5. Modify the parameter file to specify format RELEASE 12.1 or issue ETROLLOVER prior t o restart.

2018-06-28 10:36:13 ERROR OGG-01668 PROCESS ABENDING.

2,将投递进程format参数修改为目标端12.3 2018-06-28 10:40:38 ERROR OGG-10124 (pmp_kaf4.prm) line 5: Parsing error, value "12.3" is not one of the legal valu es (10.4|11.1|11.2|12.1|12.2) for [release].

2018-06-28 10:40:38 ERROR OGG-01668 PROCESS ABENDING.

3,下面是正式的解决办法。

[oracle@salesdb dirdat]$ cd ../dirprm [oracle@salesdb dirprm]$ ls ek_03.prm ext_kaf1.prm ext_kaf4.prm mgr.prm pmp_kaf3.prm repsa.prm reptt.prm salesdb4.prm ek_04.prm ext_kaf2.prm extsp.prm pmp_kaf1.prm pmp_kaf4.prm repsp.prm salesdb2.prm salesdb.prm extfx.prm ext_kaf3.prm jagent.prm pmp_kaf2.prm pumpfx.prm repts.prm salesdb3.prm [oracle@salesdb dirprm]$ more pmp_kaf4.prm EXTRACT PMP_KAF4 USERID c##ggadmin,PASSWORD ggadmin PASSTHRU RMTHOST 10.1.1.247, MGRPORT 9178 RMTTRAIL ./dirdat/b4,format release 12.1 SOURCECATALOG SALESPDB table ssp.m_system_user;

[oracle@salesdb dirprm]$ rm -rf pmp_kaf4.prm [oracle@salesdb dirprm]$ cd ../ [oracle@salesdb ggs12]$ ./ggsci

GGSCI (salesdb) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
JAGENT RUNNING
EXTRACT RUNNING EXT_KAF1 00:00:01 00:00:08
EXTRACT RUNNING EXT_KAF2 00:00:02 00:00:09
EXTRACT RUNNING EXT_KAF3 00:00:01 00:00:09
EXTRACT RUNNING EXT_KAF4 00:00:06 00:00:01
EXTRACT RUNNING PMP_KAF1 00:00:00 00:00:09
EXTRACT RUNNING PMP_KAF2 00:00:00 00:00:06
EXTRACT RUNNING PMP_KAF3 00:00:00 00:00:06
EXTRACT ABENDED PMP_KAF4 00:00:00 00:13:21

GGSCI (salesdb) 2> delete PMP_KAF4 Deleted EXTRACT PMP_KAF4.

GGSCI (salesdb) 3> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
JAGENT RUNNING
EXTRACT RUNNING EXT_KAF1 00:00:02 00:00:08
EXTRACT RUNNING EXT_KAF2 00:00:03 00:00:09
EXTRACT RUNNING EXT_KAF3 00:00:01 00:00:09
EXTRACT RUNNING EXT_KAF4 00:00:04 00:00:01
EXTRACT RUNNING PMP_KAF1 00:00:00 00:00:10
EXTRACT RUNNING PMP_KAF2 00:00:00 00:00:08
EXTRACT RUNNING PMP_KAF3 00:00:00 00:00:06

GGSCI (salesdb) 4> view params EXT_KAF4

extract EXT_KAF4 userid c##ggadmin,PASSWORD ggadmin LOGALLSUPCOLS UPDATERECORDFORMAT COMPACT exttrail ./dirdat/k4,FORMAT RELEASE 12.1 SOURCECATALOG SALESPDB
table ssp.m_system_user;

GGSCI (salesdb) 5> add extract PMP_KAF4, exttrailsource ./dirdat/k4 EXTRACT added.

GGSCI (salesdb) 6> add rmttrail ./dirdat/b4,EXTRACT PMP_KAF4,MEGABYTES 200 RMTTRAIL added.

GGSCI (salesdb) 7> edit params PMP_KAF4 EXTRACT PMP_KAF4 USERID c##ggadmin,PASSWORD ggadmin PASSTHRU RMTHOST 10.1.1.247, MGRPORT 9178 RMTTRAIL ./dirdat/b4,format release 12.1 SOURCECATALOG SALESPDB table ssp.m_system_user;