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