在本文中，介绍了rac环境下配置ogg的单向同步；在配置过程中，2节点的rac数据库做为source端，单实例的数据库作为target端，下面是具体的环境介绍!
source端：
操作系统版本：rhel5.4 64bit
数据库版本：11.2.0.3 64bit
ogg版本：fbo_ggs_Linux_x64_ora10g_64bit.tar
rac数据库名：rac.yang.com
public ip:192.168.1.41/24,192.168.1.42/24
private ip:192.168.122.41/24,192.168.122.42/24
vip:192.168.1.141/24,192.168.1.142/24
scan名：rac-scan.yang.com
scan-ip:192.168.1.144/24,192.168.1.145/24,192.168.1.146/24
target端：
数据库名：dg3.yang.com
ip:192.168.1.63/24
一：首先在两个rac节点上配置ASM动态注册,11g的监听器引入了endpoints_listener.ora文件管理
[grid@rac1 rac1]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac2,rac1
[grid@rac1 rac1]$ lsnrctl services
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 11-JUL-2012 21:09:20
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "rac.yang.com" has 1 instance(s).
Instance "rac1", status READY, has 1 handler(s) for this service...
Service "racXDB.yang.com" has 1 instance(s).
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: rac1.yang.com, pid: 5183>
(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.yang.com)(PORT=63054))
The command completed successfully
[grid@rac1 rac1]$ cat $TNS_ADMIN/listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
[grid@rac1 rac1]$ cat /u01/app/11.2.0/grid/network/admin/endpoints_listener.ora
LISTENER_RAC1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP) (HOST=192.168.1.41)(PORT=1521)(IP=FIRST)))) # line added by Agent
[grid@rac1 rac1]$ tail -8 $TNS_ADMIN/listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = +ASM)
(ORACLE_HOME=/u01/app/11.2.0/grid)
(SID_NAME = +ASM1)
)
)
[grid@rac2 ~]$ tail -8 $TNS_ADMIN/listener.ora
(SID_NAME = +ASM2)
[oracle@rac1 ~]$ sqlplus sys/[email protected]:1521/+ASM as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 11 21:31:30 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> show parameter name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string +ASM
instance_name string +ASM1
lock_name_space string
service_names string +ASM
SQL> conn sys/[email protected]:1521/+ASM as sysdba
Connected.
instance_name string +ASM2
[oracle@rac1 admin]$ cat tnsnames.ora //节点2的tnsnames.ora文件做相应的配置
RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac.yang.com)
)
)
ASM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.41)(PORT = 1521))
(SERVICE_NAME = +ASM)
(SID_NAME = +ASM1)
)
[root@rac1 ~]# ll -d /vol2/
drwxrwx--- 4 root asmadmin 4096 Jul 9 09:38 /vol2/
[root@rac1 ~]# id oracle
uid=501(oracle) gid=500(oinstall) groups=500(oinstall),502(asmdba),504(dba),505(oper)
[root@rac1 ~]# chown -R oracle.asmadmin /vol2/ （节点2做同样的操作）
drwxrwx--- 4 oracle asmadmin 4096 Jul 9 09:38 /vol2/
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ mkdir -p /vol2/ogg
[oracle@rac1 ogg]$ tar -xvf /home/oracle/fbo_ggs_Linux_x64_ora11g_64bit.tar
[oracle@rac1 ~]$ grep 'LD_LIBRARY_PATH' .bash_profile （节点2做同样的操作）
export LIBRARY_PATH=/vol2/ogg:$ORACLE_HOME/lib:$LD_LIBRARY_PATH
[oracle@rac1 ~]$ source .bash_profile
[oracle@rac1 ~]$ cd -
/vol2/ogg
[oracle@rac1 ogg]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (rac1.yang.com) > create subdirs
Creating subdirectories under current directory /vol2/ogg
Parameter files /vol2/ogg/dirprm: already exists
Report files /vol2/ogg/dirrpt: created
Checkpoint files /vol2/ogg/dirchk: created
Process status files /vol2/ogg/dirpcs: created
SQL script files /vol2/ogg/dirsql: created
Database definitions files /vol2/ogg/dirdef: created
Extract data files /vol2/ogg/dirdat: created
Temporary files /vol2/ogg/dirtmp: created
Stdout files /vol2/ogg/dirout: created
GGSCI (rac1.yang.com) > view params mgr
port 7809
autostart er *
autorestart er *
GGSCI (rac1.yang.com) > start mgr
Manager started.
GGSCI (rac1.yang.com) > info mgr
Manager is running (IP port rac1.yang.com.7809).
GGSCI (rac1.yang.com) > exit
[oracle@rac1 ogg]$ netstat -ntpl |grep 7809
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 :::7809 :::* LISTEN 10622/mgr
三：rac数据库上进行配置，创建用户，授权，运行执行序列号和ddl复制的相关脚本等
[oracle@rac1 ogg]$ sqlplus sys/123456@rac as sysdba
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
rac2
SQL> create user ogg identified by ogg;
User created.
SQL> grant connect,resource,dba to ogg;
Grant succeeded.
SQL> @sequence.sql
SQL> alter database add supplemental log data;
Database altered.
SQL> alter database add supplemental log data (primary key) columns;
SQL> alter database add supplemental log data (foreign key) columns;
SQL> alter database add supplemental log data (unique) columns;
SQL> alter system archive log current;
System altered.
SQL> grant execute on utl_file to ogg;
SQL> @marker_setup.sql
SQL> @ddl_setup.sql
SQL> @role_setup.sql
SQL> grant ggs_ggsuser_role to ogg;
SQL> @ddl_enable.sql
SQL> @ddl_pin ogg
四：在source端配置extract group
SQL> create user test identified by test;
SQL> grant connect,resource to test;
GGSCI (rac1.yang.com) > dblogin userid ogg,password ogg
Successfully logged into database.
GGSCI (rac1.yang.com) > add extract testext,tranlog,begin now,threads 2
EXTRACT added.
GGSCI (rac1.yang.com) > add exttrail /vol2/ogg/dirdat/et, extract testext
EXTTRAIL added.
GGSCI (rac1.yang.com) > view params testext
EXTRACT testext
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/db1")
USERID ogg@rac, PASSWORD ogg
TRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD 123456
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 20000
EXTTRAIL /vol2/ogg/dirdat/et
DYNAMICRESOLUTION
DDL INCLUDE ALL
TABLE test.*;
五：在source端配置data pump extract group
GGSCI (rac1.yang.com) > add extract testpump,exttrailsource /vol2/ogg/dirdat/et,begin now
GGSCI (rac1.yang.com) > add rmttrail /vol2/ogg/dirdat/rt,extract testpump
RMTTRAIL added.
GGSCI (rac1.yang.com) > view params testpump
EXTRACT testpump
RMTHOST 192.168.1.63, MGRPORT 7809
RMTTRAIL /vol2/ogg/dirdat/rt
PASSTHRU
TABLE test.*
六：target端配置，这里要保证在tnsnames.ora文件中配置了dg3连接串，同时建立/vol2/ogg/dirdat/rt目录，并授权；在这里未测试过target端和source使用不同的目录是否可行！
GGSCI (dg3.yang.com) > add replicat testrpt,exttrail /vol2/ogg/dirdat/rt,nodbcheckpoint
REPLICAT added.
GGSCI (dg3.yang.com) > view params testrpt
REPLICAT testrpt
USERID ogg@dg3,PASSWORD ogg
ASSUMETARGETDEFS
HANDLECOLLISIONS
REPERROR (DEFAULT, DISCARD)
DDLERROR DEFAULT DISCARD
DDLOPTIONS REPORT
DISCARDFILE /vol2/ogg/repsz.dsc,append,megabytes 100
MAP test.*, TARGET test.*;
七：启动各进程
GGSCI (rac1.yang.com) > start testext
Sending START request to MANAGER ...
EXTRACT TESTEXT starting
GGSCI (rac1.yang.com) > start testpump
EXTRACT TESTPUMP starting
GGSCI (rac1.yang.com) > info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING TESTEXT 00:00:00 00:19:49
EXTRACT RUNNING TESTPUMP 00:00:00 00:03:24
GGSCI (dg3.yang.com) > start testrpt
REPLICAT TESTRPT starting
GGSCI (dg3.yang.com) > info all
REPLICAT RUNNING TESTRPT 00:00:00 00:00:02
进程安排在最后启动，在启动source端的pump进程之前，如果target端的replicat进程未启动，则会报如下错误：
2012-07-15 13:56:14 ERROR OGG-01033 There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Remote file used is /vol2/ogg/dirdat/rt000000, reply received is Could not create /vol2/ogg/dirdat/rt000000).
八：测试同步情况
[oracle@rac1 ~]$ sqlplus test/test@rac
SQL*Plus: Release 11.2.0.3.0 Production on Sun Jul 15 14:11:52 2012
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
SQL> create table t1 (id number,name char(10));
Table created.
SQL> desc t1;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME CHAR(10)
SQL> insert into t1 values (1,'one');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from t1;
ID NAME
---------- ----------
1 one
[oracle@dg3 ~]$ sqlplus test/test@dg3
SQL*Plus: Release 11.2.0.3.0 Production on Sun Jul 15 14:12:31 2012
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
T1 TABLE
1 one
总结：rac环境下配置ogg，基本同单实例无异！重点需要注意的地方有以下几点!
1：使用ASM存储，需要先配置ASM实例的静态注册，同时在tnsnames.ora文件中配置连接串
2：在配置exttract进程中，注意需要配置TRANLOGOPTIONS 参数，输入连接asm实例的凭证
3：在配置exttract进程中，添加tranlog的时候，需要写thread 2
4: 注意进程的启动顺序，先是source和target端的mgr进程，其次是source端的extract进程，target端的replicat进程，最后是source端的extract pump进程
本文不包含source端的failover功能，后续将继续测试,敬请关注！
参考文章：(感谢作者分享！)
<a href="http://www.askmaclean.com/archives/11gr2-rac-add-listener-static-register.html">http://www.askmaclean.com/archives/11gr2-rac-add-listener-static-register.html</a>
<a href="http://www.rickyzhu.com/2299_goldengate-on-rac.html">http://www.rickyzhu.com/2299_goldengate-on-rac.html</a>
<a href="http://candon123.blog.51cto.com/704299/556239">http://candon123.blog.51cto.com/704299/556239</a>
本文转自斩月博客51CTO博客，原文链接http://blog.51cto.com/ylw6006/932308如需转载请自行联系原作者
ylw6006
![【MySQL数据库】数据库索引事务1.索引2.事务[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)