GoldenGate将Oracle数据同步到GreenPlum
hrbqiuyb 2014-06-07
源端
Oracle 11.2.0.4 RAC 2-Nodes
Oracle Linux 5.8 x86_64
Oracle GoldenGate V11.1.1.0.0 for Oracle 11g on Linux x86-64.zip
Oracle GoldenGate V11.1.1.0.0 For FlatFile on Linux 64-bit for OGG v11.1.1.0.0.zip
目标端
Greenplum Database 4.2.6.1 4-Nodes
CentOS 5.7 x86_64
Oracle GoldenGate V11.1.1.0.0 for Oracle 11g on Linux x86-64.zip
Oracle GoldenGate V11.1.1.0.0 For FlatFile on Linux 64-bit for OGG v11.1.1.0.0.zip
--------------------------------------分割线 --------------------------------------
--------------------------------------分割线 --------------------------------------
源端配置
--本例是将OGG安装在ACFS共享存储上，方便RAC节点故障OGG的切换
--ACFS信息
[root@vzwc1 ~]# acfsutil info fs
/ggs
ACFS Version: 11.2.0.4.0
flags: MountPoint,Available
mount time: Sat Feb 15 14:33:22 2014
volumes: 1
total size: 8589934592
total free: 8453541888
primary volume: /dev/asm/ggs-11
label:
flags: Primary,Available,ADVM
on-disk version: 39.0
allocation unit: 4096
major, minor: 252, 5633
size: 8589934592
free: 8453541888
ADVM diskgroup OGGDG
ADVM resize increment: 33554432
ADVM redundancy: mirror
ADVM stripe columns: 4
ADVM stripe width: 131072
number of snapshots: 0
snapshot space usage: 0
replication status: DISABLED
[root@vzwc1 ~]#
[root@vzwc1 ~]# df -Th
Filesystem Type Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
ext3 44G 15G 28G 35% /
/dev/sda1 ext3 99M 24M 71M 25% /boot
tmpfs tmpfs 1.5G 944M 564M 63% /dev/shm
/dev/asm/ggs-11
acfs 8.0G 131M 7.9G 2% /ggs
--源端RAC信息
[root@vzwc1 ~]# crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.4.0]
[root@vzwc1 ~]# crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.4.0]
[root@vzwc1 ~]# crsctl query crs softwareversion -all
Oracle Clusterware version on node [vzwc1] is [11.2.0.4.0]
Oracle Clusterware version on node [vzwc2] is [11.2.0.4.0]
[root@vzwc1 ~]#
[root@vzwc1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRSDG.dg
ONLINE ONLINE vzwc1
ONLINE ONLINE vzwc2
ora.DATADG.dg
ONLINE ONLINE vzwc1
ONLINE ONLINE vzwc2
ora.FRADG.dg
ONLINE ONLINE vzwc1
ONLINE ONLINE vzwc2
ora.LISTENER.lsnr
ONLINE ONLINE vzwc1
ONLINE ONLINE vzwc2
ora.OGGDG.dg
ONLINE ONLINE vzwc1
ONLINE ONLINE vzwc2
ora.SYSDG.dg
ONLINE ONLINE vzwc1
ONLINE ONLINE vzwc2
ora.asm
ONLINE ONLINE vzwc1 Started
ONLINE ONLINE vzwc2 Started
ora.gsd
OFFLINE OFFLINE vzwc1
OFFLINE OFFLINE vzwc2
ora.net1.network
ONLINE ONLINE vzwc1
ONLINE ONLINE vzwc2
ora.ons
ONLINE ONLINE vzwc1
ONLINE ONLINE vzwc2
ora.registry.acfs
ONLINE ONLINE vzwc1
ONLINE ONLINE vzwc2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE vzwc1
ora.cvu
1 ONLINE ONLINE vzwc1
ora.oc4j
1 ONLINE ONLINE vzwc1
ora.scan1.vip
1 ONLINE ONLINE vzwc1
ora.vzwc1.vip
1 ONLINE ONLINE vzwc1
ora.vzwc2.vip
1 ONLINE ONLINE vzwc2
ora.zwc.db
1 ONLINE ONLINE vzwc1 Open
2 ONLINE ONLINE vzwc2 Open
--配置oracle用户环境变量，添加OGG配置
[oracle@vzwc1 ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
alias ls="ls -FA"
GG_HOME=/ggs/ogg; export GG_HOME
ORACLE_SID=zwc1; export ORACLE_SID
ORACLE_UNQNAME=zwc; export ORACLE_UNQNAME
JAVA_HOME=/usr/local/java; export JAVA_HOME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_PATH=/u01/app/common/oracle/sql; export ORACLE_PATH
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$GG_HOME
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
PATH=${PATH}:/u01/app/common/oracle/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$GG_HOME
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export CLASSPATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
umask 022
alias sqlplus="rlwrap sqlplus"
alias rman="rlwrap rman"
