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这个默认通道内完成 |
DDS 取消并行装载功能：等您坐沙发呢！