当前位置: 首页 > DDS > 正文

DDS 手动全同步指定表

通过WEB管理端操作是相当简单的,只需要点点鼠标就可以了

1,源端首先确认MAP ID

[dds@www.htz.pw config]$vshms -m

 

Mapping Info(2 mappings, MAX 256):

           ID TgtID TYPE   STATE 

            1     1 USER   RUN      [scott]

            2     1 USER   RUN      [htz]

2,创建新的MAP_START文件

[dds@www.htz.pw data]$vi map_restartobj

ddsplus -c localhost:8203 -l dds/dds -b <<! > map_restartobj.log &

map restartobj id=1 owner=SCOTT table=htz_pw;

idx resume tgtid=1;

tgt resume id=1;

!

红色的两行千万不能少,不然增量与索引就自动停了,这里见手动全同步后增量与索引被停了

[dds@www.htz.pw data]$map_restartobj

3,后台日志查看

下面是完完整的日志

0802011952[5.RCV00] <StartMapping ID="1" Mode="F" Method="S" TruncateTarget="Y" NREADER="1" RESTART="2" OWNER="SCOTT" TABLE="HTZ_PW" />

0802011952[5.RCV00] Modify Mapping in SHM

0802011952[5.RCV00] Modify Mapping in DISK (count=2)

0802011952[5.RCV00] There are 1 objects need to be sync

0802011952[5.RCV00] Starting DMP Processes (nreader=1, Verify:N)

0802011952[5.RCV01] ok to login [dds/dds]

0802011952[5.RCV01] DmpWriter#0 PID-20924 TH-16384 N-TGT=1

0802011952[5.RCV01] DmpOUT: 192.168.111.5:8204   HOST:192.168.111.5 PORT: 8204

0802011952[5.RCV01] DmpReader#0 PID-20928 TH-16386

0802011952[5.RCV01] DmpParsor#0 PID-20929 TH-32771

0802011952[5.RCV01] DMP00: Lock SCOTT.HTZ_PW at:754

这里停留了很长的时间,不知道是什么原因。

0802012412[5.RCV01] DMP00: Lock SCOTT.HTZ_PW at:758 OK

0802012412[5.RCV01] DMP00:      SCOTT.HTZ_PW at:763 Unlock SCN:0x9642a

0802012412[5.RCV01] GetDATA for SCOTT.HTZ_PW   Scn: 0x9642a

0802012412[5.RCV01] Count of Record: SCOTT.HTZ_PW  100070 DataLEN=9849390

0802012412[5.RCV01] Get SCOTT.HTZ_PW Time: 756 ms

0802012412[5.RCV01] DMP0 RC: R=0 P=0 W=0

0802012412[5.RCV01] Reader EXIT ( PID=20924 dumper=0, rc=0 )

0802012412[5.RCV00] CHILD: 20924 EXIT(0)

0802012412[5.RCV00]

+——————————————+

| Dmp Finish: return=  0   SUCCESSFULE     |

+——————————————+

这里可以看到DMP成功了

 

下面是目标端的日志

08/02/2014 01:24:14[5.HIS00] putData-queue#0 /oracle/app/dds/1124/data/his0/0/12.dtf, retry.

08/02/2014 01:24:14[5.RECVT] Server get connection from 192.168.111.5

08/02/2014 01:24:14[5.RECVT] child(21475) create!connection from:192.168.111.5

08/02/2014 01:24:17[5.HIS00] PPUT-H#0 (source_id=0) PID=21525 Begin work.

08/02/2014 01:24:17[5.HIS00] Load /oracle/app/dds/1124/data/his0/0/12.dtf (LEN=1172)

08/02/2014 01:24:17[5.HIS00] BAD_DEL: src#0 obj#51794 objpart#51794   SCOTT.HTZ_PW

08/02/2014 01:24:17[5.HIS00] RENAME(/oracle/app/dds/1124/data/msg.tab.new->/oracle/app/dds/1124/data/msg.tab)

08/02/2014 01:24:17[5.HIS00] SCOTT.HTZ_PW DP mode  blk:1408

08/02/2014 01:24:17[5.HIS00] TRUNCATE TABLE "SCOTT"."HTZ_PW"

08/02/2014 01:24:18[5.HIS00] CY I-0 U-0 D-0 DDL-3 IGN=0 BAD-0 Time:549ms CO:1 CC:0/50

08/02/2014 01:24:18[5.HIS00] Load /oracle/app/dds/1124/data/his0/0/13.dtf (LEN=9849390,zLEN=1233729 12%)

08/02/2014 01:24:19[5.HIS00] CY I-100070 U-0 D-0 DDL-0 IGN=0 BAD-0 Time:1578ms CO:0 CC:0/50

08/02/2014 01:24:19[5.HIS00] Load /oracle/app/dds/1124/data/his0/0/14.dtf (LEN=104)

08/02/2014 01:24:19[5.HIS00] CY I-0 U-0 D-0 DDL-0 IGN=0 BAD-0 Time:6ms CO:1 CC:1/50

08/02/2014 01:24:19[5.HIS00] CheckPoint: pput.c:842

08/02/2014 01:24:19[5.HIS00] DPMerge(source: obj#51794, partobj#51794, target: obj#88093, partobj#88093)

08/02/2014 01:24:20[5.HIS00] DMP00: SCOTT.HTZ_PW  …(PID:21525) Extents:27

08/02/2014 01:24:20[5.HIS00] ROWID COUNT  for SCOTT.HTZ_PW 100070

08/02/2014 01:24:20[5.HIS00] DEBUG: DoDPMerge1

08/02/2014 01:24:20[5.HIS00]   100000 Mapped for SCOTT.HTZ_PW

08/02/2014 01:24:20[5.HIS00] Rowid Mapped for SCOTT.HTZ_PW 100070

08/02/2014 01:24:20[5.HIS00] DEBUG: DoDPMerge2

 

已经成功了。

 

但是时间有点长

本文固定链接: http://www.htz.pw/2014/08/02/dds-%e6%89%8b%e5%8a%a8%e5%85%a8%e5%90%8c%e6%ad%a5%e6%8c%87%e5%ae%9a%e8%a1%a8.html | 认真就输

该日志由 huangtingzhong 于2014年08月02日发表在 DDS 分类下, 你可以发表评论,并在保留原文地址及作者的情况下引用到你的网站或博客。
原创文章转载请注明: DDS 手动全同步指定表 | 认真就输