• Database Blog
  • GoldenGate 12c
    • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Master Oracle 12c DBA
  • Oracle Tutorials
    • Oracle Tips & Tricks
    • Oracle VirtualBox
  • Learn Excel

VitalSoftTech

Database Administration | Oracle | Oracle Training | DBA Support | Oracle 12c DBA | GoldenGate | GoldenGate 12c | DBA Interview Questions | Goldengate Interview Questions | Natik Ameen

  • Digital Marketing
  • Blogging Tutorial and Tips
  • Cool Names
  •   Login
« Previous Post
Next Post »

GoldenGate GGSCI Commands II

December 23, 2016 by Natik Ameen   /  Goldengate

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!

Filed Under: Goldengate Tagged With: Goldengate Replication

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

« Previous Post
Next Post »

Join over 3,000 others My posts. Your Inbox. Beautiful.

Database    GoldenGate

Natik Ameen

About Natik Ameen

Natik Ameen is an Oracle Production DBA, Oracle Certified RAC Expert and a DBA track Certification trainer for over 17 years. He is an Oracle Evangelist and has presented at IOUG & UTOUG conferences. He writes on topics such as Database Administration, RAC, GoldenGate and the Cloud.

Who is Natik Ameen?

Guides

  • My GoldenGate Tutorials
  • Oracle 12c Database Tutorials
  • GoldenGate GGSCI Command Series
  • My OraTips and Tricks

Popular Blogs

  • My GoldenGate Home Page
  • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Top 30 RAC Interview Questions That Helped Me. Are You Prepared?
  • Oracle GoldenGate Concepts and Architecture Made Simple!
  • Virtualize Oracle RAC 12c on My Laptop
  • Step by Step Oracle 12c Database Install on Virtual Box

Popular Oracle Articles

Oracle Announces Beta Availability of Oracle Database 12c Release 2
Top 5 Announcements at Oracle Open World
News on Oracle Database STANDARD EDITION 12.1.0.2

Technology Centers

Oracle Business Intelligence and DW
Cloud Computing, SOA, Virtualization
Big data, Java, Linux, PLSQL, Security
Enterprise Architecture, Digital Experience

Oracle Documentation

10g R1, 10g R2, 11g R1, 11g R2, 12c R1
Oracle CPU's, EM 11g, EM 12c
GoldenGate 12c, Oracle VM, VirtualBox

Copyright ©2022

BLOGOracle Tutorials