{"id":4152,"date":"2025-06-09T11:12:59","date_gmt":"2025-06-09T11:12:59","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&p=4152"},"modified":"2025-06-09T11:19:14","modified_gmt":"2025-06-09T11:19:14","slug":"oracle-goldengate-ggsci-commands-2","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/oracle-dba-d2d-tasks\/oracle-goldengate-ggsci-commands-2\/","title":{"rendered":"Oracle GoldenGate GGSCI Commands"},"content":{"rendered":"\n

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.<\/p>\n\n\n\n

Stop Sequence (Order: Replicat \u2192 Extract \u2192 JAgent \u2192 Manager)<\/h2>\n\n\n\n
STOP REPLICAT *       -- Stop all Replicat processes\nSTOP EXTRACT *        -- Stop all Extract processes\nSTOP JAGENT           -- Stop JAgent process\nSTOP MGR              -- Stop Manager process<\/code><\/pre>\n\n\n\n
\ud83d\udcdd 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.<\/em><\/p>\n\n\n\n
Start Sequence (Order: Manager \u2192 JAgent \u2192 Extract \u2192 Replicat)<\/h2>\n\n\n\n
START MGR             -- Start Manager process\nSTART JAGENT          -- Start JAgent process\nSTART EXTRACT *       -- Start all Extract processes\nSTART REPLICAT *      -- Start all Replicat processes<\/code><\/pre>\n\n\n\n
\ud83d\udcdd 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.<\/em><\/p>\n\n\n\n
Manager Commands<\/h2>\n\n\n\n
INFO MANAGER                  -- Show Manager status\nSTART MANAGER                -- Start Manager\nSTOP MANAGER                 -- Stop Manager\nSTOP MANAGER!                -- Force stop (no confirmation)\nSEND MANAGER GETPORTINFO     -- View detailed port info<\/code><\/pre>\n\n\n\n
Extract Commands<\/h2>\n\n\n\n
INFO EXTRACT <name>                    -- Show Extract status\nSTART EXTRACT <name>                   -- Start Extract process\nSTOP EXTRACT <name>                    -- Stop Extract process\nKILL EXTRACT <name>                    -- Force stop Extract\nSTATS EXTRACT <name>                   -- Show Extract statistics\nLAG EXTRACT <name>                     -- Check lag\nADD EXTRACT <name>, INTEGRATED TRANLOG, BEGIN NOW  -- Create Integrated Extract\nREGISTER EXTRACT <name>                -- Register Extract with DB\nUNREGISTER EXTRACT <name>              -- Unregister Extract\nCLEANUP EXTRACT <name>                 -- Clear Extract history\nDELETE EXTRACT <name>                  -- Delete Extract group\nSEND EXTRACT <name>                    -- Send command\/statistics to Extract\nVIEW REPORT <name>                     -- View Extract report<\/code><\/pre>\n\n\n\n
Replicat Commands<\/h2>\n\n\n\n
INFO REPLICAT <name>                   -- Show Replicat status\nSTART REPLICAT <name>                  -- Start Replicat\nSTOP REPLICAT <name>                   -- Stop Replicat\nKILL REPLICAT <name>                   -- Force stop Replicat\nSTATS REPLICAT <name>                  -- Show Replicat stats\nLAG REPLICAT <name>                    -- Check lag\nREGISTER REPLICAT <name>              -- Register Replicat with DB\nUNREGISTER REPLICAT <name>            -- Unregister Replicat\nCLEANUP REPLICAT <name>               -- Clear Replicat history\nDELETE REPLICAT <name>                -- Delete Replicat group\nSEND REPLICAT <name>                  -- Send command\/statistics to Replicat\nVIEW REPORT <name>                    -- View Replicat report<\/code><\/pre>\n\n\n\n
Trail & Parameter File Commands<\/h2>\n\n\n\n
ADD EXTTRAIL <path>                    -- Add local trail\nADD RMTTRAIL <path>                    -- Add remote trail\nINFO EXTTRAIL \/ RMTTRAIL              -- Display trail info\nDELETE EXTTRAIL \/ RMTTRAIL            -- Delete trail files\nVIEW PARAMS <name>                    -- View parameter file\nEDIT PARAMS <name>                    -- Edit parameter file<\/code><\/pre>\n\n\n\n
DB Login & Security<\/h2>\n\n\n\n
DBLOGIN USERIDALIAS <alias>           -- Login using alias\nADD CREDENTIALSTORE                   -- Create credential wallet\nINFO CREDENTIALSTORE                  -- View stored credentials<\/code><\/pre>\n\n\n\n
Supplemental Logging<\/h2>\n\n\n\n
ADD SCHEMATRANDATA <schema>           -- Enable schema-level logging\nADD TRANDATA <table>                  -- Enable table-level logging\nDELETE TRANDATA <table>               -- Remove table-level logging\nINFO SCHEMATRANDATA \/ TRANDATA        -- Show current logging status<\/code><\/pre>\n\n\n\n
Checkpoint & Miscellaneous<\/h2>\n\n\n\n
ADD CHECKPOINTTABLE                   -- Add checkpoint table\nDELETE CHECKPOINTTABLE                -- Remove checkpoint table\nINFO CHECKPOINTTABLE                  -- Show checkpoint info\nHISTORY                               -- View command history\nOBEY <file.oby>                       -- Execute commands from file\nSHELL <OS_cmd>                        -- Run OS command from GGSCI\nHELP <command>                        -- GGSCI command help<\/code><\/pre>\n\n\n\n
Notes<\/h3>\n\n\n\n
    \n
  • Always follow the recommended start\/stop order to avoid data loss or inconsistencies.<\/li>\n\n\n\n
  • SEND<\/code>, INFO<\/code>, and VIEW REPORT<\/code> commands are essential for troubleshooting.<\/li>\n\n\n\n
  • Use credential store and USERIDALIAS<\/code> for secure DB access.<\/li>\n\n\n\n
  • Apply supplemental logging before setting up replication to ensure data integrity.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
    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 \u2192 Extract \u2192 JAgent \u2192 Manager) \ud83d\udcdd Replicat is stopped first […]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,984],"class_list":["post-4152","cposts","type-cposts","status-publish","hentry","category-notes","category-oracle-dba-d2d-tasks"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/4152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=4152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=4152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}