DDS数据对比测试

DDS huangtingzhong 发布于 2014-08-11 22:30 抢沙发

DDS数据对比测试，DDS数据对比测试是基本行的数据对比

1，修改目标端对比进程个数

[dds@www.htz.pw data]$cat ddstart
#!/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/1123/bin
DDS_DATA=/oracle/app/dds/1123/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 -x这增加几行进程用于数据对比
else
    exit -1
fi

2，odmp导出对比数据

[dds@htz62 ~]$ odmp -c 192.168.111.63:8204 -x -t scott dds1/dds1
0808162429[5.DMP00]     Dump Task:    1 SCOTT.DEPT
0808162429[5.DMP00]     Dump Task:    2 SCOTT.EMP
0808162429[5.DMP00]     Dump Task:    3 SCOTT.BONUS
0808162429[5.DMP00]     Dump Task:    4 SCOTT.SALGRADE
0808162429[5.DMP00]     Dump Task:    5 SCOTT.HTZ
0808162429[5.DMP00] Starting DMP Processes (nreader=1, Verify:Y)
0808162429[5.DMP00] ok to login [dds1/dds1]
0808162429[5.DMP00] DmpOUT: 192.168.111.63:8204   HOST:192.168.111.63 PORT: 8204
0808162429[5.DMP00] GetDATA for SCOTT.DEPT
0808162429[5.DMP00] Count of Record: SCOTT.DEPT  4 DataLEN=43
0808162429[5.DMP00] Get SCOTT.DEPT Time: 124 ms
0808162429[5.DMP00] GetDATA for SCOTT.EMP
0808162429[5.DMP00] Count of Record: SCOTT.EMP  14 DataLEN=83
0808162429[5.DMP00] Get SCOTT.EMP Time: 14 ms
0808162429[5.DMP00] GetDATA for SCOTT.BONUS
0808162429[5.DMP00] Count of Record: SCOTT.BONUS  0 DataLEN=0
0808162429[5.DMP00] Get SCOTT.BONUS Time: 10 ms
0808162429[5.DMP00] GetDATA for SCOTT.SALGRADE
0808162429[5.DMP00] Count of Record: SCOTT.SALGRADE  5 DataLEN=47
0808162429[5.DMP00] Get SCOTT.SALGRADE Time: 41 ms
0808162429[5.DMP00] GetDATA for SCOTT.HTZ
0808162430[5.DMP00] Count of Record: SCOTT.HTZ  50079 DataLEN=229341
0808162430[5.DMP00] Get SCOTT.HTZ Time: 578 ms
0808162431[5.DMP00] DMP0 RC: R=0 P=0 W=0
0808162431[5.DMP00] Reader EXIT ( PID=6715 dumper=0, rc=0 )
0808162431[5.DMP00] CHILD: 6715 EXIT(0)
0808162431[5.DMP00]
+------------------------------------------+
| Dmp Finish: return=  0   SUCCESSFULE     |
+------------------------------------------+

3，目标端日志

目标端日志
0808162431[5.CHK00] Load /home/dds/dds/data/chk0/0/1.dtf (LEN=65)
0808162431[5.CHK00] Load /home/dds/dds/data/chk0/0/2.dtf (LEN=43)
0808162431[5.CHK00] Load /home/dds/dds/data/chk0/0/3.dtf (LEN=50)
0808162431[5.CHK00] Verify OK SCOTT.DEPT->HTZ.DEPT Rows: 4~4 OK:4
0808162431[5.CHK00] Load /home/dds/dds/data/chk0/0/4.dtf (LEN=64)
0808162431[5.CHK00] Load /home/dds/dds/data/chk0/0/5.dtf (LEN=83)
0808162431[5.CHK00] Load /home/dds/dds/data/chk0/0/6.dtf (LEN=49)
0808162431[5.CHK00] Verify OK SCOTT.EMP->HTZ.EMP Rows: 14~14 OK:14
0808162431[5.CHK00] Load /home/dds/dds/data/chk0/0/7.dtf (LEN=66)
0808162432[5.CHK00] Load /home/dds/dds/data/chk0/0/8.dtf (LEN=51)
0808162432[5.CHK00] Verify OK SCOTT.BONUS->HTZ.BONUS Rows: 0~0 OK:0
0808162432[5.CHK00] Load /home/dds/dds/data/chk0/0/9.dtf (LEN=69)
0808162432[5.CHK00] Load /home/dds/dds/data/chk0/0/10.dtf (LEN=47)
0808162432[5.CHK00] Load /home/dds/dds/data/chk0/0/11.dtf (LEN=54)
0808162432[5.CHK00] Verify OK SCOTT.SALGRADE->HTZ.SALGRADE Rows: 5~5 OK:5
0808162432[5.CHK00] Load /home/dds/dds/data/chk0/0/12.dtf (LEN=64)
0808162432[5.CHK00] Load /home/dds/dds/data/chk0/0/13.dtf (LEN=229341,zLEN=178104 77{ff392285dba4c735eaf57cbf839a563e19e0ca0b993d821097d934f85a596e2c})
0808162432[5.CHK00] Load /home/dds/dds/data/chk0/0/14.dtf (LEN=49)
0808162432[5.CHK00] Verify OK SCOTT.HTZ->HTZ.HTZ Rows: 50079~50079 OK:50079
0808162432[5.CHK00] Load /home/dds/dds/data/chk0/0/15.dtf (LEN=5)
0808162432[5.CHK00] End Verify objects: OK-5 ERROR-0
0808162432[5.CHK00] End Verify

4，verify日志内容

[dds@htz63 chk0]$ cat verify.txt

************************************************
Verify SCOTT.DEPT -- HTZ.DEPT
  Rows     in source table:  4
  Rows     in target table:  4
  Rows     in same   table:  4
  Rows not in source table:  0
  Rows not in target table:  0
  Rows not equal          :  0
  Rows     has Other Error:  0
  Counts of slot no  > 512:  0
  Start from: 2014-07-08 16:24:31
  End at    : 2014-07-08 16:24:31
  Total     : 0
************************************************

5，报错日志内容

如果有错误，会在下面显示出来的

[dds@htz63 chk0]$ cat verify.err

************************************************
Verify SCOTT.HTZ -- HTZ.HTZ
  Rows     in source table:  0
  Rows     in target table:  50079
  Rows     in same   table:  0
  Rows not in source table:  0
  Rows not in target table:  0
  Rows not equal          :  0
  Rows     has Other Error:  0
  Counts of slot no  > 512:  0
  Start from: 2014-07-08 16:52:46
  End at    : 2014-07-08 16:52:46
  Total     : 0
************************************************
Err to verify table SCOTT.HTZ -- HTZ.HTZ

dds数据对比