在上篇GG 单向复制的示例中,有配置Manager process,这篇具体来看一下Manager Process 的配置。
Oracle Golden Gate 系列六 --11gR2 Ora2Ora 单向复制GG 示例:http://www.2cto.com/database/201111/111285.html
一.Overview of the Manager process
To configure andrun Oracle GoldenGate, a Manager process must be running on the source andtarget systems. The Manager process performs the following functions:
要配置GG,必须先要在Source和 Target System上部署Manager Process。 该进程执行一下4个函数:
(1) Start Oracle GoldenGateprocesses
--启动GG 进程
(2) Start dynamic processes
--启动动态进程
(3) Perform trail management
--执行trail 管理
(4) Create event, error, andthreshold reports
--创建event,error和threshold报告
There is oneManager for each Oracle GoldenGate installation. One Manager can support multipleOracle GoldenGate extraction and replication processes.
--每个GG 都必须要有一个Manager Process,一个MP可以支持多个GGExtraction 和 Replication 进程。
二.Configuring Manager
To configureManager, create a parameter file by following these steps. If you installed OracleGoldenGate on a UNIX cluster, configure the Oracle GoldenGate Manager process withinthe cluster application as directed by the vendor’s documentation, so thatOracle GoldenGate will fail over properly with the other applications.
--配置Manager,只需要按照以下步骤创建一个参数文件。
To configure Manager
1. From the Oracle GoldenGatedirectory, run the ggsci program to open the Oracle GoldenGate Software CommandInterface, commonly known as GGSCI.
--在GG的根目录运行ggsci命令,因为这个命令会调用其他的命令,如果不是在根目录下执行,虽然在通过PATH变量也可以找到ggsci命令,但是会找不到其他的文件而报错。
2. In GGSCI, issue the following command toedit the Manager parameter file.
EDIT PARAMS MGR
--在ggsci里执行上述命令,编辑Manager 进程参数
3. Add the following parameter to specifythe Manager port number.
PORT
PORT defines theport number on which Manager runs on the local system.
--这个端口是本地OS 的端口
Observe these guidelines:
(1) The default port number is7809.
--默认端口是7809
(2) You must specify either thedefault port number or a different one.
--必须指定这个端口为默认端口或者其他端口
(3) Each Manager instance on asystem must use a different port number.
--每个Manager instance必须使用不同的端口
(4) The port must be unreserved andunrestricted. GGSCI uses this port to request Manager to start processes. TheExtract process uses this port to request Manager to start a remote Collectorprocess or an initial-load Replicat process.
--这个端口不能受限
(5) PORT is the only requiredManager parameter.
--端口是Manager 唯一必须指定的参数
NOTE:
The port numberalso must be specified with the MGRPORT argument of the Extract parameter RMTHOST.
--Extrace 的RMTHOST 也必须指定MGRPORT 端口
三.Recommended parameters
The followingparameters are optional, but recommended for the Manager process.
--第二节讲了Manager 必须指定的参数Port,这里讲了一些可选的参数。
(1) USERID: Required if usingOracle GoldenGate DDL support, specify the Manager user and password with the .
--如果使用DDL,需要创建一个用户来保存相关的table,这里指定该用户的用户名和密码
(2) DYNAMICPORTLIST: Use to specifyup to 256 unreserved, unrestricted ports for dynamic TCP/IP communicationsbetween the source and target systems. The Collector,Replicat, and GGSCIprocesses will use these ports. In the absence of DYNAMICPORTLIST, Managertries to start Collector on port 7840. If 7840 is not available, Manager incrementsby one until it finds an available port.
--动态的指定端口在source 和 targetsystems 进行交流。 默认情况下从7840 端口开始,如果该端口不可用,则端口数加1,知道找到一个可用的。
(3) DYNAMICPORTREASSIGNDELAY:Controls how long Manager