GoldenGate Commands

Cataloged here are some very important, common commands that are used via the GGSCI interface during the GoldenGate configuration and for troubleshooting.

INFO INFO MANAGER Provides details of the Manager process INFO MGR Also provides details of the Manager process STATUS MANAGER This command also display the info of manager REFRESH REFRESH MANAGER Reloads from the Manager Parameter file REFRESH MGR Reloads from the Manager Parameter file SEND SEND MANAGER CHILDSTATUS Displays status of processes, started by Manager. SEND MANAGER CHILDSTATUS DEBUG Return the ports numbers allocated by the Manager SEND MANAGER GETPORTINFO Displays the list of currently allocated ports by Manager process SEND MANAGER GETPORTINFO DETAIL Provides info on ports and process assigned to them. SEND MANAGER GETPURGEOLDEXTRACTS Retrieves trail purge retention info. START START MANAGER Starts the Manager Process START MGR Starts the Manager Process STOP STOP MGR Stops the Manager Process STOP MANAGER ! Stops Manager without asking for user confirmation. STOP MGR ! Stops Manager without asking for user confirmation. ADD Command Creates an Extract group. ADD EXTRACT E_SRC, Tranlog, Begin Now Used to specify transaction logs as data source for extract. ADD EXTRACT E_SRC, Begin Now, Passive Specifies the extract to be run in passive mode. ADD EXTRACT E_SRC, Extseqno 000008 Extrba 287458, Begin Now Specifies the extract process starting position ADD EXTRACT E_SRC, SOURCEISTABLE Extracts data from data tables for initial loading. ALTER Command ALTER EXTRACT e_src, BEGIN NOW Instructs extract to start processing ALTER EXTRACT e_src, BEGIN 2013-04-16 Instructs extract to start processing from specific date ALTER EXTRACT e_src, ETROLLOVER Extract rolls over to next trail file ALTER EXTRACT e_src, EXTSEQNO 01, EXTRBA 2887 Alters extract to start from the specific locaton in the trail ALTER EXTRACT e_src, THREAD 4, BEGIN 2012-03-09 Alters extract thread & start date for RAC ALTER EXTRACT e_src, LSN 1234:123:1 Altering extract for the SQL Server CLEANUP Command It is used to clear the run history for the specific extract group CLEANUP EXTRACT e_src It purges all history of records except last CLEANUP EXTRACT e_src, SAVE 10 It saves last 10 records and deletes all other DELETE Command It is used to delete the extract process, its checkpoints detail and unregister the extract group. DELETE EXTRACT e_src deletes the extract process DELETE EXTRACT e* deletes all extract process whose name starts with e DELETE EXTRACT e* ! deletes all extract process whose name starts with e without prompting INFO Command It is used to display the info of the extract like its status, lag, checkpoint, run history, trail info etc INFO EXTRACT e_src, SHOWCH Display checkpoint info of extract INFO EXTRACT e_src, DETAIL Display trail info, run history INFO EXTRACT e_src, TASKS Display extract tasks KILL Command It is used to kill the extract that can't be stopped with STOP Command"" KILL EXTRACT e_src LAG Command It is used to find the lag time between Extract and data source more precisely than the "INFO Command" LAG EXTRACT e_src To find lag for extract "e_src" LAG EXTRACT * To find lag for all of the extract processes REGISTER Command It is used to register the extract process, so that it can retain the archive logs required for its recovery. REGISTER EXTRACT e_src LOGRETENTION To register extract "e_src" SEND Command It is used to communicate with the running extract like sending requests for report creation, stats, to force extract to rollover to next trail etc SEND EXTRACT finance, ROLLOVER To increment the extract to next file in trail SEND EXTRACT finance, STOP To stop the extract process SEND EXTRACT finance, TRANLOGOPTIONS TRANSCLEANUPFREQUENCY 20 For the Oracle RAC, specify the time after which the OGG scan and delete the orphan transactions SEND EXTRACT finance, SKIPTRANS 5.17.27634 THREAD 2 For skipping the transaction in the Oracle RAC environment SEND EXTRACT e_src, SHOWTRANS Display the info about the open transactions like checkpoint, extract group name, SCN, Redo log and RB, status etc SEND EXTRACT e_src, SHOWTRANS COUNT 2 Display the info for two transactions only START Command It is used to start the Extract process START EXTRACT e_src STATS Command It is used to display the stats for the extract process including the DDL and DML operations. STATS e_src STATS EXTRACT e_src stats will be displayed for the extract E_SRC"" STATS EXTRACT e_src REPORTRATE SEC display the stats for the fetch opertions per sec STATS EXTRACT e_src, TOTAL, DAILY The total stats is shown since the start of the day STATS EXTRACT e_src, TOTAL, HOURLY, REPORTRATE MIN, RESET, REPORTFETCH By using comma between the keywords multiple options can be used for the stats command STATUS Command It is used to check whether extract process is currently running or not. STATUS EXTRACT e_src To check the status for extract "E_SRC" STATUS EXTRACT e* To check the status for all extracts starting with "e" STOP Command It is used to stop the running extract process STOP EXTRACT e_src To stop the extract "e_src" STOP EXTRACT e* To stop all of the running extract process whose name start with "e" STOP EXTRACT * To stop all of the running extract processes UNREGISTER Command it is used to unregister the extract group by removing its registration from oracle DB. UNREGISTER EXTRACT e_src LOGRETENTION To unregister the extract e_src""