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
|Displays the Manager process status information.|
|START MANAGER |
|Starts the Manager process.|
| STOP MGR |
|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
INFO EXTRACT <EXTRACT_NAME>
|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
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