Frequently Used Golden Gate Commands

Frequently Used Golden Gate Commands

Below are some of the Golden Gate commands that we use in day-to-day Golden gate maintenance.

MANAGER PROCESS RELATED COMMANDS

COMMAND DESCRIPTION
INFO MGR
INFO MANAGER
STATUS MANAGER
Displays the Manager process status information.
START MANAGER
START MGR
Starts the Manager process.
STOP MGR
STOP MANAGER
or
STOP MANAGER!
Stops the Manager process.
If you put! mark in the end then it will not ask you y/n prompt also and directly stop it.
SEND MANAGER It is very useful when you are troubleshooting some issues. Checks addition
status information when used with extra options.
Example to get the port information use like below:
SEND MANAGER GETPORTINFO DETAIL




EXTRACT RELATED COMMANDS

COMMAND DESCRIPTION
INFO <EXTRACT_NAME>
or
INFO EXTRACT <EXTRACT_NAME>
OR
STATUS EXTRACT
Displays the status summary for an Extract process. Use the “DETAIL” keyword to get further details. INFO EXTRACT, DETAIL It also supports wild card, Example below you can get details of all EXTRACT process that starts with E in a single statement. INFO E*, DETAIL
 ADD EXTRACT Creates a new Extract group Example for Integrated Extract:
ADD EXTRACT ESOURCE01, INTEGRATED TRANLOG, BEGIN NOW
 ALTER EXTRACT This command alters an existing Extract group
 STOP EXTRACT This command stops the Extract process
Supports wildcards as well – STOP EXTRACT *
 STATS EXTRACT Displays the Extract process statistics.
 START EXTRACT This command starts the Extract process.
Supports wildcards as well – START EXTRACT *
 REGISTER EXTRACT Registers an Extract process group with its source database
 UNREGISTER EXTRACT Unregisters an Extract process group from its source database
 KILL EXTRACT Kills an Extract process. Use when the process cannot be stopped gracefully.
LAG EXTRACT Displays the lag time between the Extract process and the data source
CLEANUP EXTRACT Deletes the run history for the specified Extract group. you must stop the Extract before cleaning it up.
DELETE EXTRACT It will delete the Extract group. The Extract process must first be stopped.
SEND EXTRACT It will direct the Extract process to generate statistics/reports
VIEW REPORT Allows process reports generated by the SEND command to be viewed

REPLICATE RELATED COMMANDS

INFO REPLICAT / STATUS REPLICAT
It Displays the status summary for the Replicat process

The DETAIL option provides more information:
INFO REPICAT, DETAIL

START REPLICAT – Starts the Replicat process
STATS REPLICAT – Displays the Replicat process statistics.
STOP REPLICAT -Stops the Replicat process
KILL REPLICAT -kills the Replicat process and is used when the process cannot be stopped
Gracefully.


LAG REPLICAT — Displays the lag time between the Replicat process and the data source.
REGISTER REPLICAT –Registers the Replicat process group with its target database
UNREGISTER REPLICAT –Unregisters an Replicat from its target database.
CLEANUP REPLICAT –Deletes the run history for the specified Replicat group.The Replicat process

Must be stopped first.
DELETE REPLICAT –This command deletes an Extract group.

The Replicat process must be stopped first.
SEND REPLICAT –Sends ad hoc report generation or trace file generation command to Replicat
VIEW REPORT –Allows a process to view reports generated by the SEND command