ogg配置 oracle,OGG同步配置ORACLE至ORACLE

系统环境

系统版本:redhat 6.5

数据库版本:11.2.0.4

OGG软件链接: https://pan.baidu.com/s/1kWuhBsN 密码: h5q1

源库配置

创建OGG表空间

create tablespace ogg datafile '/u01/app/oracle/oradata/ogg.dbf' size 2G autoextend off;

创建OGG用户

create user ogg identified by ogg default tablespace ogg;

添加权限

grant connect,resource,create session,alter session,

select any dictionary,select any table,flashback any table,

alter any table,insert any table,update any table,

delete any table,select any transaction,

execute on DBMS_CAPTURE_ADM to ogg;

开启归档

shutdown immediate

startup mount

alter database archivelog;

alter database open;

开启强制日志

ALTER DATABASE FORCE LOGGING;

开启附加日志

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

修改参数

ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION=TR