Book Image

Oracle Goldengate 12c Implementers Guide

By : John P Jeffries
Book Image

Oracle Goldengate 12c Implementers Guide

By: John P Jeffries

Overview of this book

The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.
Table of Contents (16 chapters)
12
A. GGSCI Commands
13
B. GoldenGate Installed Components
14
C. Acronyms
15
Index

Stopping GoldenGate processes


Now that we know how to start the Manager, Extract, and Replicat processes using GGSCI commands, let's take a look at how to stop them. Issuing a stop command will gracefully shutdown the GoldenGate processes.

  1. First, check the processes that are running in your GoldenGate Home using the following code:

    GGSCI (db12server01) 1> info all
    
    Program     Status      Group       Lag         Time Since Chkpt
    
    MANAGER     RUNNING
    EXTRACT     RUNNING     EOLTP01     00:00:00    00:00:01
    EXTRACT     RUNNING     EPMP01      00:00:00    00:00:02
    
  2. Stop all processes using a wildcard, as shown in the following code:

    GGSCI (db12server01) 2> stop *
    
    Sending STOP request to EXTRACT EOLTP01 ...
    Request processed.
    
    Sending STOP request to EXTRACT EPMP01 ...
    Request processed.
    
  3. Check the processes again using the following code:

    GGSCI (db12server01) 3> info all
    
    Program     Status      Group       Lag         Time Since Chkpt
    
    MANAGER     RUNNING
    EXTRACT     STOPPED     EOLTP01...