OS:Oracle Linux 6.6 x64,Windows Server 2008 R2 x64
DB:Oracle 12.1.2.0
参考: 使用GI Agent(XAG)实现GoldenGate的高可用性(一)
一、XAG
从11.2.0.3以后,XAG作为GI安装的一部分,无需额外安装。但XAG的新版本需独立安装。
综上,建议安装新版本XAG。
下载页:http://oracle.com/goto/clusterware
解压到任意目录,在其中一个节点以grid用户执行安装:
在所有节点为grid设置环境变量XAG_HOME,并把$XAG_HOM/binE加入PATH,置于$ORACLE_HOME/bin之前。
可以确认XAG版本:
二、ACFS
详见: 12c ASM中创建ACFS
三、安装GoldenGate
在ACFS上安装GoldenGate。只需在一个节点上操作。安装完成后在所有节点配置相关变量。
四、配置GoldenGate的VIP和Agent
首先,以root用户新建一个VIP
以root用户运行,使oracle用户能够管理VIP。
接下来可以用oracle用户启动VIP:
查看结果:
创建GoldenGate的Agent,以GoldenGate的所有者oracle用户运行:
注意databases参数的写法。
接下来查看资源:
五、配置GoldenGate
参考: 12c多租户架构下部署GoldenGate 12c
六、测试
当前状态
尝试切换到node1
当前状态变为:
同时也要登录ggsci,确认GoldenGate进程状态:
如果是意外中断一个节点(断电),GoldenGate在另一节点上的恢复并不理想。具体表现为:
1)Manager, Extract进程能自动启动;
2)Pump进程自启动失败,出现报错:
3)在手动启动Pump进程后,恢复正常,日志输出如下:
接上继续,鉴于以上情况,务必在Manager进程中加上AUTORESTART参数。但最好还是要人工登录查看状态。
DB:Oracle 12.1.2.0
参考: 使用GI Agent(XAG)实现GoldenGate的高可用性(一)
一、XAG
从11.2.0.3以后,XAG作为GI安装的一部分,无需额外安装。但XAG的新版本需独立安装。
综上,建议安装新版本XAG。
下载页:http://oracle.com/goto/clusterware
解压到任意目录,在其中一个节点以grid用户执行安装:
点击(此处)折叠或打开
- ./xagsetup.sh --install --directory /u01/xag_v7 --all_nodes
- Installing Oracle Grid Infrastructure Agents on: node1
- Installing Oracle Grid Infrastructure Agents on: node2
- Done.
可以确认XAG版本:
点击(此处)折叠或打开
- $ agctl query releaseversion
- The Oracle Grid Infrastructure Agents release version is 7.1.0
二、ACFS
详见: 12c ASM中创建ACFS
三、安装GoldenGate
在ACFS上安装GoldenGate。只需在一个节点上操作。安装完成后在所有节点配置相关变量。
四、配置GoldenGate的VIP和Agent
首先,以root用户新建一个VIP
点击(此处)折叠或打开
- /u01/app/12.1.0/grid/bin/appvipcfg create \
- -network=1 \
- -ip=192.168.6.99 \
- -vipname=xag.ggs_1-vip.vip \
- -user=oracle
点击(此处)折叠或打开
- /u01/app/12.1.0/grid/bin/crsctl setperm resource xag.ggs_1-vip.vip -u user:oracle:r-x
点击(此处)折叠或打开
- /u01/app/12.1.0/grid/bin/crsctl start resource xag.ggs_1-vip.vip
点击(此处)折叠或打开
- /u01/app/12.1.0/grid/bin/crsctl status resource xag.ggs_1-vip.vip
- NAME=xag.ggs_1-vip.vip
- TYPE=app.appvipx.type
- TARGET=ONLINE
- STATE=ONLINE on node2
点击(此处)折叠或打开
- $XAG_HOME/bin/agctl add goldengate ggs_1 \
- --gg_home /u01/ggs_1 \
- --instance_type source \
- --nodes node1,node2 \
- --vip_name xag.ggs_1-vip.vip \
- --filesystems ora.acfs1.acfs1.acfs \
- --databases ora.racdb.db \
- --oracle_home /u01/app/oracle/product/12.1.0/db_1 \
- --monitor_extracts ext1,pmp1
接下来查看资源:
点击(此处)折叠或打开
- crsctl status resource xag.ggs_1.goldengate -f
参考: 12c多租户架构下部署GoldenGate 12c
六、测试
当前状态
点击(此处)折叠或打开
- crsctl stat res -t
-
- xag.ggs_1-vip.vip
- 1 ONLINE ONLINE node2 STABLE
- xag.ggs_1.goldengate
- 1 ONLINE ONLINE node2 STABLE
点击(此处)折叠或打开
- agctl relocate goldengate ggs_1 --node node1
点击(此处)折叠或打开
- xag.ggs_1-vip.vip
- 1 ONLINE ONLINE node1 STABLE
- xag.ggs_1.goldengate
- 1 ONLINE ONLINE node1 STABLE
点击(此处)折叠或打开
- > info all
-
- Program Status Group Lag at Chkpt Time Since Chkpt
-
- MANAGER RUNNING
- EXTRACT RUNNING EXT1 00:02:34 00:00:02
- EXTRACT RUNNING PMP1 00:00:00 00:00:10
1)Manager, Extract进程能自动启动;
2)Pump进程自启动失败,出现报错:
点击(此处)折叠或打开
- ERROR OGG-06601 Oracle GoldenGate Capture for Oracle, pmp1.prm: Mismatch between the length of seqno from checkpoint (9) and recovery (6) for extract trail E:\ggs_1\dirdat\rt.
点击(此处)折叠或打开
- 2016-07-11 17:04:47 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, pmp1.prm: EXTRACT PMP1 started.
- 2016-07-11 17:05:12 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
- 2016-07-11 17:05:16 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, pmp1.prm: Socket buffer size set to 27985 (flush size
- 27985).
- 2016-07-11 17:05:16 INFO OGG-01055 Oracle GoldenGate Capture for Oracle, pmp1.prm: Recovery initialization completed for target file E:\ggs_1\dirdat\rt000000006, at RBA 1505.
- 2016-07-11 17:05:16 INFO OGG-01055 Oracle GoldenGate Capture for Oracle, pmp1.prm: Recovery initialization completed for target file E:\ggs_1\dirdat\st000000007, at RBA 1505.
- 2016-07-11 17:05:16 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, pmp1.prm: Output file E:\ggs_1\dirdat\rt is using format RELEASE 12.2.
- 2016-07-11 17:05:17 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, pmp1.prm: Output file E:\ggs_1\dirdat\st is using format RELEASE 12.2.
- 2016-07-11 17:05:18 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, pmp1.prm: Rolling over remote file E:\ggs_1\dirdat\rt000000007.
- 2016-07-11 17:05:19 INFO OGG-01053 Oracle GoldenGate Capture for Oracle, pmp1.prm: Recovery completed for target file E:\ggs_1\dirdat\rt000000007, at RBA 807.
- 2016-07-11 17:05:19 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, pmp1.prm: Rolling over remote file E:\ggs_1\dirdat\st000000008.
- 2016-07-11 17:05:19 INFO OGG-01053 Oracle GoldenGate Capture for Oracle, pmp1.prm: Recovery completed for target file E:\ggs_1\dirdat\st000000008, at RBA 807.
- 2016-07-11 17:05:19 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, pmp1.prm: Recovery completed for all targets.
- 2016-07-11 17:05:21 INFO OGG-02243 Oracle GoldenGate Capture for Oracle, pmp1.prm: Opened trail file /u01/ggs_1/dirdat/lt000000004 at 2016-07-11 17:05:21.173524.
- 2016-07-11 17:05:21 INFO OGG-02232 Oracle GoldenGate Capture for Oracle, pmp1.prm: Switching to next trail file /u01/ggs_1/dirdat/lt000000005 at 2016-07-11 17:05:21.639963 due to EOF. with current RBA 1,463.
- 2016-07-11 17:05:21 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, pmp1.prm: Rolling over remote file E:\ggs_1\dirdat\rt000000008.
- 2016-07-11 17:05:22 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, pmp1.prm: Rolling over remote file E:\ggs_1\dirdat\st000000009.
接上继续,鉴于以上情况,务必在Manager进程中加上AUTORESTART参数。但最好还是要人工登录查看状态。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22621861/viewspace-2121744/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22621861/viewspace-2121744/