Oracle In Depth

GG extraction and pump

Taking care of GG extraction and pump

[HPSM11]-->cd /u01/app/gg/12.2.1/gghome_1/

[oracle@amxd1dbadm01:/u01/app/gg/12.2.1/gghome_1]

[HPSM11]-->./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO

Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48

Operating system character set identified as UTF-8.

GGSCI (amxd1dbadm01) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT ABENDED GGS_EXT 00:00:03 05:45:48

EXTRACT ABENDED GGS_EXT2 00:00:04 05:45:47

EXTRACT RUNNING GGS_PMP2 00:00:00 00:00:03

EXTRACT RUNNING GGS_PUMP 00:00:00 00:00:04

GGSCI (amxd1dbadm01) 2>

GGSCI (amxd1dbadm01) 2> start GGS_EXT

Sending START request to MANAGER ...

EXTRACT GGS_EXT starting

GGSCI (amxd1dbadm01) 3> start GGS_EXT2

Sending START request to MANAGER ...

EXTRACT GGS_EXT2 starting

GGSCI (amxd1dbadm01) 53> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING GGS_EXT 00:39:58 00:00:08

EXTRACT RUNNING GGS_EXT2 00:39:59 00:00:07

EXTRACT RUNNING GGS_PMP2 00:00:00 00:00:02

EXTRACT RUNNING GGS_PUMP 00:00:00 00:00:02

GGSCI (amxd1dbadm01) 54>

GG is in sync now

GGSCI (amxd1dbadm01) 56> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING GGS_EXT 00:00:02 00:00:05

EXTRACT RUNNING GGS_EXT2 00:00:04 00:00:05

EXTRACT RUNNING GGS_PMP2 00:00:00 00:00:00

EXTRACT RUNNING GGS_PUMP 00:00:00 00:00:01

GGSCI (amxd1dbadm01) 57>

Menu