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

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

进程启动正常     

5DML语句测试

下面测试Put2,put3dml语句

 

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

本文固定链接: http://www.htz.pw/?p=621 | 认真就输

该日志由 huangtingzhong 于2014年08月05日发表在 DDS 分类下, 你可以发表评论,并在保留原文地址及作者的情况下引用到你的网站或博客。
原创文章转载请注明: DDS 取消并行装载功能 | 认真就输