sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 运维DBA >

【学习笔记】分享一篇关于 DDS取消并行装载功能的笔记

时间:2016-10-30 10:41   来源:Oracle研究中心   作者:HTZ   点击:

天萃荷净 Oracle研究中心学习笔记:分享一篇关于DDS 取消并行装载功能的测试笔记,结合案例实现DDS 取消并行装载的全过程。

1,停DDS

在并行装载的时候,启停dds相当有讲究,必须按步骤来完
源端
[dds@oracleplus.net dict]$ddstop
目标端
[dds@oracleplus.net dict]$ddstop

2,修改tgt_que.cfg文件

[dds@oracleplus.net 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@oracleplus.net 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@oracleplus.net 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 hOracleоis3
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@oracleplus.net 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@oracleplus.net 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语句

oracleplus.net> insert into scott.put2 select * from dba_objects where rownum=1;

1 row created.

oracleplus.net> 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)

oracleplus.net> delete scott.put2 where rownum=1;

1 row deleted.

oracleplus.net> 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)

oracleplus.net> 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/2014/08/05/dds-%e5%8f%96%e6%b6%88%e5%b9%b6%e8%a1%8c%e8%a3%85%e8%bd%bd%e5%8a%9f%e8%83%bd.html | 认真就输

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【学习笔记】分享一篇关于 DDS取消并行装载功能的笔记

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1111.html

Oracle研究中心

关键词:

DDS学习笔记

DDS 取消并行装载功能测试