ADVERTISEMENT

Oracle GoldenGate GGSCI Commands

Oracle GoldenGate is a powerful tool for real-time data replication. To maintain data integrity and ensure smooth operation, it’s important to follow proper sequences for starting and stopping processes, and to use the correct GGSCI (GoldenGate Software Command Interface) commands.

Stop Sequence (Order: Replicat → Extract → JAgent → Manager)

STOP REPLICAT *       -- Stop all Replicat processes
STOP EXTRACT *        -- Stop all Extract processes
STOP JAGENT           -- Stop JAgent process
STOP MGR              -- Stop Manager process

📝 Replicat is stopped first to prevent applying incomplete transactions; Extract next to stop capturing new data; JAgent follows to cleanly stop monitoring; and Manager last as it controls all other processes.

Start Sequence (Order: Manager → JAgent → Extract → Replicat)

START MGR             -- Start Manager process
START JAGENT          -- Start JAgent process
START EXTRACT *       -- Start all Extract processes
START REPLICAT *      -- Start all Replicat processes

📝 Manager is started first to initiate and manage all processes; JAgent next to enable monitoring and coordination; Extract follows to begin capturing changes; and Replicat last to start applying the captured data.

Manager Commands

INFO MANAGER                  -- Show Manager status
START MANAGER                -- Start Manager
STOP MANAGER                 -- Stop Manager
STOP MANAGER!                -- Force stop (no confirmation)
SEND MANAGER GETPORTINFO     -- View detailed port info

Extract Commands

INFO EXTRACT <name>                    -- Show Extract status
START EXTRACT <name>                   -- Start Extract process
STOP EXTRACT <name>                    -- Stop Extract process
KILL EXTRACT <name>                    -- Force stop Extract
STATS EXTRACT <name>                   -- Show Extract statistics
LAG EXTRACT <name>                     -- Check lag
ADD EXTRACT <name>, INTEGRATED TRANLOG, BEGIN NOW  -- Create Integrated Extract
REGISTER EXTRACT <name>                -- Register Extract with DB
UNREGISTER EXTRACT <name>              -- Unregister Extract
CLEANUP EXTRACT <name>                 -- Clear Extract history
DELETE EXTRACT <name>                  -- Delete Extract group
SEND EXTRACT <name>                    -- Send command/statistics to Extract
VIEW REPORT <name>                     -- View Extract report

Replicat Commands

INFO REPLICAT <name>                   -- Show Replicat status
START REPLICAT <name>                  -- Start Replicat
STOP REPLICAT <name>                   -- Stop Replicat
KILL REPLICAT <name>                   -- Force stop Replicat
STATS REPLICAT <name>                  -- Show Replicat stats
LAG REPLICAT <name>                    -- Check lag
REGISTER REPLICAT <name>              -- Register Replicat with DB
UNREGISTER REPLICAT <name>            -- Unregister Replicat
CLEANUP REPLICAT <name>               -- Clear Replicat history
DELETE REPLICAT <name>                -- Delete Replicat group
SEND REPLICAT <name>                  -- Send command/statistics to Replicat
VIEW REPORT <name>                    -- View Replicat report

Trail & Parameter File Commands

ADD EXTTRAIL <path>                    -- Add local trail
ADD RMTTRAIL <path>                    -- Add remote trail
INFO EXTTRAIL / RMTTRAIL              -- Display trail info
DELETE EXTTRAIL / RMTTRAIL            -- Delete trail files
VIEW PARAMS <name>                    -- View parameter file
EDIT PARAMS <name>                    -- Edit parameter file

DB Login & Security

DBLOGIN USERIDALIAS <alias>           -- Login using alias
ADD CREDENTIALSTORE                   -- Create credential wallet
INFO CREDENTIALSTORE                  -- View stored credentials

Supplemental Logging

ADD SCHEMATRANDATA <schema>           -- Enable schema-level logging
ADD TRANDATA <table>                  -- Enable table-level logging
DELETE TRANDATA <table>               -- Remove table-level logging
INFO SCHEMATRANDATA / TRANDATA        -- Show current logging status

Checkpoint & Miscellaneous

ADD CHECKPOINTTABLE                   -- Add checkpoint table
DELETE CHECKPOINTTABLE                -- Remove checkpoint table
INFO CHECKPOINTTABLE                  -- Show checkpoint info
HISTORY                               -- View command history
OBEY <file.oby>                       -- Execute commands from file
SHELL <OS_cmd>                        -- Run OS command from GGSCI
HELP <command>                        -- GGSCI command help

Notes

  • Always follow the recommended start/stop order to avoid data loss or inconsistencies.
  • SEND, INFO, and VIEW REPORT commands are essential for troubleshooting.
  • Use credential store and USERIDALIAS for secure DB access.
  • Apply supplemental logging before setting up replication to ensure data integrity.

ADVERTISEMENT