Oracle RAC到RAC配置OGG单向同步

原创

于 2022-01-16 21:01:25 发布 · 2k 阅读

10 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #centos #服务器 #ogg

CentOS6.8 Oracle 12.2.0.1 RAC到CentOS7.6 Oracle 19c RAC单向同步

/* OGG数据迁总体规划参考文档 */
https://cloud.tencent.com/developer/news/694510

一、创建共享目录

RAC环境下，OGG安装目录需要处于全部节点的共享目录下，可以使用ACFS或NFS。ACFS用于挂载一个共享目录(用于安装OGG软件)到2个节点，ACFS可以使用已经存在的磁盘组，也可以单独创建磁盘组。

**1、源端创建共享目录(NFS)**

-- 这里源端OS版本为CentOS6.8不支持数据库版本12.2.0.1的情况下安装ACFS，使用NFS创建共享目录
[root@lissen-n1 ~]# acfsdriverstate supported
ACFS-9459: ADVM/ACFS is not supported on this OS version: 'centos-release-6-8.el6.centos.12.3.x86_64
'
ACFS-9201: Not Supported

-- 一个做服务端，其他节点做客户端
一、服务端安装NFS相关依赖包

-- 查找相关依赖包，没有就安装
rpm -qa | grep nfs
rpm -qa | grep rpcbind
-- yum -y install nfs-utils rpcbind

chkconfig nfs on
chkconfig rpcbind on

-- 6.x
service nfs start
service nfs status
service rpcbind start
service rpcbind status

-- 7.x
systemctl start rpcbind
systemctl start nfs

**源端所有节点创建共享目录**

-- 服务端/客户端(源端所有节点)
mkdir -p /u01/app/ogg_src
chown -R oracle.oinstall /u01/app/ogg_src
chmod -R 755 /u01/app/ogg_src

**配置NFS**

echo "/u01/app/ogg_src 192.168.59.12(rw,no_root_squash,async)" >> /etc/exports
echo "/u01/app/ogg_src *(insecure,rw,async,no_root_squash)" >> /etc/exports

-- 立即生效
exportfs -a

-- 服务端显示共享的目录
[oracle@lissen-n1 ogg_src]$ showmount -e
Export list for lissen-n1:
/u01/app/ogg_src (everyone)

**客户端连接服务端**

mount -t nfs 192.168.59.12:/u01/app/ogg_src /u01/app/ogg_src

-- 报错
[root@lissen-n2 ~]# mount -t nfs 192.168.59.12:/u01/app/ogg_src /u01/app/ogg_src
mount.nfs: access denied by server while mounting 192.168.59.12:/u01/app/ogg_src

-- 服务端/etc/exports添加

echo "/u01/app/ogg_src *(insecure,rw,async,no_root_squash)" >> /etc/exports

-- 永久挂载
echo "/bin/mount -t nfs 192.168.59.12:/u01/app/ogg_src /u01/app/ogg_src" >> /etc/rc.local

-- 7.x使用上面办法不能实现自动挂载，写入到/etc/fstab
echo "192.168.59.4:/u01/app/ogg_tgt /u01/app/ogg_tgt nfs defaults 0 0" >> /etc/fstab


[root@lissen-n2 app]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg--root-lv_root
                       59G  6.9G   50G  13% /
tmpfs                 8.0G   72K  8.0G   1% /dev/shm
/dev/sda1             976M   39M  886M   5% /boot
/dev/mapper/vg--root-lv_home
                      9.8G   23M  9.2G   1% /home
/dev/mapper/vg--root-lv_tmp
                      9.8G   33M  9.2G   1% /tmp
/dev/mapper/vg--oracle--soft-lv_u01
                      178G   30G  139G  18% /u01
192.168.59.12:/u01/app/ogg_src
                      178G   31G  138G  18% /u01/app/ogg_src

**2、目标端创建共享目录(ACFS)**

...同上

二、安装OGG软件

**1、 OGG系统要求**

一个 OGG 实例最多支持 300 个并发 extract 和 replicat 进程，每个进程需要 25-55M 内存。
	GGSCI，view report，找到 PROCESS VM AVAIL FROM OS，大约就是系统所需 要的 swap space 大小
磁盘空间每个实例 50-150M，外加 trail 等等，至少给 1G。trail 所需空间 的预估方法是：[log volume in one hour] x [number of hours downtime] * 0.4
/tmp 空间，默认是 dirtmp 目录，可以通过 CACHEMGR 参数的 CACHEDIRECTORY 选项指定
安装 OGG 的用户必须属于 ORACLE 数据库实例的组，通常就是 dba。
要想支持RAC里的RMAN log retention特性, 得在add extract之前安装patch BUGFIX 11879974

**2、OGG相关文档**

-- OGG各版本对数据的支持文档

https://www.oracle.com/middleware/technologies/fusion-certification.html

Oracle GoldenGate	19.1.0.0.4+	Linux on System Z	Red Hat Enterprise Linux 7	Update Level	0+	64	Oracle Database	11.2.0.4+; 12.1.0.2+; 12.2.0.1+; 18c; 19c	"Supports Local and Remote, Capture and Delivery for Standard and Enterprise editions
Supports Remote, non-Integrated Replicat Delivery to Oracle Autonomous Transaction Processing and Data Warehousing Cloud"

-- Oracle文档资源

http://docs.oracle.com

-- OGG官方文档

https://docs.oracle.com/en/middleware/goldengate/core/19.1/installing/installing-classic-architecture.html

-- acfs上安装ogg，acfs用来存放ogg的安装目录，便于集群件的共享，在10g上部署可以选择ocfs2或者使用NFS

**3、配置ORACLE OGG相关环境变量**

-- 各个OS的库环境变量

  

节点1：

[oracle@lissen-n1 ~]$ cat ogg_src
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH


umask 022
#export TMP=/tmp
#export TMPDIR=$TMP


export OGG_HOME=/u01/app/ogg_src

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.3.0.0/dbhome_1
export ORACLE_SID=gggsrc1
export PATH=$OGG_HOME:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$OGG_HOME:$ORACLE_HOME/lib:/lib:/usr/lib:$LD_LIBRARY_PATH
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib


alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'

alias ggsci='rlwrap ggsci'


#export TMPDIR=/home/oracle/xtts


#export OGG_HOME=/u01/app/ogg_src




[oracle@lissen-n1 ~]$ cat ogg_dest
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH


umask 022
#export TMP=/tmp
#export TMPDIR=$TMP

export OGG_HOME=/u01/app/ogg_dest

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.3.0.0/dbhome_2
export ORACLE_SID=gggdest1
export PATH=$OGG_HOME:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$OGG_HOME:$ORACLE_HOME/lib:/lib:/usr/lib:$LD_LIBRARY_PATH
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib


alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'

alias ggsci='rlwrap ggsci'


#export TMPDIR=/home/oracle/xtts

#export OGG_HOME=/u01/app/ogg_dest


节点2：

[oracle@lissen-n2 ~]$ cat ogg_src
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH


umask 022
#export TMP=/tmp
#export TMPDIR=$TMP

export OGG_HOME=/u01/app/ogg_src

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.3.0.0/dbhome_1
export ORACLE_SID=gggsrc2
export PATH=$OGG_HOME:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$OGG_HOME:$ORACLE_HOME/lib:/lib:/usr/lib:$LD_LIBRARY_PATH
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib


alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'

alias ggsci='rlwrap ggsci'


#export TMPDIR=/home/oracle/xtts


#export OGG_HOME=/u01/app/ogg_src




[oracle@lissen-n2 ~]$ cat ogg_dest
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH


umask 022
#export TMP=/tmp
#export TMPDIR=$TMP


export OGG_HOME=/u01/app/ogg_dest

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.3.0.0/dbhome_2
export ORACLE_SID=gggdest2
export PATH=$OGG_HOME:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$OGG_HOME:$ORACLE_HOME/lib:

最低0.47元/天解锁文章