一、源端的准备工作(oracle库)
1. 设置参数
alter system set enable_goldengate_replication=true;
alter system set open_cursors=500;
2. 创建GolenGate表空间
create tablespace ts_ogg datafile size 500m;
create temporary tablespace ts_ogg_temp tempfile size 500m;
3. 创建GoldenGate用户并授权
create user ogg identified by oracle default tablespace ts_ogg temporary tablespace ts_ogg_temp;
grant dba to ogg;
4. 开启归档
shutdown immediate;
startup mount
alter database archivelog;
alter database open;
5. 检查是否开始附加日志和强制日志
SELECT force_logging, supplemental_log_data_min FROM v$database; -- 再检查一下
alter database force logging;
alter database add supplemental log data;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
SELECT force_logging, supplemental_log_data_min FROM v$database; -- 再检查一下
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;
二、源端安装OGG
1. 配置环境变量
export OGG_HOME=/oracle/gg/
export LD_LIBRARY_PATH=/oracle/product/db12c/lib:/lib:/usr/lib:/oracle/product/db12c/rdbms/lib
export CLASSPATH=/oracle/product/db12c/JRE:/oracle/product/db12c/jlib:/oracle/product/db12c/rdbms/jlib:/oracle/product/db12c/netw