GoldenGate GGSCI Commands II

Using Golden Gate Oracle Commands

The GGSCI command line interface has been provided to add, monitor and manage the various Golden Gate replication processes. This article is second of a 3 part series covering these important commands required to manage your Replication environment.

Other Golden Gate Oracle Command Series

GoldenGate: GGSCI Commands I
GoldenGate: GGSCI Commands III

The MANAGER Command

This command is used to manage the manager processes. This is the leader process and before any other extracts, pumps or replicat processes can be added the MANAGER process should be up and healthy. This is how we determine the status and its health.

GGSCI (xgoldengate01) 1> status manager
Manager is running (IP port xgoldengate 7833).

GGSCI (xgoldengate01) 2> status extract XINT1
EXTRACT XINT1: RUNNING

GGSCI (xgoldengate01) 3> status replicat RINT1
REPLICAT RINT1: RUNNING

GGSCI (xgoldengate01) 4> status ER *
REPLICAT RINT1: RUNNING
EXTRACT XINT1: RUNNING

The INFO Command

• Manager
• Extract .., detail
• Replicat ..,detail
• All
• ER
• Exttrail *
• Rmttrail *

GGSCI (xgoldengate01) 1> info manager

Manager is running (IP port xgoldengate01.7833).

GGSCI (xgoldengate01) 2> info extract XINT1, detail

EXTRACT XINT1 Last Started 2013-04-25 16:16 Status RUNNING
Checkpoint Lag 00:00:22 (updated 18:38:35 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
2013-04-25 16:15:57
SCN 0.0 (0)

Target Extract Trails:

Remote Trail Name Seqno RBA Max MB
./dirdat/xn 8 1056 100

Extract Source Begin End
/oracle/oradata/onlinelog/kf_7m2wbtv7_.log * Initialized * 2013-04-24 11:20
/oracle/oradata/onlinelog/kf_7m2wbtv7_.log 2013-04-24 11:19 2013-04-24 11:20
/oracle/oradata/onlinelog/kf_7m2w9bbb_.log 2013-04-24 10:48 2013-04-24 10:59
/oracle/oradata/onlinelog/kf_7m2wdkok_.log 2013-04-24 10:48 2013-04-24 10:48

Current directory /u01/app/ggs

Report file /u01/app/ggs/dirrpt/XINT1.rpt
Parameter file /u01/app/ggs/dirprm/XINT1.prm
Checkpoint file /u01/app/ggs/dirchk/XINT1.cpe
Process file /u01/app/ggs/dirpcs/XINT1.pce
Stdout file /u01/app/ggs/dirout/XINT1.out
Error log /u01/app/ggs/ggserr.log

GGSCI (xgoldengate01) 3> info replicat RINT1, detail

REPLICAT RINT1 Last Started 2013-04-25 15:48 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Log Read Checkpoint File /u01/app/ggs/dirdat/ps000000
2013-04-25 15:48:39.000000 RBA 0

Extract Source Begin End

/u01/app/ggs/dirdat/ps000000 2013-04-25 15:48 2013-04-25 15:48
/u01/app/ggs/dirdat/ps000000 * Initialized * 2013-04-25 15:48

Current directory /u01/app/ggs

Report file /u01/app/ggs/dirrpt/RINT1.rpt
Parameter file /u01/app/ggs/dirprm/rINT1.prm
Checkpoint file /u01/app/ggs/dirchk/RINT1.cpr
Checkpoint table GGS_CHECKPOINT
Process file /u01/app/ggs/dirpcs/RINT1.pcr
Stdout file /u01/app/ggs/dirout/RINT1.out
Error log /u01/app/ggs/ggserr.log

GGSCI (xgoldengate01) 4> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING XINT1 00:00:00 00:00:01
EXTRACT RUNNING PINT1 00:00:02 00:00:04
REPLICAT RUNNING RINT1 00:00:00 00:00:02

GGSCI (xgoldengate01) 5> info ER *

EXTRACT PINT1 Last Started 2013-04-25 14:26 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint File /u01/app/ggs/dirdat/xn000008
2013-04-25 16:16:19.555173 RBA 1056

EXTRACT XINT1 Initialized 2013-04-25 17:18 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
2013-04-25 17:18:55
SCN 0.0 (0)

REPLICAT RINT1 Last Started 2013-04-25 15:48 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Log Read Checkpoint File /u01/app/ggs/dirdat/ps000000
2013-04-25 15:48:39.000000 RBA 335

GGSCI (xgoldengate01) 6> info exttrail *

Extract Trail: /u01/app/ggs/dirdat/pi
Extract: PINT1
Seqno: 3
RBA: 1227
File Size: 100M

Extract Trail: ./dirdat/xn
Extract: XINT1
Seqno: 3
RBA: 167
File Size: 100M

GGSCI (xgoldengate01) 7> info rmttrail *

Extract Trail: /u01/app/ggs/dirdat/pi
Extract: PINT1
Seqno: 3
RBA: 1227
File Size: 100M

Extract Trail: ./dirdat/xn
Extract: XINT1
Seqno: 3
RBA: 167
File Size: 100M

The STATS Command
• Extract ..
• Replicat
• ER

GGSCI (xgoldengate01) 1> stats XINT1

Sending STATS request to EXTRACT XINT1 ...

Start of Statistics at 2013-04-26 11:16:54.

DDL replication statistics (for all trails):

*** Total statistics since extract started ***
Operations 955.00
Mapped operations 12.00
Unmapped operations 932.00
Other operations 11.00
Excluded operations 943.00
......

GGSCI (xgoldengate01) 2> stats replicat RINT1

Sending STATS request to REPLICAT RINT1 ...
......
*** Latest statistics since 2013-04-09 14:55:12 ***
Total inserts 80.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 80.00
......

GGSCI (xgoldengate01) 3> stats ER *

......

Output to /u01/app/ggs/dirdat/p1:

Extracting from GGS_APP.COM_AUDIT_TRAIL to GGS_APP.COM_AUDIT_TRAIL:

*** Total statistics since 2013-02-28 08:30:48 ***
Total inserts 35028.00
Total updates 0.00
Total deletes 64139.00
Total discards 0.00
Total operations 99167.00
........

Other Feature Articles
My GoldenGate Home Page
Oracle GoldenGate Concepts and Architecture Made Simple!

Leave a Reply

Your email address will not be published.