Oracle GoldenGate 配置双向同步
一、环境准备
DB版本:19.3
GoldenGate版本:21.3
系统环境配置:
mkdir -p /u01/app/ogg_home
chmod -R 777 /u01/app/ogg_home
chown -R oracle:oinstall /u01/app/ogg_home
vi .bash_profile
# oracle
export CV_ASSUME_DISTID=OEL7
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19/db_1
export ORACLE_SID=orcl1
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=/u01/app/oracle/product/19/db_1/lib
export LANG=en_US
# ogg
export OGG_HOME=/u01/app/ogg_home
export PATH=$OGG_HOME:$PATH
export LD_LIBRARY_PATH=$OGG_HOME:$LD_LIBRARY_PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
配置数据库:(此步骤需要在源和目标端服务器上都执行)
启用数据库归档和附加日志:
alter systemsetlog_archive_dest_1='location=/u01/app/archivelog';
alter database archivelog;
alter DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
alter DATABASE ADD SUPPLEMENTAL LOG DATA;
alter DATABASE FORCE LOGGING;
alter SYSTEM SWITCH LOGFILE;
开启OGG复制
alter SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE;
修改完成后确认
select log_mode,supplemental_l