Oracle随笔：DDS 取消并行装载功能

我们的文章会在微信公众号IT民工的龙马人生和博客网站( www.htz.pw )同步更新 ，欢迎关注收藏，也欢迎大家转载，但是请在文章开始地方标注文章出处，谢谢！
由于博客中有大量代码，通过页面浏览效果更佳。

Oracle随笔：DDS 取消并行装载功能

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这个默认通道内完成

------------------作者介绍-----------------------
姓名：黄廷忠
现就职：Oracle中国高级服务团队
曾就职：OceanBase、云和恩墨、东方龙马等
电话、微信、QQ：18081072613
个人博客: (http://www.htz.pw)
CSDN地址: (https://blog.csdn.net/wwwhtzpw)
博客园地址: (https://www.cnblogs.com/www-htz-pw)