GoldenGate GGSCI commands executed at the ggsci line utility, are used to configure, manage, monitor and troubleshoot the different components of the Goldengate Replication configuration.
Oracle Golden Gate Commands Series
• GoldenGate: GGSCI Commands I
• GoldenGate: GGSCI Commands II
• GoldenGate: GGSCI Commands III
You are able to look at the current status, lag, database versions, previous commands run, add/delete processes, etc.
Some of the more interesting Golden Gate GGSCI commands are below.
Oracle Golden Gate Commands
The HISTORY Command
GGSCI (proddb01) 44> history
GoldenGate GGSCI Command History
35: info PMP02 detail
36: info all
37: info PMP02 detail
38: info all
39: info all
40: history
41: view report EXT02
42: history
43: view report EXT02 detail
44: history
GGSCI (proddb01) 45> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING PMP02 00:00:00 00:00:01
EXTRACT RUNNING EXT02 00:00:00 00:00:01
REPLICAT RUNNING RHA02 00:00:00 00:00:03
The ! Command
To rerun the previous command use “!”
GGSCI (proddb01) 46> !
info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING PMP02 00:00:00 00:00:06
EXTRACT RUNNING EXT02 00:00:00 00:00:06
REPLICAT RUNNING RHA02 00:00:00 00:00:08
To run a specific command from the history use “!” with the command line number.
GGSCI (proddb01) 47> !42
history
GGSCI Command History
38: info all
39: info all
40: history
41: view report EXT02
42: history
43: view report EXT02 detail
44: history
45: info all
46: info all
47: history
The VERSIONS Command
VERSION: You can view this to view the version of the OS, host info and the database version.
GGSCI (proddb02) 3> versions
Operating System:
SunOS
Version Generic_147440-01, Release 5.10
Node: proddb02
Machine: sun4u
Database:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Solaris: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
The REPORT Command
REPORTS: View the reports for specific processes.
GGSCI (proddb01) 49> view report EXT02
Opened new report file at 2013-03-12 00:01:00.
***********************************************************************
** Run Time Messages **
***********************************************************************
2013-03-12 02:43:12 INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p21775_extr: start=SeqNo: 17632, RBA: 21008, SCN: 0.1148
5118 (11485118), Timestamp: 2013-03-12 02:41:35.000000, Thread: 1, end=SeqNo: 17632, RBA: 21504, SCN: 0.11485118 (11485118), Timestamp: 2013-03-1
2 02:41:35.000000, Thread: 1.
2013-03-12 06:43:20 INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p21775_extr: start=SeqNo: 17646, RBA: 18448, SCN: 0.1149
0824 (11490824), Timestamp: 2013-03-12 06:42:08.000000, Thread: 1, end=SeqNo: 17646, RBA: 18944, SCN: 0.11490824 (11490824), Timestamp: 2013-03-1
2 06:42:08.000000, Thread: 1.
The SHOW ALL Command
Use the “show” command to look at the configuration info on the different processes.
GGSCI (proddb01) 50> show
Parameter settings:
SET SUBDIRS ON
SET DEBUG OFF
Current directory: /u01/app/ha/ggs
Using subdirectories for all process files
Editor: vi
Reports (.rpt) /u01/app/db01/ggs/dirrpt
Parameters (.prm) /u01/app/db01/ggs/dirprm
Stdout (.out) /u01/app/db01/ggs/dirout
Replicat Checkpoints (.cpr) /u01/app/db01/ggs/dirchk
Extract Checkpoints (.cpe) /u01/app/db01/ggs/dirchk
Process Status (.pcs) /u01/app/db01/ggs/dirpcs
SQL Scripts (.sql) /u01/app/db01/ggs/dirsql
Database Definitions (.def) /u01/app/db01/ggs/dirdef
GGSCI (proddb01) 52> show all
Parameter settings:
SET SUBDIRS ON
SET DEBUG OFF
Current directory: /u01/app/ha/ggs
Using subdirectories for all process files
Editor: vi
Reports (.rpt) /u01/app/db01/ggs/dirrpt
Parameters (.prm) /u01/app/db01/ggs/dirprm
Stdout (.out) /u01/app/db01/ggs/dirout
Replicat Checkpoints (.cpr) /u01/app/db01/ggs/dirchk
Extract Checkpoints (.cpe) /u01/app/db01/ggs/dirchk
Process Status (.pcs) /u01/app/db01/ggs/dirpcs
SQL Scripts (.sql) /u01/app/db01/ggs/dirsql
Database Definitions (.def) /u01/app/db01/ggs/dirdef
If you would like us to write about specific Oracle Golden Gate commands please let us know in the comment section below.
Other Feature Articles
• My GoldenGate Home Page
• Oracle GoldenGate Concepts and Architecture Made Simple!
how can we get to know for which databases golden gate configured on server having 10 databases ?
how to identify golden gate installation path on server when we logged on server which file need to check to get info???