认真就输

1，停DDS

在并行装载的时候，启停dds相当有讲究，必须按步骤来完

源端
[dds@www.htz.pw dict]$ddstop
目标端
[dds@www.htz.pw dict]$ddstop

2，修改tgt_que.cfg文件

[dds@www.htz.pw config]$cat tgt_que.cfg
# QUE#  USER.TABLE
#1      scott.table1
#1      scott.table2
#1      scott."TableName"
#2 hs_user
#1      scott.htz
#2      scott.scott1

3，修改ddstart文件

修改ddstart文件，删除多于的dds_pput文件
[dds@www.htz.pw config]$vi `which ddstart`
    ${DDS_HOME}/dds_pput
    ${DDS_HOME}/dds_pput
    ${DDS_HOME}/dds_pput
#!/bin/sh

if [ "${NLS_LANG}NONE" = "NONE" ]
then
    echo "Error: NLS_LANG is not set."
    exit -1
fi

if [ "${ORACLE_HOME}NONE" = "NONE" ]
then
    echo "Error: ORACLE_HOME is not set."
    exit -1
fi

LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:/lib:/usr/lib:/usr/local/lib
DDS_HOME=/oracle/app/dds/1124/bin
DDS_DATA=/oracle/app/dds/1124/data
export DDS_HOME DDS_DATA LD_LIBRARY_PATH

${DDS_HOME}/dds_pmont -v

${DDS_HOME}/dds_pmont

if [ $? -eq 0 ]
then
    # rm $DDS_DATA/msg.log 2>/dev/null
    ${DDS_HOME}/dds_pmsgt
    ${DDS_HOME}/dds_precvt
    ${DDS_HOME}/dds_pclr
    ${DDS_HOME}/dds_pfile
    ${DDS_HOME}/dds_pput
    ${DDS_HOME}/dds_pput -1
    ${DDS_HOME}/dds_pput -1
    ${DDS_HOME}/dds_pput -1
    ${DDS_HOME}/dds_pput -1
    ${DDS_HOME}/dds_pput -1
    ${DDS_HOME}/dds_pput -1
    ${DDS_HOME}/dds_pput -1
    ${DDS_HOME}/dds_pput -1
    ${DDS_HOME}/dds_pput -x
else
    exit -1
fi
~
"/oracle/app/dds/1124/data/ddstart" 43L, 905C written

启动DDS软件

4，查看进程信息

[dds@www.htz.pw config]$ddstart
Copyright: Beijing Jiuqiao Software LTD.
EMAIL/MSN: tb2oracle@163.com
      TEL: 010-82255433
      FAX: 010-82255433-2003
  License: need check
iStream DDS--PMONT x86_64 Linux 3.2.9-1-ARCH Ver2.13.9.p17.q 2013/10/17 10:25:12 (BIT-64)
        With 245760 objects 32 Sources

08/04/2014 03:12:45[5.PMONT] License valid date is 2013/03/12 -- 2018/09/02 (2000 Days)
08/04/2014 03:12:46[5.PMONT] Get SCN   Info for put0
08/04/2014 03:12:46[5.PMONT] Get SCN   Info for put1
08/04/2014 03:12:46[5.PMONT] Get SCN   Info for put2
08/04/2014 03:12:46[5.PMONT] Get SCN   Info for put3
08/04/2014 03:12:46[5.PMONT] Get Dict  Info
08/04/2014 03:12:46[5.PMONT] Get bad table info
08/04/2014 03:12:46[5.PMONT] Get Queue Info for put0
08/04/2014 03:12:46[5.PMONT] Get Queue Info for put1
08/04/2014 03:12:46[5.PMONT] Get Queue Info for put2
08/04/2014 03:12:46[5.PMONT] Get Queue Info for put3
08/04/2014 03:12:46[5.PMONT] Get Queue Info for his0
08/04/2014 03:12:46[5.PMONT] Get Queue Info for his1
08/04/2014 03:12:46[5.PMONT] Get Queue Info for his2
08/04/2014 03:12:46[5.PMONT] Get Queue Info for his3
08/04/2014 03:12:46[5.PMONT] Get Queue Info for his4
08/04/2014 03:12:46[5.PMONT] Get Queue Info for his5
08/04/2014 03:12:46[5.PMONT] Get Queue Info for his6
08/04/2014 03:12:46[5.PMONT] Get Queue Info for his7

[dds@www.htz.pw dict]$ddstart
Copyright: Beijing Jiuqiao Software LTD.
EMAIL/MSN: tb2oracle@163.com
      TEL: 010-82255433
      FAX: 010-82255433-2003
  License: need check
iStream DDS--PMONS x86_64 Linux 3.2.9-1-ARCH Ver2.13.9.p17.q 2013/11/21 15:12:44 (BIT-64)
        With 204800 objects & 256 mappings

0804031250[5.PMONS] License valid date is 2013/03/12 -- 2018/09/02 (2000 Days)

[dds@www.htz.pw config]$vshmt -p

PID:
        PID-PMONT     :    15295 Running        /oracle/app/dds/1124/bin/dds_pmont
        PID-PMSGT     :    15297 Running        /oracle/app/dds/1124/bin/dds_pmsgt
        PID-PCLR      :    15301 Running        /oracle/app/dds/1124/bin/dds_pclr
        PID-PRECVT    :    15299 Running        /oracle/app/dds/1124/bin/dds_precvt
        PID-PFILE     :    15304 Running        /oracle/app/dds/1124/bin/dds_pfile
        PID-PPUT#00   :    15306 Running        /oracle/app/dds/1124/bin/dds_pput               DTF:907
        PID-PPUT#00_H :    15309 Running        /oracle/app/dds/1124/bin/dds_pput -1
        PID-PPUT#01_H :    15312 Running        /oracle/app/dds/1124/bin/dds_pput -1
        PID-PPUT#02_H :    15315 Running        /oracle/app/dds/1124/bin/dds_pput -1
        PID-PPUT#03_H :    15318 Running        /oracle/app/dds/1124/bin/dds_pput -1
        PID-PPUT#04_H :    15321 Running        /oracle/app/dds/1124/bin/dds_pput -1
        PID-PPUT#05_H :    15324 Running        /oracle/app/dds/1124/bin/dds_pput -1
        PID-PPUT#06_H :    15327 Running        /oracle/app/dds/1124/bin/dds_pput -1
        PID-PPUT#07_H :    15330 Running        /oracle/app/dds/1124/bin/dds_pput -1
        PID-PPUT#00_V :    15333 Running        /oracle/app/dds/1124/bin/dds_pput -x
        PID-PRECVT_CHI:    15365 Running
进程启动正常

5，DML语句测试

下面测试Put2,put3的dml语句

www.htz.pw > insert into scott.put2 select * from dba_objects where rownum=1;

1 row created.

www.htz.pw > commit;

Commit complete.

目标端日志
08/04/2014 03:15:26[5.PUT00] Load /oracle/app/dds/1124/data/put0/0/908.dtf (LEN=201)
08/04/2014 03:15:26[5.PUT00] CY I-1 U-0 D-0 DDL-0 IGN=0 BAD-0 Time:148ms CO:1 CC:0/50   Delay(s):1(1~3~5)

www.htz.pw > delete scott.put2 where rownum=1;

1 row deleted.

www.htz.pw > commit;

Commit complete.

08/04/2014 03:16:40[5.PUT00] Load /oracle/app/dds/1124/data/put0/0/909.dtf (LEN=213)
08/04/2014 03:16:40[5.PUT00] CY I-0 U-0 D-1 DDL-0 IGN=0 BAD-0 Time:9ms CO:0 CC:0/50     Delay(s):2(1~2~5)

www.htz.pw > drop table scott.put2;

Table dropped.

08/04/2014 03:17:02[5.PUT00] Load /oracle/app/dds/1124/data/put0/0/910.dtf (LEN=181)
08/04/2014 03:17:02[5.PUT00] DROP TABLE "SCOTT"."PUT2"
08/04/2014 03:17:03[5.PUT00] CY I-0 U-0 D-0 DDL-1 IGN=0 BAD-0 Time:474ms CO:0 CC:1/50   Delay(s):3(1~2~5)

功能测试正常，都在put0这个默认通道内完成