没有合适的资源?快使用搜索试试~ 我知道了~
首页oracle OGG 12.3使用手册
oracle OGG 12.3使用手册
需积分: 49 834 浏览量
更新于2023-03-16
评论 1
收藏 10.98MB PDF 举报
oracle 最新版本ogg 12.3使用手册 详细全面,包含各种参数的使用语法,原理,用途等。
资源详情
资源评论
资源推荐

[1]
Oracle® GoldenGate
Reference for Oracle GoldenGate for Windows and UNIX
12c (12.1.2)
E29392-08
May 2015
Contains instructions for using Oracle GoldenGate
commands, parameters, and functions.

Oracle GoldenGate Reference for Oracle GoldenGate for Windows and UNIX, 12c (12.1.2)
E29392-08
Copyright © 2013, 2015, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on
use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse
engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is
prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it
on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,
any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users
are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and
agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and
adaptation of the programs, including any operating system, integrated software, any programs installed on
the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to
the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management
applications. It is not developed or intended for use in any inherently dangerous applications, including
applications that may create a risk of personal injury. If you use this software or hardware in dangerous
applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other
measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages
caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of
their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks
are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD,
Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced
Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content,
products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and
expressly disclaim all warranties of any kind with respect to third-party content, products, and services
unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its
affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of
third-party content, products, or services, except as set forth in an applicable agreement between you and
Oracle.

iii
Contents
Preface ............................................................................................................................................................... xv
1 Oracle GoldenGate GGSCI Commands
1.1 Summary of Oracle GoldenGate Commands......................................................................... 1-1
1.1.1 Summary of Manager Commands.................................................................................... 1-1
1.1.2 Summary of Extract Commands ....................................................................................... 1-2
1.1.3 Summary of Replicat Commands ..................................................................................... 1-2
1.1.4 Summary of the ER Command.......................................................................................... 1-3
1.1.5 Summary of Wallet Commands ........................................................................................ 1-3
1.1.6 Summary of Credential Store Commands....................................................................... 1-4
1.1.7 Summary of Trail Commands ........................................................................................... 1-4
1.1.8 Summary of Parameter Commands.................................................................................. 1-4
1.1.9 Summary of Database Commands.................................................................................... 1-5
1.1.10 Summary of Trandata Commands.................................................................................... 1-5
1.1.11 Summary of Checkpoint Table Commands..................................................................... 1-5
1.1.12 Summary of Oracle Trace Table Commands................................................................... 1-6
1.1.13 Summary of Oracle GoldenGate Data Store Commands .............................................. 1-6
1.1.14 Summary of Oracle GoldenGate Monitor JAgent Commands ..................................... 1-6
1.1.15 Summary of Miscellaneous Oracle GoldenGate Commands........................................ 1-7
INFO MANAGER....................................................................................................................... 1-8
SEND MANAGER...................................................................................................................... 1-9
START MANAGER ................................................................................................................. 1-11
STATUS MANAGER............................................................................................................... 1-12
STOP MANAGER.................................................................................................................... 1-13
ADD EXTRACT........................................................................................................................ 1-14
ALTER EXTRACT.................................................................................................................... 1-22
CLEANUP EXTRACT ............................................................................................................. 1-26
DELETE EXTRACT.................................................................................................................. 1-27
INFO EXTRACT....................................................................................................................... 1-28
KILL EXTRACT........................................................................................................................ 1-31
LAG EXTRACT ........................................................................................................................ 1-32
REGISTER EXTRACT.............................................................................................................. 1-33
SEND EXTRACT...................................................................................................................... 1-37
START EXTRACT.................................................................................................................... 1-48

iv
STATS EXTRACT..................................................................................................................... 1-50
STATUS EXTRACT.................................................................................................................. 1-53
STOP EXTRACT....................................................................................................................... 1-54
UNREGISTER EXTRACT ....................................................................................................... 1-55
ADD REPLICAT ...................................................................................................................... 1-57
ALTER REPLICAT................................................................................................................... 1-61
CLEANUP REPLICAT............................................................................................................ 1-63
DELETE REPLICAT ................................................................................................................ 1-64
INFO REPLICAT...................................................................................................................... 1-65
KILL REPLICAT....................................................................................................................... 1-69
LAG REPLICAT ....................................................................................................................... 1-70
REGISTER REPLICAT............................................................................................................. 1-71
SEND REPLICAT..................................................................................................................... 1-72
START REPLICAT................................................................................................................... 1-78
STATS REPLICAT.................................................................................................................... 1-82
STATUS REPLICAT ................................................................................................................ 1-85
STOP REPLICAT...................................................................................................................... 1-86
SYNCHRONIZE REPLICAT.................................................................................................. 1-87
UNREGISTER REPLICAT...................................................................................................... 1-88
ER ............................................................................................................................................... 1-89
CREATE WALLET................................................................................................................... 1-90
OPEN WALLET ....................................................................................................................... 1-91
PURGE WALLET..................................................................................................................... 1-92
ADD MASTERKEY.................................................................................................................. 1-93
INFO MASTERKEY................................................................................................................. 1-94
RENEW MASTERKEY............................................................................................................ 1-95
DELETE MASTERKEY............................................................................................................ 1-96
UNDELETE MASTERKEY ..................................................................................................... 1-98
ADD CREDENTIALSTORE ................................................................................................... 1-99
ALTER CREDENTIALSTORE ............................................................................................. 1-100
INFO CREDENTIALSTORE ................................................................................................ 1-103
DELETE CREDENTIALSTORE ........................................................................................... 1-104
ADD EXTTRAIL..................................................................................................................... 1-105
ADD RMTTRAIL ................................................................................................................... 1-106
ALTER EXTTRAIL................................................................................................................. 1-107
ALTER RMTTRAIL ............................................................................................................... 1-108
DELETE EXTTRAIL............................................................................................................... 1-109
DELETE RMTTRAIL ............................................................................................................. 1-110
INFO EXTTRAIL.................................................................................................................... 1-111
INFO RMTTRAIL .................................................................................................................. 1-112
EDIT PARAMS....................................................................................................................... 1-113
SET EDITOR ........................................................................................................................... 1-114

v
VIEW PARAMS...................................................................................................................... 1-115
DBLOGIN................................................................................................................................ 1-116
ENCRYPT PASSWORD........................................................................................................ 1-120
DUMPDDL ............................................................................................................................. 1-122
FLUSH SEQUENCE .............................................................................................................. 1-124
LIST TABLES .......................................................................................................................... 1-125
MININGDBLOGIN ............................................................................................................... 1-126
SET NAMECCSID.................................................................................................................. 1-129
ADD SCHEMATRANDATA ............................................................................................... 1-130
ADD TRANDATA................................................................................................................. 1-133
DELETE SCHEMATRANDATA ......................................................................................... 1-138
DELETE TRANDATA........................................................................................................... 1-139
INFO SCHEMATRANDATA .............................................................................................. 1-140
INFO TRANDATA................................................................................................................ 1-141
ADD CHECKPOINTTABLE ................................................................................................ 1-142
CLEANUP CHECKPOINTTABLE...................................................................................... 1-144
DELETE CHECKPOINTTABLE .......................................................................................... 1-145
INFO CHECKPOINTTABLE ............................................................................................... 1-146
UPGRADE CHECKPOINTTABLE...................................................................................... 1-147
ADD TRACETABLE.............................................................................................................. 1-148
DELETE TRACETABLE........................................................................................................ 1-149
INFO TRACETABLE............................................................................................................. 1-150
ALTER DATASTORE............................................................................................................ 1-151
CREATE DATASTORE......................................................................................................... 1-152
DELETE DATASTORE.......................................................................................................... 1-153
INFO DATASTORE............................................................................................................... 1-154
REPAIR DATASTORE .......................................................................................................... 1-155
INFO JAGENT........................................................................................................................ 1-156
START JAGENT..................................................................................................................... 1-157
STATUS JAGENT .................................................................................................................. 1-158
STOP JAGENT........................................................................................................................ 1-159
! ................................................................................................................................................. 1-160
ALLOWNESTED | NOALLOWNESTED.......................................................................... 1-161
CREATE SUBDIRS................................................................................................................. 1-162
DEFAULTJOURNAL ............................................................................................................ 1-163
FC ............................................................................................................................................. 1-164
HELP........................................................................................................................................ 1-166
HISTORY................................................................................................................................. 1-167
INFO ALL ............................................................................................................................... 1-168
INFO MARKER...................................................................................................................... 1-169
OBEY........................................................................................................................................ 1-170
剩余809页未读,继续阅读












安全验证
文档复制为VIP权益,开通VIP直接复制

评论0