OGG_Manager 进程

最新推荐文章于 2022-12-15 13:51:08 发布

翔之天空

最新推荐文章于 2022-12-15 13:51:08 发布

阅读量3.8k

点赞数

分类专栏： Oracle 高可用及容灾

Oracle 高可用及容灾专栏收录该内容

14 篇文章 0 订阅

订阅专栏

友情提示：笔者英语很渣，阅读时建议保持极强的耐心，同时欢迎提出各种意见~~

本篇是Oracle GoldenGate官方文档(administrator’s guide)的第二章节Manager进程配置。

原文：
CHAPTER2

Configuring the Manager process

Overview of the Manager process

To configure and run Oracle GoldenGate, a Manager process must be running on the source and target systems. The Manager process performs the following functions:
● Start Oracle GoldenGate processes
● Start dynamic processes
● Perform trail management
● Create event, error, and threshold reports
There is one Manager for each Oracle GoldenGate installation. One Manager can support multiple Oracle GoldenGate extraction and replication processes.

Configuring Manager

To configure Manager, create a parameter file by following these steps. If you installed Oracle GoldenGate on a UNIX cluster, configure the Oracle GoldenGate Manager process within the cluster application as directed by the vendor’s documentation, so that Oracle GoldenGate will fail over properly with the other applications.
To configure Manager

From the Oracle GoldenGate directory, run the ggsci program to open the Oracle GoldenGate Software Command Interface, commonly known as GGSCI.
In GGSCI, issue the following command to edit the Manager parameter file.
EDIT PARAMS MGR
Add the following parameter to specify the Manager port number.
PORT port_number>
PORT defines the port number on which Manager runs on the local system. Observe these
guidelines:
● The default port number is 7809.
● You must specify either the default port number or a different one.
● Each Manager instance on a system must use a different port number.
● 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.
NOTE The port number also must be specified with the MGRPORT argument of the Extract parameter RMTHOST.
Enter any of the optional Manager parameters documented in the Oracle GoldenGate
Windows and UNIX Reference Guide, then save and close the file.

Recommended parameters

The following parameters are optional, but recommended for the Manager process. For more information and syntax, see the Windows and UNIX Reference Guide.
● USERID: Required if using Oracle GoldenGate DDL support, specify the Manager user and password with the .
● DYNAMICPORTLIST:Use to specify up to 256 unreserved, unrestricted ports for dynamic TCP/IP communications between the sourceand target systems. The Collector, Replicat, and GGSCI processes will use these ports. In the absence of DYNAMICPORTLIST, Manager tries to start Collector on port 7840. If 7840 is not available, Manager increments by one until it finds an available port.
● DYNAMICPORTREASSIGNDELAY: Controls how long Manager waits to assign a port that was assigned before.
● AUTOSTART: Starts Extract and Replicat processes when Manager starts. This can be useful, for example, if you want Oracle 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.
● AUTORESTART: Starts Extract and Replicat processes again after abnormal termination.
● PURGEOLDEXTRACTS: Purges trail files when Oracle GoldenGate has finished processing them. Without using
PURGEOLDEXTRACTS, no purging is performed, and trail files can
consume significant disk space.Using PURGEOLDEXTRACTS as a Manager parameter is preferred over using the Extract or Replicat version of PURGEOLDEXTRACTS.
NOTE When using PURGEOLDEXTRACTS, do not permit trail files to be deleted by any user or program other than Oracle GoldenGate. It will cause PURGEOLDEXTRACTS to function improperly.

译文：
第二章

配置Manager 进程

Manager进程概述

要配置和运行Oracle GoldenGate(OGG)，Manager(mgr)进程必须在源端和目标端都要安装部署。
mgr进程以下几个作用：
●启动OGG进程
●启动动态进程
●Trail文件的管理
●创建事件，错误和阀值的报告
在安装OGG时必须都要有一个mgr进程。一个mgr可以支持OGG的多个extraction(ext)进程和replication(rep)进程。

配置Manager

想要配置mgr进程，可以通过如下几步来创建一个参数文件。
配置Manager
1.在OGG安装的根目录里执行ggsci命令程序来打开OGG软件。
2.在GGSCI里执行EDIT PARAMS MGR 命令来编辑mgr参数文件。
3.添加一个指定的端口
PORT <端口号>
这个端口是本地系统的端口，规则如下：
●默认端口是7809。
●你必须指定默认端口或者另一个不同的端口。
●在一个系统中每个mgr必须使用不同的端口。
●这个端口必须不受限制，GGSCI使用这个端口去使mgr启动进程。Ext进程用这个端口去使mgr启动一个远程或者rep进程。
●端口是唯一必须指定的参数。
注释 Extract的MGRPORT参数也是这个端口号，RMTHOST参数是目标端的ip地址。
4. 可以看看OGG的Reference Guide里关于mgr参数的文档。

建议设定的参数

以下的参数都是可选择的，但建议还是设定一下比较好。如果想设定更多的参数请参照OGG的Reference Guide文档。
● USERID：如果要支持OGG的DDL，就要指定mgr的该用户的用户名和密码(在之前的实验中，mgr没有指定用户名和密码， ext和rep参数文件中指定了用户名和密码，实现了DDL操作)
● DYNAMICPORTLIST：在源端和目标端联系的动态端口，如果没有设定，mgr尝试着从7840端口开始启用，如果不可用，端口号就加1位直找到一个可用的为止。
● DYNAMICPORTREASSIGNDELAY：控制mgr等待分配端口的时间
● AUTOSTART：当mgr启动时，可以自动启动ext和rep进程。
● AUTORESTART：在ext和rep进程异常终止时自动启动。
● PURGEOLDEXTRACTS：可以清除OGG中已完成的Trail文件。如果没有设定此参数，就不会清除占用了大量磁盘空间的Trail文件了，mgr的PURGEOLDEXTRACTS参数比ext或者rep的PURGEOLDEXTRACTS优先级高。
注释如果使用了PURGEOLDEXTRACTS参数来删除Trail文件，那就不容许OGG之外的用户或者程序来删除Trail文件。