OGG 运维篇+常用命令大全

最新推荐文章于 2025-09-19 09:14:27 发布

原创

最新推荐文章于 2025-09-19 09:14:27 发布 · 2.3k 阅读

4 ·

CC 4.0 BY-SA版权

本文作者：zzt_2009

文章标签：

#OGG命令 #OGG命令大全 #OGG常用命令 #OGG相关命令

本文提供Oracle GoldenGate软件中各种命令的快速查阅指南，包括Manager、Extract、Replicat等核心组件的控制命令，以及参数文件管理、数据库交互等辅助命令。适合于日常管理和故障排查。

说明：本文为Oracle GoldenGate常用命令指导手册
标签：OGG命令、OGG常用命令、OGG命令详情、OGG相关命令
温馨提示：如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化

★ 常用命令如下


This file describes the commands that can be issued through the Oracle GoldenGate  
Software Command Interface (GGSCI). This is the command interface between  
users and Oracle GoldenGate functional components.  
 
 
Summary of Manager Commands  
Use the Manager commands to control the Manager process. Manager is the parent  
process of Oracle GoldenGate and is responsible for the management of its processes  
and files, resources, user interface, and the reporting of thresholds and errors.  
 
Command                     Description   
INFO MANAGER                Returns information about the Manager port and process id.   
SEND MANAGER                Returns information about a running Manager process and optionally 
                            child processes.   
START MANAGER               Starts the Manager process.   
STATUS MANAGER              Returns the state of the Manager port and process ID.   
STOP MANAGER                Stops the Manager process.   
 
 
Summary of Extract Commands  
Use the Extract commands to create and manage Extract groups. The Extract process  
captures either full data records or transactional data changes, depending on configuration  
parameters, and then sends the data to a trail for further processing by a downstream  
process, such as a data-pump Extract or the Replicat process.  
 
Command                     Description   
ADD EXTRACT                 Creates an Extract group.   
ALTER EXTRACT               Changes attributes of an Extract group   
CLEANUP EXTRACT             Deletes run history for an Extract group   
DELETE EXTRACT              Deletes an Extract group.   
INFO EXTRACT                Returns information about an Extract group.   
KILL EXTRACT                Forcibly terminates the run of an Extract group.   
LAG EXTRACT                 Returns information about Extract lag.   
REGISTER EXTRACT            Registers an Extract group with an Oracle database.   
SEND EXTRACT                Sends instructions to, or returns information about, a running   
                            Extract group.   
START EXTRACT               Starts an Extract group.   
STATS EXTRACT               Returns processing statistics for an Extract group.   
STATUS EXTRACT              Returns the state of an Extract group.   
STOP EXTRACT                Stops an Extract group.   
FORCEAPPEND                 Allows data pump to add new trail files on top of existing initial load files 
UNREGISTER EXTRACT          Unregisters an Extract group from an Oracle database.  
 
 
Summary of Replicat Commands  
Use the Replicat commands to create and manage Replicat groups. The Replicat  
process reads data extracted by the Extract process and applies it to target tables  
or prepares it for use by another application, such as a load application.  
 
Command                     Description   
ADD REPLICAT                Adds a Replicat group.   
ALTER REPLICAT              Changes attributes of a Replicat group.   
CLEANUP REPLICAT