Oracle Goldengate Tutorial - Beginner (Level 2)

GGSCI (GoldenGate Software Command Interface)

• GGSCI is a command line tool to configure and manage Oracle Goldengate Processes.
• You can use GGSCI to issue the complete range of commands that configure, control, and monitor Oracle Goldengate.
• To start GGSCI, change directories to the Oracle Goldegate installation directory and then run the ggsci executable file.

[oracle@linux1 ~]$ cd /u01/app/oracle/product/gg/

[oracle@linux1 gg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

Linux, x86, 32bit (optimized), Oracle 11g on Apr 23 2012 08:09:25

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

GGSCI (linux1) 1>

• Few commands used in GGSCI
• info all - List out the all the processes and their status.
• HISTORY - Displays a list of previously executed commands.
• ! - Execute the previous command again without editing it.
• FC - To edit the previous command and then execute it.

GGSCI (linux1) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED

EXTRACT     STOPPED     EX05        00:00:00      455:41:38

EXTRACT     ABENDED     EX06        00:00:00      360:20:27

EXTRACT     ABENDED     EX1         00:00:00      144:38:39

EXTRACT     STOPPED     EX24        00:00:00      699:59:39

EXTRACT     STOPPED     EX28        00:00:00      589:11:14

EXTRACT     STOPPED     EX30        00:00:00      554:47:32

EXTRACT     STOPPED     EXGGATE     00:00:00      746:03:09

EXTRACT     STOPPED     EXSRC       00:00:00      723:24:57

EXTRACT     STOPPED     EXT         00:00:00      340:15:56

EXTRACT     ABENDED     PM1         00:00:00      289:51:46

EXTRACT     STOPPED     PMP         00:00:00      340:16:02

GGSCI (linux1) 2> !

info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED

EXTRACT     STOPPED     EX05        00:00:00      455:41:44

EXTRACT     ABENDED     EX06        00:00:00      360:20:32

EXTRACT     ABENDED     EX1         00:00:00      144:38:45

EXTRACT     STOPPED     EX24        00:00:00      699:59:45

EXTRACT     STOPPED     EX28        00:00:00      589:11:19

EXTRACT     STOPPED     EX30        00:00:00      554:47:37

EXTRACT     STOPPED     EXGGATE     00:00:00      746:03:15

EXTRACT     STOPPED     EXSRC       00:00:00      723:25:03

EXTRACT     STOPPED     EXT         00:00:00      340:16:02

EXTRACT     ABENDED     PM1         00:00:00      289:51:52

EXTRACT     STOPPED     PMP         00:00:00      340:16:08

GGSCI (linux1) 3> history

GGSCI Command History

    1: info all

    2: info all

    3: history

GGSCI (linux1) 4> FC