第八章：ogg初始化datapump

  使用Data Pump 来进行初始化

（1）配置OGG 进程   datapump （参考datapump模式的搭建）

8.1在source和target database 上创建测试用户

--source database
 SQL> create user sender identified by oracle default tablespace users temporary tablespace temp;  --创建用户
 User created.
 SQL> grant connect,resource,dba to sender;
 Grant succeeded.

2. --target database
 SQL> create user receiver identified by oracle default tablespace users temporary tablespace temp;  --创建用户
 User created.
 SQL> grant connect,resource,dba to receiver;
 Grant succeeded.

8.2 配置SourceDB 的复制队列

GGSCI (ogg02) 10> dblogin userid ggs, password ggs
Successfully logged into database.

GGSCI (ogg02) 11> add extract ext1,tranlog, begin now
EXTRACT added.

GGSCI (ogg02) 12> add exttrail /u01/pjj/dirdat/lt, extract ext1
EXTTRAIL added.

修改抽取进程ext1参数：
GGSCI (ogg1) 13> edit params ext1
extract ext1
userid ggs, password ggs
exttrail /u01/pjj/dirdat/lt
ddl include mapped objname sender.*;
table sender.*;

8.2.1 增加Pump 进程

GGSCI (ogg1) 8> add extract dpump,exttrailsource /u01/pjj/dirdat/lt
EXTRACT added. 
--这里指定我们localtrail 的位置。

 

GGSCI (ogg02) 18> add rmttrail /u01/pjj/dirdat/rt, extract dpump,megabytes 10    --trail文件的大小
RMTTRAIL added.

配置Data Pump 参数：

GGSCI (gg1) 56> view params dpump

extract dpump
userid ggs@ogg1, password ggs
dynamicresolution
passthru
rmthost 192.168.1.62, mgrport 7809
rmttrail /u01/ggs/dirdat/rt
table sender.*;

配置Data Pump 参数： 

-----------------------------------------以这个为准

GGSCI (ogg02) 27> edit params dpump   --查看一下
extract dpump
userid ggs, password ggs
dynamicresolution
passthru
rmthost 192.168.56.23, mgrport 7809
rmttrail /u01/pjj/dirdat/rt             
table sender.*;

9. target 端 

9.1 添加checkpointtable

GGSCI (ogg2) 1> dblogin userid ggs,password ggs
Successfully logged into database. 

GGSCI (ogg2) 2> add checkpointtable ggs.checkpoint
Successfully created checkpoint table ggs.checkpoint.

9.2添加target replicat进程

GGSCI (ogg04) 1>  add replicat rep1,exttrail /u01/pjj/dirdat/rt, checkpointtable ggs.checkpoint

REPLICAT added.

GGSCI (ogg04) 2> edit params rep1

replicat rep1

ASSUMETARGETDEFS
userid ggs,password ggs
discardfile /u01/pjj/dirdat/rep1_discard.txt,append, megabytes 10
DDL
map sender.*, target receiver.*;

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

1.启动抽取进程和Data pump，不启动Rep1.

2. 创建directory

在source和target 端都创建该directory。

SQL> create directory backup as '/oradata/oggback';
Directory created.

确认：
SQL> select * from dba_directories;
OWNER DIRECTORY_NAME            DIRECTORY_PATH
----- ------------------------- -----------------------------------------------------------------------
SYS   BACKUP                    /u01/backup
SYS   GGS_DDL_TRACE             /u01/app/oracle/diag/rdbms/dave/dave/trace
SYS   XMLDIR                    /u01/app/oracle/product/11.2.0/db_1/rdbms/xml
SYS   DATA_PUMP_DIR             /u01/app/oracle/admin/dave/dpdump/
SYS   ORACLE_OCM_CONFIG_DIR     /u01/app/oracle/product/11.2.0/db_1/ccr/state

3. 确认长事务已经完成

SQL> select  start_time  from v$transaction where to_date(start_time, 'yyyy-mm-dd hh24:mi:ss')<to_date('2014-03-22 05:02:26','yyyy-mm-dd hh24:mi:ss');
no rows selected

4. 获取源端获取数据库当前的SCN

SQL> select dbms_flashback.get_system_change_number from dual;

GET_SYSTEM_CHANGE_NUMBER
------------------------
           748013

5. 在源端导出数据

$ expdp  system/oracle directory=backup dumpfile=sender_%U.dmp logfile=user.log schemas=sender parallel=2  flashback_scn=748013; 

6. 在Target 端导入

[oracle@ogg1 backup]$ scp *.dmp 192.168.56.23:/oradata/oggback
oracle@192.168.1.62's password: 
sender_01.dmp                                                                                     100%  304KB 304.0KB/s   00:00    
sender_02.dmp                                                                                     100%   36KB  36.0KB/s   00:00    
[oracle@ogg1 backup]$

[oracle@ogg2 ggs]$ impdp system/oracle directory=backup dumpfile= sender_%U.dmp logfile=user.log  parallel=2  table_exists_action=replace REMAP_SCHEMA=sender:receiver;        

7. 用SCN 启动Replicat

GGSCI (ogg2) 17> start rep1, aftercsn 748013

GGSCI (ogg2) 18> info rep2

REPLICAT   REP1      Last Started 2014-03-22 06:44   Status RUNNING
Checkpoint Lag         00:00:00 (updated 00:00:08 ago)
Process ID                19233
Log Read Checkpoint  File /u01/ggs/dirdat/lt000000
                     First Record  RBA 0

8. 验证同步情况