1. 数据库相关配置

1.1 源端

1.1.1 创建表空间和ogg用户

SQL>create tablespace tbs_gguser datafile '/u01/app/oracle/oradata/sky2/gguser.dbf' size 50m autoextend on; SQL>create user ogg identified by ogg default tablespace tbs_gguser quota unlimited on tbs_gguser;

1.1.2 对用户ogg进行授权

SQL>grant connect,resource to ogg; SQL>grant CREATE SESSION,ALTER SESSION to ogg; SQL>grant SELECT ANY DICTIONARY,SELECT ANY TABLE to ogg; SQL>grant ALTER ANY TABLE to ogg; SQL>grant FLASHBACK ANY TABLE to ogg; SQL>grant EXECUTE on DBMS_FLASHBACK to ogg;

1.1.3 创建测试表

SQL>conn scott/scott SQL>create table dept1 as select * from dept; 给创建的dept1表定义主键（如果创建的测试表带有主键则不需要） SQL >alter table dept1 add constraint pk_dept1 primary key(deptno);

1.1.4 开启附加日志

SQL>select SUPPLEMENTAL_LOG_DATA_MIN from v$database; 可以看到附加日志没有开启，将它启用,切换之后查询是yes即可 SQL>alter database add supplemental log data; 切一下归档 SQL>alter system switch logfile;

1.1.5 开启归档模式

SQL>archive log list; 处于非归档模式，修改为归档模式 SQL>shutdown immediate; SQL>startup mount SQL>alter database archivelog; SQL>alter database open;

1.1.6 开启强制日志

SQL>select force_logging from v$database; SQL>alter database force logging;

1.1.7 添加捕捉数据改变的表

GGSCI > dblogin userid ogg,password ogg GGSCI > add trandata scott.test01 GGSCI > info trandata scott.*

1.2 目标端

1.2.1 创建表空间和用户ogg

SQL>create tablespace tbs_gguser datafile '/u01/app/oracle/oradata/sky3/gguser.dbf' size 50m autoextend on; SQL>create user ogg identified by ogg default tablespace tbs_gguser quota unlimited on tbs_gguser;

1.2.2 对用户ogg进行授权

SQL>grant connect,resource to ogg; grant CREATE SESSION,ALTER SESSION to ogg; grant SELECT ANY DICTIONARY,SELECT ANY TABLE to ogg; grant ALTER ANY TABLE to ogg; grant CREATE ANY TABLE to ogg;

1.2.3 建测试表

SQL>conn scott/scott SQL>create table dept1 as select * from dept where 1=2; 给创建的dept1表定义主键（如果创建的测试表带有主键则不需要） SQL>alter table test01 add constraint pk_dept1 primary key(deptno); SQL>grant all on dept1 to ogg;

2. OGG相关配置

2.1 源端

2.1.1配置并启动MGR

GGSCI > EDIT PARAMS MGR PORT 7809 PURGEOLDEXTRACTS ./dirdat, USECHECKPOINTS GGSCI > start mgr

2.1.2 配置并启动EXTRACT

GGSCI >EDIT PARAMS EXT_1 EXTRACT EXT_1 SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8) USERID ogg, PASSWORD ogg EXTTRAIL ./dirdat/ex TABLE scott.dept1; --添加EXTARCT GGSCI > ADD EXTRACT EXT_1,TRANLOG,BEGIN NOW --添加TRAIL GGSCI> ADD EXTTRAIL ./dirdat/ex, EXTRACT EXT_1,MEGABYTES 5 GGSCI > start extract EXT_1 GGSCI > info extract EXT_1

2.1.3 配置并启动PUMP

GGSCI > EDIT PARAMS PMP_1 EXTRACT PMP_1 SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8) PASSTHRU RMTHOST 192.168.80.132, MGRPORT 7809 RMTTRAIL ./dirdat/ex TABLE scott.test01; --添加PUMP GGSCI> ADD EXTRACT PMP_1,EXTTRAILSOURCE ./dirdat/ex --添加TRAIL GGSCI> ADD RMTTRAIL ./dirdat/ex, extract PMP_1, MEGABYTES 5 --启动data pump进程（2017.6.15添加：确保对端MGR已经开启，否则会出现错误） GGSCI > start extract PMP_1 --查看状态 GGSCI > INFO EXTRACT PMP_1

2.2 目标端

2.2.1 配置并启动MGR

GGSCI > EDIT PARAMS MGR PORT 7809 PURGEOLDEXTRACTS ./dirdat, USECHECKPOINTS GGSCI > start mgr

2.2.2 目标库配置replicat进程

创建GLOBALS参数 GGSCI > EDIT PARAMS ./GLOBALS CHECKPOINTTABLE ogg.ggschkpt --为了让GLOBALS配置起作用，需要退出后重新进入GGSCI会话 GGSCI > exit --添加replicat checkpoint table GGSCI > DBLOGIN USERID ogg,PASSWORD ogg GGSCI > ADD CHECKPOINTTABLE --添加REPILCATE GGSCI> ADD REPLICAT REP_1,EXTTRAIL ./dirdat/ex --编辑replicat process REP_1参数 GGSCI> EDIT PARAM REP_1 REPLICAT REP_1 SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8) USERID ogg,PASSWORD ogg ASSUMETARGETDEFS DISCARDFILE ./dirrpt/REP_1.DSC,PURGE MAP scott.dept1,TARGET scott.test01; --启动进程 GGSCI > START REPLICAT REP_1