• 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 I

December 23, 2016 by Natik Ameen   /  Goldengate

Cloud 1 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!

Filed Under: Goldengate Tagged With: Goldengate

Comments

  1. ranareddy0550@gmail.com'rana reddy says

    May 30, 2018 at 9:43 am

    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???

    Reply

Leave a Reply Cancel reply

Your email address will not be published.

« 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 ©2021

BLOGOracle Tutorials