2018-05-07T09:50:46.375+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for MySQL: GGSCI command (admin): start initlod1.
2018-05-07T09:50:46.381+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from GGSCI on host [FE80::4055:95D5:777A:ED26]:58418 (START EXTRACT INITLOD1 ).
2018-05-07T09:50:46.386+0800 INFO OGG-00975 Oracle GoldenGate Manager for MySQL, MGR.prm: EXTRACT INITLOD1 starting.
2018-05-07T09:50:46.552+0800 INFO OGG-01017 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.
2018-05-07T09:50:46.552+0800 INFO OGG-00992 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT INITLOD1 starting.
2018-05-07T09:50:46.559+0800 INFO OGG-03059 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Operating system character set identified as GBK.
2018-05-07T09:50:46.562+0800 INFO OGG-02695 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2018-05-07T09:50:46.575+0800 INFO OGG-01360 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT is running in Initial Load mode.
2018-05-07T09:50:46.616+0800 INFO OGG-01889 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Flush size (max message size) is set to 27,985.
2018-05-07T09:50:46.767+0800 INFO OGG-01851 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: filecaching started: thread ID: 46244112.
2018-05-07T09:50:46.767+0800 INFO OGG-01815 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Virtual Memory Facilities for: COM
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
D:\ogg\dirtmp.
2018-05-07T09:50:46.783+0800 WARNING OGG-01842 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: CACHESIZE PER DYNAMIC DETERMINATION (2G) LESS THAN RECOMMENDED: 64G (64bit system)
vm found: 3G
Check swap space. Recommended swap/extract: 128G (64bit system).
2018-05-07T09:50:46.800+0800 INFO OGG-06508 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Wildcard MAP (TABLE) resolved (entry test.*): TABLE "test"."test1".
2018-05-07T09:50:46.814+0800 INFO OGG-06509 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Using the following key columns for source table test.test1: name, age.
2018-05-07T09:50:46.814+0800 INFO OGG-00993 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT INITLOD1 started.
2018-05-07T09:50:46.782+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from EXTRACT on host [127.0.0.1]:58420 (VERSION).
2018-05-07T09:50:46.782+0800 INFO OGG-00960 Oracle GoldenGate Manager for MySQL, MGR.prm: Access granted (rule #1).
2018-05-07T09:50:46.782+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from EXTRACT on host [127.0.0.1]:58421 (START SERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ).
2018-05-07T09:50:47.003+0800 WARNING OGG-01880 Oracle GoldenGate Collector for MySQL: ALLOWOUTPUTDIR D:\ogg\ is the same directory where this GoldenGate instance is installed.
2018-05-07T09:50:47.011+0800 INFO OGG-01888 Oracle GoldenGate Collector for MySQL: TCP network is configured as
OS DEFAULT SPECIFIED ACTUAL VALUE
IP_DSCP N/A N/A N/A
IP_TOS N/A N/A N/A
TCP_NODELAY 256 N/A 256
SO_SNDBUF 8192 N/A 8192
SO_RCVBUF 8192 N/A 8192.
2018-05-07T09:50:46.982+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from SERVER on host [::1]:58422 (REPORT 7292 7819).
2018-05-07T09:50:46.982+0800 INFO OGG-00960 Oracle GoldenGate Manager for MySQL, MGR.prm: Access granted (rule #1).
2018-05-07T09:50:46.982+0800 INFO OGG-00974 Oracle GoldenGate Manager for MySQL, MGR.prm: Manager started collector process (Port 7819).
2018-05-07T09:50:47.022+0800 INFO OGG-01228 Oracle GoldenGate Collector for MySQL: Timeout in 300 seconds.
2018-05-07T09:50:52.118+0800 INFO OGG-01888 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: TCP network is configured as
OS DEFAULT SPECIFIED ACTUAL VALUE
IP_DSCP N/A N/A N/A
IP_TOS N/A N/A N/A
TCP_NODELAY 256 N/A 256
SO_SNDBUF 8192 N/A 8192
SO_RCVBUF 8192 N/A 8192.
2018-05-07T09:50:52.145+0800 INFO OGG-01229 Oracle GoldenGate Collector for MySQL: Connected to admin-PC:58425.
2018-05-07T09:50:52.166+0800 INFO OGG-01478 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Output file ./dirdat/el1.dat is using format RELEASE 12.3.
2018-05-07T09:50:52.165+0800 INFO OGG-01669 Oracle GoldenGate Collector for MySQL: Opening D:\ogg\./dirdat/el1.dat (byte 0, current EOF 0).
2018-05-07T09:50:52.248+0800 INFO OGG-02911 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Processing table test.test1.
2018-05-07T09:50:52.375+0800 INFO OGG-01735 Oracle GoldenGate Collector for MySQL: Synchronizing D:\ogg\./dirdat/el1.dat to disk.
2018-05-07T09:50:52.392+0800 INFO OGG-00991 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT INITLOD1 stopped normally.
2018-05-07T09:50:52.447+0800 INFO OGG-01971 Oracle GoldenGate Collector for MySQL: The previous message, 'INFO OGG-01735', repeated 1 times.
2018-05-07T09:50:52.447+0800 INFO OGG-01670 Oracle GoldenGate Collector for MySQL: Closing D:\ogg\./dirdat/el1.dat.
2018-05-07T09:50:52.447+0800 INFO OGG-01735 Oracle GoldenGate Collector for MySQL: Synchronizing D:\ogg\./dirdat/el1.dat to disk.
2018-05-07T08:53:48.093+0800 INFO OGG-01085 Oracle GoldenGate Manager for MySQL, MGR.prm: mgr received window closed event.
2018-05-07T08:53:54.047+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for MySQL: GGSCI command (admin): start mgr.
2018-05-07T08:53:54.220+0800 WARNING OGG-01877 Oracle GoldenGate Manager for MySQL, MGR.prm: Missing explicit accessrule for server collector.
2018-05-07T08:53:54.220+0800 INFO OGG-00983 Oracle GoldenGate Manager for MySQL, MGR.prm: Manager started (port 7809).
2018-05-07T08:53:59.711+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for MySQL: GGSCI command (admin): start initlod1.
2018-05-07T08:53:59.720+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from GGSCI on host [FE80::4055:95D5:777A:ED26]:58049 (START EXTRACT INITLOD1 ).
2018-05-07T08:53:59.724+0800 INFO OGG-00975 Oracle GoldenGate Manager for MySQL, MGR.prm: EXTRACT INITLOD1 starting.
2018-05-07T08:53:59.861+0800 INFO OGG-01017 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.
2018-05-07T08:53:59.861+0800 INFO OGG-00992 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT INITLOD1 starting.
2018-05-07T08:53:59.868+0800 INFO OGG-03059 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Operating system character set identified as GBK.
2018-05-07T08:53:59.873+0800 INFO OGG-02695 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2018-05-07T08:53:59.885+0800 INFO OGG-01360 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT is running in Initial Load mode.
2018-05-07T08:53:59.926+0800 INFO OGG-01889 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Flush size (max message size) is set to 27,985.
2018-05-07T08:54:00.075+0800 INFO OGG-01851 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: filecaching started: thread ID: 46113040.
2018-05-07T08:54:00.083+0800 INFO OGG-01815 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Virtual Memory Facilities for: COM
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
D:\ogg\dirtmp.
2018-05-07T08:54:00.095+0800 WARNING OGG-01842 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: CACHESIZE PER DYNAMIC DETERMINATION (2G) LESS THAN RECOMMENDED: 64G (64bit system)
vm found: 3.44G
Check swap space. Recommended swap/extract: 128G (64bit system).
2018-05-07T08:54:00.112+0800 INFO OGG-06508 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Wildcard MAP (TABLE) resolved (entry test.*): TABLE "test"."test1".
2018-05-07T08:54:00.127+0800 INFO OGG-06509 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Using the following key columns for source table test.test1: name, age.
2018-05-07T08:54:00.127+0800 INFO OGG-00993 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT INITLOD1 started.
2018-05-07T08:54:00.118+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from EXTRACT on host [127.0.0.1]:58051 (VERSION).
2018-05-07T08:54:00.118+0800 INFO OGG-00960 Oracle GoldenGate Manager for MySQL, MGR.prm: Access granted (rule #1).
2018-05-07T08:54:00.118+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from EXTRACT on host [127.0.0.1]:58052 (START SERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ).
2018-05-07T08:54:00.279+0800 WARNING OGG-01880 Oracle GoldenGate Collector for MySQL: ALLOWOUTPUTDIR D:\ogg\ is the same directory where this GoldenGate instance is installed.
2018-05-07T08:54:00.286+0800 INFO OGG-01888 Oracle GoldenGate Collector for MySQL: TCP network is configured as
OS DEFAULT SPECIFIED ACTUAL VALUE
IP_DSCP N/A N/A N/A
IP_TOS N/A N/A N/A
TCP_NODELAY 256 N/A 256
SO_SNDBUF 8192 N/A 8192
SO_RCVBUF 8192 N/A 8192.
2018-05-07T08:54:00.258+0800 INFO OGG-00963 Oracle GoldenGate Manager for MySQL, MGR.prm: Command received from SERVER on host [::1]:58053 (REPORT 5168 7819).
2018-05-07T08:54:00.258+0800 INFO OGG-00960 Oracle GoldenGate Manager for MySQL, MGR.prm: Access granted (rule #1).
2018-05-07T08:54:00.258+0800 INFO OGG-00974 Oracle GoldenGate Manager for MySQL, MGR.prm: Manager started collector process (Port 7819).
2018-05-07T08:54:00.296+0800 INFO OGG-01228 Oracle GoldenGate Collector for MySQL: Timeout in 300 seconds.
2018-05-07T08:54:05.303+0800 INFO OGG-01888 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: TCP network is configured as
OS DEFAULT SPECIFIED ACTUAL VALUE
IP_DSCP N/A N/A N/A
IP_TOS N/A N/A N/A
TCP_NODELAY 256 N/A 256
SO_SNDBUF 8192 N/A 8192
SO_RCVBUF 8192 N/A 8192.
2018-05-07T08:54:05.303+0800 INFO OGG-01229 Oracle GoldenGate Collector for MySQL: Connected to admin-PC:58058.
2018-05-07T08:54:05.304+0800 INFO OGG-01478 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Output file ./dirdat/el1.dat is using format RELEASE 12.3.
2018-05-07T08:54:05.304+0800 INFO OGG-01669 Oracle GoldenGate Collector for MySQL: Opening D:\ogg\./dirdat/el1.dat (byte 0, current EOF 0).
2018-05-07T08:54:05.345+0800 INFO OGG-02911 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: Processing table test.test1.
2018-05-07T08:54:05.377+0800 INFO OGG-01735 Oracle GoldenGate Collector for MySQL: Synchronizing D:\ogg\./dirdat/el1.dat to disk.
2018-05-07T08:54:05.457+0800 INFO OGG-00991 Oracle GoldenGate Capture for MySQL, INITLOD1.prm: EXTRACT INITLOD1 stopped normally.
2018-05-07T08:54:05.457+0800 INFO OGG-01971 Oracle GoldenGate Collector for MySQL: The previous message, 'INFO OGG-01735', repeated 1 times.
2018-05-07T08:54:05.457+0800 INFO OGG-01670 Oracle GoldenGate Collector for MySQL: Closing D:\ogg\./dirdat/el1.dat.
2018-05-07T08:54:05.457+0800 INFO OGG-01735 Oracle GoldenGate Collector for MySQL: Synchronizing D:\ogg\./dirdat/el1.dat to disk.