【Oracle】Oracle到PostgreSQL的OGG同步配置

最新推荐文章于 2024-10-03 16:59:16 发布

原创

最新推荐文章于 2024-10-03 16:59:16 发布 · 5.6k 阅读

8 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #PostgreSQL #OGG #数据同步

前一阵子做的从Oracle实时同步到PostgreSQL，查到的资料很少，后经查询MOS发现有几个OGG的小版本支持Oracle到PostgreSQL的同步，过程整理后跟大家分享一下。

测试环境：

Oracle 11.2.0.4

PostgreSQL：9.3.9
OS：OEL 5.8 x64

OGG：11.2.1.0.30

1.源端检查以下环境变量

ORACLE_HOME
ORACLE_SID
LD_LIBRARY_PATH

2.检查源端归档情况，如果没有，开启归档

alter system set log_archive_dest='LOCATION=USE_DB_RECOVERY_FILE_DEST' scope=both sid='*';
shutdown immediate
startup mount
alter database archivelog;
alter database open;

3.源库开启附加日志创建goldengate用户并授权

alter database add supplemental log data;

create user goldengate identified by goldengate;

grant dba to goldengate;

4.源端解压ogg软件，并配置以下环境变量加到.bash_profile中。

export PATH=$PATH:/home/oracle/ggs
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/home/oracle/ggs/lib

5.源端create subdirs

GGSCI (test) 1> create subdirs

Creating subdirectories under current directory /home/oracle/ggs

Parameter files                /home/oracle/ggs/dirprm: already exists
Report files                   /home/oracle/ggs/dirrpt: created
Checkpoint files               /home/oracle/ggs/dirchk: created
Process status files           /home/oracle/ggs/dirpcs: created
SQL script files               /home/oracle/ggs/dirsql: created
Database definitions files     /home/oracle/ggs/dirdef: created
Extract data files             /home/oracle/ggs/dirdat: created
Temporary files                /home/oracle/ggs/dirtmp: created
Stdout files                   /home/oracle/ggs/dirout: created