ogg+impdp不落地形式配置

源端检查数据

SQL> show user;

USER is "WZY"

SQL>  select tname from tab;

 

TNAME

------------------------------

T

TEST

T_RANGE

SQL> select * from t;

 

        X

----------

        7

源端ogg启动抽取

源端参数如下

extract ext_t1

setenv(NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252)

userid ggs@192.168.7.2/PROD,password ggs

exttrail dirdat/sp

table WZY.*;

 

./ggsci

start ext_t1

info all

确认ext_t1为running状态

GGSCI (bogon) 22> info all

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

MANAGER     RUNNING                                          

EXTRACT     ABENDED     DP_T1       00:00:00      534:46:11  

EXTRACT     ABENDED     DP_T2       00:00:00      534:46:11  

EXTRACT     RUNNING     EXT_T1      00:00:00      00:00:04   

EXTRACT     STOPPED     EXT_T2      00:00:00      00:25:11   

目标端清理用户

Drop user wzy cascade;

Create user wzy identified by wzy;

Grant connect,resource to wzy;

需要调研源端数据库表空间情况，目标端需要建立同名表空间

源端调研

Select tablespace_name,count(*) from dba_data_files order by 1;

目标端创建

Create tablespace

 

目标端不落地impdp数据导入

目标端创建dblink

create public database link ogg

connect to wzy identified by wzy

using '192.168.7.12:1521/PROD';

 

测试

SQL> select * from t@ogg;

 

        X

----------

        7

 

源端创建directory

Create directory dir as ‘/home/oracle/’

Grant read,write on directory dir to wzy;

 

 

查询源端scn

SQL> select current_scn from v$database;

 

CURRENT_SCN

-----------

    1736957

 

目标端执行导入

impdp wzy/wzy network_link=ogg schemas=wzy directory=dir logfile=nodmp_wzy.log

flashback_scn=1736957

 

#########################################

在此时进行测试，源端插入一行新数据

SQL> conn wzy/wzy

Connected.

SQL>

SQL>

SQL> select * from t;

 

        X

----------

        7

 

SQL> insert into t values(8);

 

1 row created.

 

SQL> commit;

 

Commit complete.

#################################################

源端ogg启动投递

参数如下

extract dp_t1

passthru

rmthost 192.168.7.3 ,mgrport 7111

rmttrail dirdat/rp

table WZY.*;

 

start dp_t1
info all

GGSCI (bogon) 28> info all

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

MANAGER     RUNNING                                          

EXTRACT     RUNNING     DP_T1       00:00:00      00:00:05   

EXTRACT     ABENDED     DP_T2       00:00:00      534:46:52  

EXTRACT     RUNNING     EXT_T1      00:00:00      00:00:03   

EXTRACT     STOPPED     EXT_T2      00:00:00      00:25:52   

目标端ogg启动应用

参数如下

replicat rep_t1

setenv(NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252)

userid ggt,password ggt

handlecollisions

assumetargetdefs

map wzy.*,target wzy.*;

 

start replicat rep_t1, AFTERCSN 1736957

 

 

GGSCI (localhost.localdomain) 11> info all

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

MANAGER     RUNNING                                          

REPLICAT    RUNNING     REP_T1      00:00:00      00:00:03   

REPLICAT    ABENDED     REP_T2      00:00:00      504:34:03  

目标端检查数据

SQL> conn wzy/wzy

Connected.

SQL> select * from t;

 

        X

----------

        7

        8

 

SQL>