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.
这个文件描述了可以通过Oracle GoldenGate发出的命令
软件命令接口(GGSCI)。这是命令之间的接口
用户和Oracle GoldenGate的功能组件。
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.
返回有关管理器端口和进程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.
返回管理器端口和进程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.
向Oracle数据库注册提取组。
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
允许data pump在现有的初始加载文件上添加新的跟踪文件
UNREGISTER EXTRACT Unregisters an Extract group from an Oracle database.
从Oracle数据库注销提取组。
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.
Replicat命令的摘要
使用Replicat命令创建和管理Replicat组。的Replicat
进程读取由提取进程提取的数据并将其应用于目标表
或将其准备供另一个应用程序(如加载应用程序)使用。
Command Description
ADD REPLICAT Adds a Replicat group.
添加一个副本组。
ALTER REPLICAT Changes attributes of a Replicat group.
更改副本组的属性。
CLEANUP REPLICAT Deletes run history of a Replicat group.
删除副本组的运行历史。
DELETE REPLICAT Deletes a Replicat group.
删除一个副本组。
INFO REPLICAT Returns information about a Replicat group.
返回关于副本组的信息。
KILL REPLICAT Forcibly terminates a Replicat group.
强制终止一个复制组。
LAG REPLICAT Returns information about Replicat lag.
返回关于复制延迟的信息。
REGISTER REPLICAT Registers a Replicat group with an Oracle database.
向Oracle数据库注册一个副本组。
SEND REPLICAT Sends instructions to, or returns information about, a running
Replicat group.
发送指令,或返回有关运行的信息Replicat组。
START REPLICAT Starts a Replicat group.
启动一个副本组。
STATS REPLICAT Returns processing statistics for a Replicat group.
返回处理一个副本组的统计信息。
STATUS REPLICAT Returns the state of a Replicat group.
返回一个副本组的状态。
STOP REPLICAT Stops a Replicat group.
停止一个复制组。
SYNCHRONIZE REPLICAT Returns all threads of a coordinated Replicat to a uniform
start point after an unclean shutdown of the Replicat process.
将一个协调的副本的所有线程返回到一个统一的启动点后,不洁关机的复制进程。
UNREGISTER REPLICAT Unregisters a Replicat group from an Oracle database.
从Oracle数据库注销一个副本组
Summary of the ER Command
Use the ER command to issue standard Extract and Replicat commands to multiple
Extract and Replicat groups as a unit. See "ER" for how to use this command.
使用ER命令向多个服务器发出标准提取和复制命令
提取和复制组作为一个单元。有关如何使用此命令,请参阅“ER”。
Command Description
INFO ER * Returns information about the specified wildcarded groups.
返回有关指定的通配符组的信息。
KILL ER * Forcibly terminates the specified wildcarded groups.
强制终止指定的通配符组。
LAG ER * Returns lag information about the specified wildcarded groups
返回有关指定通配符组的滞后信息
SEND ER * Sends instructions to, or returns information about, the
specified wildcarded groups.
方法发送指令或返回有关的信息通配符指定组。
START ER * Starts the specified wildcarded groups.
启动指定的通配符组。
STATS ER * Returns processing statistics for the specified wildcarded
groups.
返回处理指定通配符的统计信息组。
STATUS ER * Returns the state of the specified wildcarded groups.
返回指定的通配符组的状态。
STOP ER * Stops the specified wildcarded groups.
停止指定的通配符组。
Summary of Wallet Commands
Use the wallet commands to manage the master-key wallet that stores Oracle GoldenGate
master encryptions keys, and to add master keys to this wallet.
使用wallet命令管理存储Oracle GoldenGate的主键钱包
主加密密钥,并添加主密钥到这个钱包。
Command Description
CREATE WALLET Creates a wallet that stores master encryption keys.
创建存储主加密密钥的钱包。
OPEN WALLET Opens a master-key wallet.
打开主钥匙钱包。
PURGE WALLET Permanently removes from a wallet the master keys that are
marked as deleted.
从钱包中永久删除主键标记为删除。
ADD MASTERKEY Adds a master key to a master-key wallet.
将主密钥添加到主密钥钱包中。
INFO MASTERKEY Returns information about master keys.
返回有关主键的信息。
RENEW MASTERKEY Adds a new version of a master key.
添加主键的新版本。
DELETE MASTERKEY Marks a master key for deletion.
将主键标记为删除。
UNDELETE MASTERKEY Changes the state of a master key from being marked as deleted
to marked as available.
将主键的状态从标记为已删除改为标记为可用。
Summary of Credential Store Commands
Use the credential store commands to manage an Oracle GoldenGate credential store and
to add credentials to the credential store.
使用凭据存储命令来管理Oracle GoldenGate凭据存储和
将凭据添加到凭据存储区。
Command Description
ADD CREDENTIALSTORE Creates a credentials store (wallet) that stores encrypted
database user credentials.
创建存储加密数据库用户凭据的凭据存储(钱包)。
ALTER CREDENTIALSTORE Changes the contents of a credentials store.
更改凭据存储区的内容。
INFO CREDENTIALSTORE Returns information about a credentials store.
返回关于凭据存储的信息。
DELETE CREDENTIALSTORE Deletes the wallet that serves as a credentials store.
删除充当凭据存储的钱包。
Summary of Trail Commands
Use the trail commands to create and manage Oracle GoldenGate trails. A trail is a series
of files in which Oracle GoldenGate temporarily stores extracted data on disk until it has
been applied to the target location.
使用trail命令创建和管理Oracle GoldenGate trail。踪迹是一系列的
在这些文件中,Oracle GoldenGate暂时将提取的数据存储在磁盘上,直到它存储完
已应用于目标位置。
Command Description
ADD EXTTRAIL Adds a local trail to the Oracle GoldenGate configuration.
添加到Oracle GoldenGate配置的本地跟踪。
ADD RMTTRAIL Adds a remote trail to the Oracle GoldenGate configuration.
添加到Oracle GoldenGate配置的远程跟踪。
ALTER EXTTRAIL Changes attributes of a local trail.
更改本地路径的属性。
ALTER RMTTRAIL Changes attributes of a remote trail.
更改远程跟踪的属性。
DELETE EXTTRAIL Removes a local trail from the Oracle GoldenGate configuration.
从Oracle GoldenGate配置中移除本地踪迹。
DELETE RMTTRAIL Removes a remote trail from the Oracle GoldenGate configuration.
从Oracle GoldenGate配置中删除远程跟踪。
INFO EXTTRAIL Returns information about a local trail.
返回关于本地路径的信息。
INFO RMTTRAIL Returns information about a remote trail.
返回关于远程跟踪的信息。
Summary of Parameter Commands
Use the parameter commands to view and manage Oracle GoldenGate parameter files.
See Administering Oracle GoldenGate for more information about how to work with parameter
files.
使用参数命令查看和管理Oracle GoldenGate参数文件。
有关如何使用参数的更多信息,请参见管理Oracle GoldenGate
文件。
Command Description
EDIT PARAMS Opens a parameter file for editing in the default text editor.
在默认文本编辑器中打开用于编辑的参数文件。
SET EDITOR Sets the default text editor program for editing parameter files.
设置用于编辑参数文件的默认文本编辑器程序。
VIEW PARAMS Displays the contents of a parameter file in read-only mode on-screen.
在屏幕上以只读模式显示参数文件的内容。
INFO PARAM Returns parameter definition information.
返回参数定义信息。
Summary of Database Commands
Use the database commands to interact with the database from GGSCI.
使用数据库命令与GGSCI中的数据库进行交互。
Command Description
DBLOGIN Logs the GGSCI session into a database so that other commands that
affect the database can be issued.
将GGSCI会话记录到数据库中,以便可以发出其他影响数据库的命令。
DUMPDDL Shows the data in the Oracle GoldenGate DDL history table.
显示Oracle GoldenGate DDL历史表中的数据。
ENCRYPT PASSWORD Encrypts a database login password.
加密数据库登录密码。
FLUSH SEQUENCE Updates an Oracle sequence so that initial redo records are
available at the time that Extract starts capturing transaction
data after the instantiation of the replication environment.
更新Oracle序列,以便在提取开始捕获复制环境实例化后的事务数据时可以使用初始重做记录。
LIST TABLES Lists the tables in the database with names that match the input specification.
列出数据库中名称与输入规范匹配的表。
MININGDBLOGIN Specifies the credentials of the user that an Oracle GoldenGate process
uses to log into an Oracle mining database.
指定Oracle GoldenGate进程用于登录到Oracle挖掘数据库的用户的凭据。
SET NAMECCSID Sets the CCSID of the GGSCI session in a DB2 for i environment.
在DB2 for i环境中设置GGSCI会话的CCSID。
Summary of Trandata Commands
Use trandata commands to configure the appropriate database components to provide the
transaction information that Oracle GoldenGate needs to replicate source data operations.
使用trandata命令配置适当的数据库组件,以提供Oracle GoldenGate复制源数据操作所需的事务信息。
Command Description
ADD SCHEMATRANDATA Enables schema-level supplemental logging.
启用模式级补充日志记录。
ADD TRANDATA Enables table-level supplemental logging.
启用表级辅助日志记录。
DELETE SCHEMATRANDATA Disables schema-level supplemental logging.
禁用模式级补充日志记录。
DELETE TRANDATA Disables table-level supplemental logging.
禁用表级补充日志记录。
INFO SCHEMATRANDATA Returns information about the state of schema-level
supplemental logging.
返回关于模式级补充日志记录状态的信息。
INFO TRANDATA Returns information about the state of table-level supplemental
logging.
返回有关表级补充的状态的信息 日志记录。
SET_INSTANTIATION_CSN Sets whether and how table instantiation CSN filtering is used.
设置是否使用表实例化CSN过滤以及如何使用。
CLEAR_INSTANTIATION_CSN Clears table instantiation CSN filtering.
清除表实例化CSN筛选。
Summary of Checkpoint Table Commands
Use the checkpoint table commands to manage the checkpoint table that is used by Oracle
GoldenGate to track the current position of Replicat in the trail.
For more information about checkpoints and using a checkpoint table,
see Administering Oracle GoldenGate.
使用检查点表命令来管理Oracle使用的检查点表
GoldenGate跟踪当前的位置复制在踪迹。
有关检查点和使用检查点表的更多信息,
参见管理Oracle GoldenGate。
Command Description
ADD CHECKPOINTTABLE Creates a checkpoint table in a database.
在数据库中创建检查点表。
CLEANUP CHECKPOINTTABLE Removes checkpoint records that are no longer needed.
删除不再需要的检查点记录。
DELETE CHECKPOINTTABLE Removes a checkpoint table from a database.
从数据库中删除检查点表。
INFO CHECKPOINTTABLE Returns information about a checkpoint table.
返回关于检查点表的信息。
UPGRADE CHECKPOINTTABLE Adds a supplemental checkpoint table when upgrading Oracle
GoldenGate from version 11.2.1.0.0 or earlier.
从版本11.2.1.0.0或更早升级Oracle GoldenGate时添加一个补充检查点表。
Summary of Oracle Trace Table Commands
Use the trace table commands to manage the Oracle GoldenGate trace table that is used
with bidirectional synchronization of Oracle databases. Replicat generates an operation
in the trace table at the start of each transaction. Extract ignores all transactions
that begin with an operation to the trace table. Ignoring Replicat's operations
prevents data from looping back and forth between the source and target tables.
For more information about bidirectional synchronization, see Administering
Oracle GoldenGate for Windows and UNIX
使用跟踪表命令来管理使用的Oracle GoldenGate跟踪表
与Oracle数据库的双向同步。Replicat生成一个操作
在每个事务开始时的跟踪表中。Extract忽略所有事务
以对跟踪表的操作开始。忽略Replicat的业务
防止数据在源表和目标表之间来回循环。
有关双向同步的更多信息,请参见管理
用于Windows和UNIX的Oracle GoldenGate
Command Description
ADD TRACETABLE Creates a trace table.
创建一个跟踪表。
DELETE TRACETABLE Removes a trace table.
删除跟踪表。
INFO TRACETABLE Returns information about a trace table.
返回关于跟踪表的信息。
Summary of Oracle GoldenGate Monitor JAgent Commands
Use the JAgent commands to control the Oracle GoldenGate Monitor JAgent.
使用JAgent命令控制Oracle GoldenGate Monitor JAgent。
Command Description
INFO JAGENT Returns information about the JAgent.
返回关于JAgent的信息。
START JAGENT Starts the JAgent.
启动JAgent。
STATUS JAGENT Returns the state of the JAgent.
返回JAgent的状态。
STOP JAGENT Stops the JAgent.
停止JAgent。
Summary of PMSRVR COMMANDS
Use the PMSRVR commands to control the Performance Metrics Server process. The
Performance Metrics Server uses the metrics service to collect and store
instance deployment performance results.
使用PMSRVR命令控制性能指标服务器进程。Performance Metrics服务器使用Metrics服务收集和存储实例部署性能结果。
Command Description
INFO PMSRVR Returns information about the PMSRVR.
返回关于PMSRVR的信息。
START PMSRVR Starts the PMSRVR.
开始虚拟现实
STATUS PMSRVR Returns the state of the PMSRVR.
返回PMSRVR的状态。
STOP PMSRVR Stops the PMSRVR.
Summary of Oracle GoldenGate Automatic Heartbeat Commands
Use the heartbeat table commands to control the Oracle GoldenGate automatic
heartbeat functionality.
使用心跳表命令控制Oracle GoldenGate自动心跳功能。
Command Description
ADD HEARTBEATTABLE Creates the objects required for automatic heartbeat functionality.
创建自动心跳功能所需的对象。
ALTER HEARTBEATTABLE Alters existing heartbeat objects.
更改现有心跳对象。
DELETE HEARTBEATTABLE Deletes existing heartbeat objects.
删除现有心跳对象。
DELETE HEARTBEATENTRY Deletes entries in the heartbeat table.
删除心跳表中的条目。
INFO HEARTBEATTABLE Displays heartbeat table information.
显示心跳表信息。
Summary of Procedural Replication Commands
Use the following commands to enable, delete or retrieve information about procedures
that have supplemental logging turned on.
使用以下命令来启用、删除或检索有关已打开辅助日志记录的过程的信息。
Command Description
ADD PROCEDURETRANDATA Adding supplemental logging for Procedural Replication.
为过程性复制添加补充日志记录。
DELETE PROCEDURETRANDATA Remove supplemental logging for Procedural Replication.
删除用于过程复制的补充日志记录。
INFO PROCEDURETRANDATA Display display supplemental logging information about Procedural Replication.
显示有关过程复制的补充日志记录信息。
Summary of Miscellaneous Oracle GoldenGate Commands
Use the following commands to control various other aspects of Oracle GoldenGate.
使用以下命令控制Oracle GoldenGate的其他各个方面。
Command Description
! Executes a previous GGSCI command without modifications.
执行先前的GGSCI命令而不做任何修改。
ALLOWNESTED | NOALLOWNESTED Enables or disables the use of nested OBEY files.
启用或禁用嵌套的遵从文件。
CREATE SUBDIRS Creates the default directories within the Oracle GoldenGate home directory.
在Oracle GoldenGate主目录中创建默认目录。
DEFAULTJOURNAL Sets a default journal for multiple tables or files for the ADD
TRANDATA command when used for a DB2 for i database.
在用于DB2 for i数据库时,为ADD TRANDATA命令的多个表或文件设置默认日志。
FC Allows the modification and re-execution of a previously issued
Provides assistance with syntax and usage of GGSCI commands.
允许修改和重新执行以前发布的命令,为GGSCI命令的语法和使用提供了帮助。
HISTORY Shows a list of the most recently issued commands since the
startup of the GGSCI session.
显示自启动GGSCI会话以来最新发布的命令列表。
INFO ALL Displays status and lag for all Oracle GoldenGate processes on
a system.
显示系统上所有Oracle GoldenGate进程的状态和延迟。
OBEY Processes a file that contains a list of Oracle GoldenGate commands.
处理包含Oracle GoldenGate命令列表的文件。
SHELL Executes shell commands from within the GGSCI interface.
在GGSCI接口中执行shell命令。
SHOW Displays the attributes of the Oracle GoldenGate environment.
显示Oracle GoldenGate环境的属性。
VERSIONS Displays information about the operating system and database.
显示有关操作系统和数据库的信息。
VIEW GGSEVT Displays the Oracle GoldenGate error log (ggserr.logfile).
显示Oracle GoldenGate错误日志(ggserr.logfile)。
VIEW REPORT Displays the process report or the discard file that is generated
by Extract or Replicat.
显示由Extract或Replicat生成的进程报告或丢弃文件。
For help on a specific command, type HELP <command> <object>.
Example: HELP ADD REPLICAT