goldengate 实现 ORACLE 到 MYSQL 的同步
环境:
源端:oracle 版本 11g goldengate 版本 12.2.0.1.1(fbo_ggs_Linux_x64_shiphome.zip)
目 标 端 : mysql 版 本 5.6 goldengate for mysql 版 本 12.2.0.1.1
(ggs_Linux_x64_MySQL_64bit.zip)
源端:
--1.开启附加日志
SQL> select supplemental_log_data_min from v$database;
SUPPLEME
---------------
NO
SQL> alter database add supplemental log data;
SQL> alter database force logging;
SQL> select supplemental_log_data_min from v$database;
SUPPLEME
---------------
YES
SQL> select force_logging from v$database;
FOR
---
YES
--2.查看数据库是否归档模式(如不是,则开启)
select name,log_mode from v$database;
--3.创建 ogg 用户
create user goldengate identied by goldengate;
grant connect to goldengate;
grant alter session to goldengate;
grant create session to goldengate;
grant connect to goldengate;
grant resource to goldengate;
grant select any dictionary to goldengate;
grant select any table to goldengate;
grant insert any table to goldengate;
grant update any table to goldengate;
grant delete any table to goldengate;