GGSCI Command for GoldenGate
3 min readINFO
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 & STOP
START MANAGER Starts the Manager Process START MGR Starts the Manager Process 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
ADD EXTRACT DXEXT, Tranlog, Begin Now Used to specify transaction logs as data source for extract. ADD EXTRACT DXEXT, Begin Now, Passive Specifies the extract to be run in passive mode. ADD EXTRACT DXEXT, Extseqno 000022 Extrba 087354, Begin Now Specifies the extract process starting position ADD EXTRACT DXEXT, SOURCEISTABLE Extracts data from data tables for initial loading.
ALTER Command
ALTER EXTRACT DXEXT, BEGIN NOW Instructs extract to start processing ALTER EXTRACT DXEXT, BEGIN 2022-08-21 Instructs extract to start processing from specific date ALTER EXTRACT DXEXT, ETROLLOVER Extract rolls over to next trail file ALTER EXTRACT DXEXT, EXTSEQNO 05, EXTRBA 3245763 Alters extract to start from the specific location in the trail ALTER EXTRACT DXEXT, THREAD 8, BEGIN 2021-04-22 Alters extract thread & start date for RAC ALTER EXTRACT DXEXT, LSN 234:1273:1 Altering extract for the SQL Server
INFO ALL It is used to display the info of the extract like its status, lag, checkpoint, run history,etc.
INFO EXTRACT DXEXT, SHOWCH Display checkpoint info of extract INFO EXTRACT DXEXT, DETAIL Display trail info, run history INFO EXTRACT DXEXT, TASKS Display extract tasks
KILL COMMAND It is used to kill the extract that can’t be stopped with STOP Command
KILL EXTRACT DXEXT
| LAG Command | It is used to find the lag time between Extract and data source more precisely than the “INFO Command” |
LAG EXTRACT DXEXT To find lag for extract “DXEXT” 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 DXEXT LOGRETENTION To register extract “DXEXT”
| 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 DXEXT, ROLLOVER To increment the extract to next file in trail SEND EXTRACT DXEXT, STOP To stop the extract process SEND EXTRACT DXEXT, TRANLOGOPTIONS TRANSCLEANUPFREQUENCY 20 For the Oracle RAC, specify the time after which the OGG scan and delete the orphan transactions SEND EXTRACT DXEXT, SKIPTRANS 2.12.3432 THREAD 4 For skipping the transaction in the Oracle RAC environment SEND EXTRACT DXEXT, SHOWTRANS Display the info about the open transactions like checkpoint, extract group name, SCN, Redo log and RB, status etc. SEND EXTRACT DXEXT, SHOWTRANS COUNT 2 Display the info for two transactions only
| STATS Command | It is used to display the stats for the extract process including the DDL and DML operations. |
STATS DXEXT STATS EXTRACT DXEXT stats will be displayed for the extract DXEXT STATS EXTRACT DXEXT REPORTRATE SEC display the stats for the fetch operations per sec STATS EXTRACT DXEXT, TOTAL, DAILY The total stats is shown since the start of the day STATS EXTRACT DXEXT, TOTAL, HOURLY, REPORTRATE MIN, RESET, REPORTFETCH By using comma between the keywords multiple options can be used for the stats command
