O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Stopping GoldenGate processes

We have seen how to start the Manager, Extract, and Replicat processes using GGSCI commands. Let's take a look at stopping them. Issuing a stop command will gracefully shutdown the GoldenGate processes.

  1. Firstly check which processes are running.
    GGSCI (dbserver1) 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.
    GGSCI (dbserver1) 2> stop *
    Sending STOP request to EXTRACT EOLTP01 ...
    Request processed.
    Sending STOP request to EXTRACT EPMP01 ...
    Request processed.
    
  3. Check the processes again.
    GGSCI (dbserver1) 3> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required