oldenGate 基本参数含义
1. edit params命令
2. DBLOGIN USERID , PASSWORD
3. ADD TRANDATA命令
4. ADD EXTRACT 命令
5. ADD EXTTRAIL命令
6. EXTFILESOURCE 意思
7. ADD RMTTRAIL命令
8. ADD REPLICAT命令
9. PURGEOLDEXTRACTS
10. AUTOSTART参数
11. DYNAMICRESOLUTION
12. SOURCEDB
13. PASSTHRU
14. ASSUMETARGETDEFS
15. REPERROR
16. 使用通配符
(1) Overview of Extract
The Extract process runs on the source system and is the capture mechanism of
GoldenGate. You can configure Extract in one of the following ways:
● Initial loads: For initial data loads, Extract extracts a current set of data directly from
their source objects.
● Change synchronization: To keep source data synchronized with another set of data,
Extract extracts transactional changes made to data (inserts, updates, and deletes)
after the initial synchronization has taken place. DDL changes and sequences are also
extracted, if supported for the type of database being used.
(2) Overview of Replicat
The Replicat process runs on the target system. Replicat reads extracted data changes and
DDL changes (if supported) that are specified in the Replicat configuration, and then it
replicates them to the target database. You can configure Replicat in one of the following
ways:
(3) Overview of trails
To support the continuous extraction and replication of supported database changes,
GoldenGate stores those changes temporarily on disk in a series of files called a trail. A
trail can exist on the source or target system, or on an intermediary system, depending on
how you configure GoldenGate. On the local system it is known as an extract trail (or local
trail). On a remote system it is known as a remote trail.
By using a trail for storage, GoldenGate supports data accuracy and fault tolerance (see
“Overview of checkpoints” on page 28). The use of a trail also allows extraction and
replication activities to occur independently of each other. With these processes separated,
you have more choices for how data is delivered. For example, instead of extracting and
replicating changes continuously, you could extract changes continuously but store them
in the trail for replication to the target later, whenever the target application needs them.
1. edit params命令
==================
Use EDIT PARAMS to create or change a parameter file. By default,
this command launches Microsoft Notepad on Windows or the vi editor
on UNIX systems. You can change the editor with the SET EDITOR
command.
Syntax:
EDIT PARAMS {MGR | | }
MGR
Opens a parameter file for the Manager process.
Opens a parameter file for the specified Extract or Replicat group.
Opens the specified file. Use the full path name.
Example 1: EDIT PARAMS finance
Example 2: EDIT PARAMS c:\lpparms\replp.prm
GGSCI (testdb11.zhyhl.com) 6>
PORT
PORT defines the port number on which Manager runs on the local system. The default port
is 7809. You must specify either the default port or another port. The port must be
unreserved and unrestricted. GGSCI uses this port to request Manager to start processes.
The Extract process uses this port to request Manager to start a remote Collector process
or an initial-load Replicat process. PORT is the only required Manager parameter.
Autostart parameters
Use the AUTOSTART parameter to start Extract and Replicat processes when Manager starts.
This can be useful, for example, if you want GoldenGate activities to begin immediately
when you start the system, assuming Manager is part of the startup routine. You can use
multiple AUTOSTART statements in the same parameter file.
AUTOSTART {ER | EXTRACT | REPLICAT} {group name | wildcard}
Use the AUTORESTART parameter to start Extract and Replicat processes again after
abnormal termination.
AUTORESTART {ER | EXTRACT | REPLICAT} {group name | wildcard}
[, RETRIES ]
[, WAITMINUTES ]
[, RESETMINUTES ]
2. DBLOGIN USERID , PASSWORD
=============================================
dblogin userid test,password test
DBLOGIN USERID , PASSWORD
Where: is a database user who has privilege to create triggers or enable tablelevel
supplemental logging, and is that user’s password.
3. ADD TRANDATA命令
===================
Use the ADD TRANDATA command in GGSCI to configure the database to log the key values
whenever it logs a row change, so that they are available to GoldenGate in the redo record.
By default, the database only logs column values that are changed.
ADD TRANDATA must be performed before you start GoldenGate processing.
add trandata test.*
To capture key values with ADD TRANDATA
ADD TRANDATA
START EXTRACT *X*
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27677524/viewspace-767314/，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
<%=items[i].createtime%>
<%=items[i].content%>
<%if(items[i].items.items.length) { %>
<%for(var j=0;j
<%}%> <%if(items[i].items.total > 5) { %>
<%}%> <%}%>
<%=items[i].items.items[j].createtime%>
回复
<%=items[i].items.items[j].username%> 回复 <%=items[i].items.items[j].tousername%>： <%=items[i].items.items[j].content%>
还有<%=items[i].items.total-5%>条评论
) data-count=1 data-flag=true>点击查看
<%}%>
北京盛拓优讯信息技术有限公司. 版权所有 京ICP备09055130号-4 北京市公安局海淀分局网监中心备案编号：11010802021510
广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员
转载于:http://blog.itpub.net/27677524/viewspace-767314/
164
到【灌水乐园】发言
