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 ggskafkaRMTHOST xx.1.x.247, MGRPORT 9178RMTFILE ./dirdat/b2,maxfiles 999, megabytes 500table 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 formatspecification of RELEASE 9.0/9.5. Modify the parameter file to specify format RELEASE 12.1 or issue ETROLLOVER prior to 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 values (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]$ lsek_03.prm ext_kaf1.prm ext_kaf4.prm mgr.prm pmp_kaf3.prm repsa.prm reptt.prm salesdb4.prmek_04.prm ext_kaf2.prm extsp.prm pmp_kaf1.prm pmp_kaf4.prm repsp.prm salesdb2.prm salesdb.prmextfx.prm ext_kaf3.prm jagent.prm pmp_kaf2.prm pumpfx.prm repts.prm salesdb3.prm[oracle@salesdb dirprm]$ more pmp_kaf4.prm EXTRACT PMP_KAF4USERID c##ggadmin,PASSWORD ggadminPASSTHRURMTHOST 10.1.1.247, MGRPORT 9178RMTTRAIL ./dirdat/b4,format release 12.1 SOURCECATALOG SALESPDBtable 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 ggadminLOGALLSUPCOLSUPDATERECORDFORMAT COMPACTexttrail ./dirdat/k4,FORMAT RELEASE 12.1SOURCECATALOG 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_KAF4USERID c##ggadmin,PASSWORD ggadminPASSTHRURMTHOST 10.1.1.247, MGRPORT 9178RMTTRAIL ./dirdat/b4,format release 12.1SOURCECATALOG SALESPDBtable ssp.m_system_user;