Below are some of the GoldenGate commands that we use frequently. We work on GoldenGate 12c version but almost all commands work in same manner in 11g and 12c.
MANAGER RELATED COMMANDS
| COMMAND | DESCRIPTION |
| INFO MANAGER or INFO MGR or STATUS MANAGER |
Displays the Manager process status information. |
| START MANAGER | Starts the Manager process. |
| STOP MGR or 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 | Not used very frequently but 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 “DETAIL” keyword to get further details.
INFO EXTRACT, DETAIL It also supports wild card, Example like below you can get details of all EXTRACT process that starts with E in 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 too:STOP EXTRACT * |
| STATS EXTRACT | Displays the Extract process statistics. |
| START EXTRACT | This command starts the Extract process. Supports wildcards too: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 Extract process to generate statistics/reports |
| VIEW REPORT | Allows process reports generated by the SEND command to be viewed |
REPLICAT RELATED COMMANDS
| COMMAND | DESCRIPTION |
| INFO REPLICAT <REPLICAT_NAME> or STATUS REPLICAT <REPLICAT_NAME> |
Displays the status summary for the Replicat process
The DETAIL option provides more information: INFO REPICAT, DETAIL |
| START REPLICAT <REPLICAT_NAME> | Starts the Replicat process |
| STATS REPLICAT <REPLICAT_NAME> | Displays the Replicat process statistics. |
| STOP REPLICAT <REPLICAT_NAME> | Stops the Replicat process |
| KILL REPLICAT <REPLICAT_NAME> | kills the Replicat process and is used when the process cannot be stopped gracefully. |
| LAG REPLICAT <REPLICAT_NAME> | Displays the lag time between the Replicat process and the data source. |
| REGISTER REPLICAT <REPLICAT_NAME> | Registers the Replicat process group with its target database |
| UNREGISTER REPLICAT <REPLICAT_NAME> | unregisters an Replicat from its target database. |
| CLEANUP REPLICAT <REPLICAT_NAME> | Deletes the run history for the specified Replicat group. The Replicat process must be stopped first. |
| DELETE REPLICAT <REPLICAT_NAME> | This command deletes an Extract group. The Replicat process must be stopped first. |
| SEND REPLICAT <REPLICAT_NAME> | Sends ad hoc report generation or trace file generation command to Replicat |
| VIEW REPORT <REPLICAT_NAME> | Allows process to view reports generated by the SEND command |
MISCELLANEOUS COMMANDS
| COMMAND | DESCRIPTION |
| ADD EXTTRAIL | Creates a local trail for an Extract group. |
| ALTER EXTTRAIL | Can alter local trail example if you want to edit the trail file size |
| ADD RMTTRAIL | Creates a remote trail for an Extract or data pump group |
| ALTER RMTTRAIL | Can be used to alter the remote trail size |
| INFO EXTTRAIL | Provides information on the local trail status |
| INFO RMTTRAIL | Provides information on the remote trail status |
| DELETE EXTTRAIL | Deletes the local trail |
| DELETE RMTTRAIL | Deletes the remote trail |
| VIEW PARAMS | Allows a process’ parameter file to be viewed |
| EDIT PARAMS | Allows a process’ parameter file to be edited |
| ADD CREDENTIALSTORE | Creates a Credentials Store wallet to store database user/password |
| INFO CREDENTIALSTORE | Lists all users defined in the Credentials Store wallet. |
| DBLOGIN | provides access to the database with the username and password OR you can also use db login alias. Example:
DBLOGIN USERIDALIAS sourcepass |
| ADD SCHEMATRANDATA | This command can be run only after you have connected to database using dblogin. It adds database schema level supplemental logging |
| ADD TRANDATA | This command can be run only after you have connected to database using dblogin. It adds supplemental logging to a database table. |
| DELETE TRANDATA | This command stops the supplemental logging on a database table |
| INFO TRANDATA | Provides the supplemental logging status on a database table |
| INFO SCHEMATRANDATA | Provides the supplemental logging status on a database schema |
| HISTORY | Lists a history of GGSCI commands that were used. |
| ADD CHECKPOINTTABLE | Adds a checkpoint table on the target database. |
| DELETE CHECKPOINTTABLE | Deletes the checkpoint table from the database. |
| INFO CHECKPOINTTABLE | Shows the checkpoint table status and creation date |
| OBEY | You can run a set of command in chunks by putting those commands in .oby file and executing it
Example: OBEY dirprm/conf.oby |
| SHELL | Allows OS commands to be executed from GGSCI command prompt SHELL df -h dirdat |
Also at any time you can type “HELP” in ggsci command prompt to get help on a command
Example, for help on a specific command, type HELP [command] [object]
HELP ADD EXTRACT
REFERENCE:
https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/ggsci_commands.htm#GWURF110
I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
Latest posts by Brijesh Gogia (see all)
- Oracle Multitenant DB 4 : Parameters/SGA/PGA management in CDB-PDB - July 18, 2020
- Details of running concurrent requests in Oracle EBS - May 26, 2020
- Oracle Multitenant DB 3 : Data Dictionary Architecture in CDB-PDB - March 20, 2020
Very useful Sir.
thanks for the commands