原理介绍:
有两个大过程
1、初始化数据表 (ogg方式、rman、empdp/impdp、exp/imp等方式)
2、同步过程:1、源端extract pump (exttrail日志文件) 2、目标端replicat 进程(使用源端exttrail日志文件)
通俗就是:源端捕获进程捕获数据改变量存放在本地目录,PUMP进程使用本地捕获文件投递到目标端trail文件目录,目标端replicat进程收集源端传输过来的trail文件,并读取文件,将其内容应用到数据本身,达到源目端数据同步。
实验环境描述:
一、操作系统及oracle 软件、ogg软件版本
OS:CentOS Linux release 7.7.1908 (Core)
oracle软件:11.2.0.4 ogg:Oracle_GoldenGate_11.2.1.0.3
二、信息分配
host01:192.0.2.11 host02:192.0.2.12
SID: orcl orclogg
(备注:安装库时添加示例表信息,后面同步测试用到)
三、网络拓扑
四、ogg软件安装(host01,host02库安装步骤省略了,我前面文章里面有的哈)
1、上传软件包到host01,host02 并解压zip包
(Oracle GoldenGate V11.2.1.0.3 for Oracle 11g on Linux x86-64.zip)
[oracle@host01 stage]$ unzip Oracle\ GoldenGate\ V11.2.1.0.3\ for\ Oracle\ 11g\ on\ Linux\ x86-64.zip
2、创建软件安装目录,并将软件解压到相应的目录(host01,host02同样操作)
host01:
[oracle@host01 ~]$ mkdir -p /u01/app/ogg/11.2.0/
[oracle@host01 ~]$chmod 775 /u01/app/ogg -R
[oracle@host01 stage]$ tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar -C /u01/app/ogg/11.2.0/
host02:
[oracle@host02 ~]$ mkdir -p /u01/app/ogg/11.2.0/
[oracle@host02 ~]$chmod 775 /u01/app/ogg -R
[oracle@host02 stage]$ tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar -C /u01/app/ogg/11.2.0/
3、设置oracle账户环境变量(用于运行ogg)
host01:
export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=ORCL
export PATH=$ORACLE_HOME/bin:$PATH
alias alert_log='tail -f /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/alert_ORCL.log'
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/app/ogg/11.2.0
alias ggsci='/u01/app/ogg/11.2.0/ggsci'
source .bash_profile
登录OGG,只需要执行create subdirs命令 创建ogg管理目录。
GGSCI (host01) 1> show all
Parameter settings:
SET SUBDIRS ON
SET DEBUG OFF
Current directory: /u01/app/ogg/11.2.0
Using subdirectories for all process files
Editor: vi
Reports (.rpt) /u01/app/ogg/11.2.0/dirrpt
Parameters (.prm) /u01/app/ogg/11.2.0/dirprm
Stdout (.out) /u01/app/ogg/11.2.0/dirout
Replicat Checkpoints (.cpr) /u01/app/ogg/11.2.0/dirchk
Extract Checkpoints (.cpe) /u01/app/ogg/11.2.0/dirchk
Process Status (.pcs) /u01/app/ogg/11.2.0/dirpcs
SQL Scripts (.sql) /u01/app/ogg/11.2.0/dirsql
Database Definitions (.def) /u01/app/ogg/11.2.0/dirdef
host02:
export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=ORCLOGG
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/app/ogg/11.2.0
alias ggsci='/u01/app/ogg/11.2.0/ggsci'
source .bash_profile
登录OGG,只需要执行create subdirs命令 创建ogg管理目录。
GGSCI (host02) 1> show all
Parameter settings:
SET SUBDIRS ON
SET DEBUG OFF
Current directory: /u01/app/ogg/11.2.0
Using subdirectories for all process files
Editor: vi
Reports (.rpt) /u01/app/ogg/11.2.0/dirrpt
Parameters (.prm) /u01/app/ogg/11.2.0/dirprm
Stdout (.out) /u01/app/ogg/11.2.0/dirout
Replicat Checkpoints (.cpr) /u01/app/ogg/11.2.0/dirchk
Extract Checkpoints (.cpe) /u01/app/ogg/11.2.0/dirchk
Process Status (.pcs)