GoldenGate quick reference

Quick Reference: Oracle Golden Gate Commands

The commands listed below are used in Oracle Golden Gate's Command Line Interface, GGSCI, to access the GGSCI login as the goldengate user and type ggsci at the OS command prompt.  Be sure that you are in the GGS_HOME directory in order to get valid responses to these commands.
GGSCI commands to view:
1. send status -- This will return a detailed status of the processing state, including current read and write positions.
2. stats -- This will return the transaction operations processed.
3. info all -- Gives a high level overview of all the ggs processes and their current status.
4. info detail -- Provides more detail information about a process/processes. It tells when the process started and additional information depending on the process.
5. info , showch -- Shows information about Extract/Replicat checkpoints. This includes read, write, recovery checkpoints.
GoldenGate report files:
Extract and Replicat processes generate reports file at the end of each run with the following information recorded:
> parameters in use
> table and column mapping
> database information
> runtime messages and errors
> runtime statistics for the number of operations processed

The reports can be viewed by:
ggsci>send report  -- this is to flush out the latest information to the report
ggsci> view report -- this will allow you to view the contents of the report
If a process abends without a report, run the process from the command shell of the operating system (not GGSCI) to send process information to the terminal.
Syntax:
paramfile .prm
Where:
is either Extract or Replicat.
Paramfile .prm is the fully qualified name of the parameter file.
For example:
replicat paramfile ./dirprm/E1_279QA.prm