在上篇GG 单向复制的示例中,有配置Manager process,这篇具体来看一下Manager Process 的配置。
Oracle Golden Gate 系列六 --11gR2 Ora2Ora 单向复制GG 示例
http://blog.csdn.net/tianlesoftware/article/details/6950018
一.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_number>
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 waits to assign a port that was assigned before.
--控制Manager 等待分配端口的时间。
(4)AUTOSTART: Starts Extract andReplicat processes when Manager starts. This can be useful, for example, if youwant Oracle GoldenGate activities to begin immediately when you start thesystem, assuming Manager is part of the startup routine. You can use multiple AUTOSTARTstatements in the same parameter file.
--在Manager 启动时,自动启动Extract和replicat进程。 这是一个有用的命令,可以将Manager 添加到stratup routine里,这样Manager启动之后,Extrace 和Replicat 也就可以自动启动了。
(5)AUTORESTART: Starts Extract andReplicat processes again after abnormal termination.
--当Extract 和Replicat 进程异常中断后自动启动。
(6)PURGEOLDEXTRACTS: Purges trailfiles when Oracle GoldenGate has finished processing them. Without using PURGEOLDEXTRACTS,no purging is performed, and trail files can consume significant diskspace.Using PURGEOLDEXTRACTS as a Manager parameter is preferred over using theExtract or Replicat version of PURGEOLDEXTRACTS.
--当trail file 处理完后purge它们,如果没有指定该参数,trail file 会占用大量的磁盘空间。 Manager 的PURGEOLDEXTRACTS参数优先级比Extrace 和Replicat 的PURGEOLDEXTRACTS高。 即会先使用Manager的该参数。
NOTE:
When using PURGEOLDEXTRACTS,do not permit trail files to be deleted by any user or program other than OracleGoldenGate. It will cause PURGEOLDEXTRACTS to function improperly.
注意,如果使用PURGEOLDEXTRACTS,那么不允许出GG之外的用户和程序删除trail files 文件。 否则会导致PURGEOLDEXTRACTS异常。
四.Starting Manager
Manager must berunning before you start other Oracle GoldenGate processes. You can startManager from:
--Manager 必须先与GG 进程启动
(1)The command line of any supportedoperating system
(2)GGSCI
(3)The Services applet on aWindows system if Manager is installed as a service. See the Windowsdocumentation or your system administrator.
(4)The Cluster Administrator toolif the system is part of a Windows cluster. This is the recommended way tobring the Manager resource online. See the cluster documentation or your systemadministrator.
(5)The cluster software of a UNIXor Linux cluster. Refer to the documentation provided by the cluster vendor todetermine whether to start Manager from the cluster or by using GGSCI or thecommand line of the operating system.
4.1 To start Manager from the command line
To run Managerfrom the command shell of the operating system, use the following syntax.
mgr paramfile<param file> [reportfile <report file>]
The reportfile argumentis optional and can be used to store the Manager process report in a locationother than the default of the dirrpt directory in the Oracle GoldenGateinstallation location.
4.2 To start Manager from GGSCI
1. From the Oracle GoldenGate directory,run GGSCI.
2. In GGSCI, issue the following command.
START MANAGER
On Windows systems, you can use the BOOTDELAYMINUTES parameter to specify how long aftersystem boot time Manager delays until it starts its processing activities.
NOTE:
When startingManager from the command line or GGSCI on Windows Server2008 with User Account Control enabled, you will receive a UAC prompt requestingyou to allow or deny the program to run.
五.Stopping Manager
Manager runsindefinitely or until stopped by a user. In general, Manager should remain runningwhen there are synchronization activities being performed. Manager performs importantmonitoring and maintenance functions, and processes cannot be started unless Manageris running.
--在停Manager 之前,需要先停GG 进程,因为Manager负责监控和维护其他的进程。
To stop Manager
(1)On UNIX, Linux, and z/OS usingUSS, Manager must be stopped by using the STOP MANAGER command in GGSCI.
STOP MANAGER [!]
Where: ! stops Manager without userconfirmation.
--这里可选的!表示不经过用户确认直接stop
(2)On Windows, if Manager isinstalled as a service, you can stop it from the Services applet. See theWindows documentation or your system administrator.
(3)In a Windows cluster, Managermust only be stopped by taking the Manager resource offline by using theCluster Administrator. If you attempt to stop the Manager service from theGGSCI interface, the cluster monitor interprets it as a resource failure and willattempt to bring the resource online again. If a stop request is repeatedly submittedfrom the GGSCI interface, and the restart threshold of the Manager cluster resourceis exceeded, the cluster monitor marks the Manager resource as failed.
(4)In a UNIX or Linux cluster,refer to the documentation provided by the cluster vendor to determine whetherManager should be stopped from the cluster or by using GGSCI.
-------------------------------------------------------------------------------------------------------
版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!
Blog: http://blog.csdn.net/tianlesoftware
Weibo: http://weibo.com/tianlesoftware
Email: tianlesoftware@gmail.com
Skype: tianlesoftware
-------加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请----
DBA1 群:62697716(满); DBA2 群:62697977(满)DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群:83829929(满) DBA5群: 142216823(满)
DBA6 群:158654907(满) DBA7 群:69087192(满)DBA8 群:172855474
DBA 超级群2:151508914 DBA9群:102954821 聊天 群:40132017(满)
分享到:
相关推荐
Oracle Golden Gate软件是一种基于日志的结构化数据复制备份软件,它通过解析源数据库在线日志或归档日志获得数据的增量变化,再将这些变化应用到目标数据库,从而实现源数据库与目标数据库同步。Oracle Golden Gate...
这包括安装了Oracle数据库服务器、Golden Gate软件,并配置好相应的操作系统权限和网络连接。 2. **创建数据库对象**: 在源数据库和目标数据库中,你需要创建必要的表空间、用户和角色,以便Golden Gate可以存储...
Oracle Golden Gate是Oracle公司推出的一款高级复制技术产品,它支持异构平台之间的数据复制,即可以在不同的数据库平台之间进行数据同步。这款产品是Oracle推崇的高可用性解决方案之一,特别适用于需要数据实时复制...
### IBM CDC 与 Oracle Golden Gate 比较 #### 一、概述 本文将详细介绍IBM CDC(Change Data Capture)与Oracle Golden Gate之间的区别与特点,旨在帮助读者更好地理解这两种增量数据捕获技术,并根据实际需求...
Oracle GoldenGate是甲骨文...它的安装和配置涉及到一系列的步骤,并且具有很高的灵活性和可靠性。但是,为了确保使用Oracle GoldenGate时的合规性和安全性,用户应当仔细阅读并遵守Oracle提供的官方文档和许可协议。
Oracle Golden Gate软件是一种基于日志的结构化数据复制备份软件,它通过解析源数据库在线日志或归档日志获得数据的增量变化,再将这些变化应用到目标数据库,从而实现源数据库与目标数据库同步,以后可能是oracle...
以上内容是对Oracle Golden Gate的基本介绍和关键知识点的概括,实际使用时还需要结合具体的业务需求和技术环境进行详细配置和优化。对于想要深入学习Oracle Golden Gate的读者,可以参考提供的"Oracle Golden Gate...
在描述中提到的 "oracle-xe-11.2.0-1.0.x86_64.rpm" 文件,是一个针对 x86_64(64位)架构的 RPM 包,这是 Red Hat Package Manager (RPM) 的一种软件包格式,广泛用于 Linux 发行版如 CentOS 和 Fedora 中。...
此文档包含了 Oracle Golden Gate 从Windows下Oracle同步到Linux下的Kafka的部署说明。
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm --基础包,为了运行OCI、OCCI、JDBC-OCI 这几个应用程序; oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm --补充包/文件,是为了运行sql*plus...
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm --基础包,为了运行OCI、OCCI、JDBC-OCI 这几个应用程序; oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm --补充包/文件,是为了运行sql*plus...
总结来说,"oracle-rdbms-server-11gR2-preinstall"工具是Oracle Linux 6环境下安装Oracle 11g R2数据库的一个强大助手,它简化了环境准备步骤,提高了安装效率,同时也降低了由于手动配置错误导致的问题。...
总的来说,"oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm"是一个用于64位Linux系统的Oracle Instant Client版本,包含了连接Oracle数据库所需的最小组件,如oci接口、sqlplus工具以及tns配置。...
oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm --基础包,为了运行OCI、OCCI、JDBC-OCI 这几个应用程序; oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm --补充包/文件,是为了运行sql*plus...
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-basiclite-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-jdbc-...