ogg实现方式
①源端日志抽取进程抽取日志
②源端推送进程pump
③目的端复制文件到目标库
一、配置
平台 linux x86_64
oracle 11.2.0.4
二、配置OGG
1、配置网络互通
2、安装ogg
①创建目录/u01/app/ogg
②解压缩软件
tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar -C /u01/app/ogg
3、修改环境变量:
vi .bash_profile
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
否则,运行ggsci时报如下错误:
./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory
4、创建子目录:
oracle:
cd /u01/app/ogg
./ggsci
GGSCI>create subdirs
5、创建用户ogg并授权,收回unlimited tablespace权限
create user ogg identified by ogg;
grant resource,connect to ogg;
grant select any dictionary to ogg;
(grant all on scott.emp1 to ogg; //在scott创建了表之后赋予权限
grant all on scott.dept1 to ogg;)
revoke unlimited tablespace from ogg;
alter user ogg quota unlimited on users; //让用户ogg在users表空间上有权限
6、scott用户创建emp1和dept1表,加上约束(目标库上只要结构,没有数据)
源端:
create table emp1 as select * from emp;
create table dept1 as select * from dept;
alter table emp1 add constraints empno_pk primary key(empno);
alter table dept1 add constraints deptno_pk primary key(deptno);
alter table emp1 add constraints deptno_fk foreign key(deptno) references dept1(deptno);
目标端:
create table emp1 as select * from emp where 1=2;
create table dept1 as select * from dept where 1=2;
alter table emp1 add constraints empno_pk primary key(empno);
alter table dept1 add constraints deptno_pk primary key(deptno);
alter table emp1 add constraints deptno_fk foreig