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