R7模拟测试方案.doc

R7-DIP数据库同步软件测试目录1测试目的42测试环境43系统安装43.1生产数据库的配置53.2目标数据库的配置53.3R7-DIP软件的安装配置54系统测试条目和测试结果6文档控制修改记录日期作者版本修改记录2012-5-10分发拷贝No.姓名分发时间单位11 测试目的本测试是为了验证R7-DIP数据库同步软件在满足理想集团在数据复制需求上的满足程度，通过手工模拟的方式对我系统运维过程中经常需要用到的操作进行测试，一是加深对R7复制软件的了解，同时掌握同步软件是否能够满足业务需求。2 测试环境本次测试采用了模拟测试方式，搭建了一个模拟生产系统，通过编写各种脚本模拟业务操作，对同步软件进行测试。本次测试的环境是在2台虚拟机上进行，逻辑结构如下：3 系统安装本测试报告未包括模拟生产数据库和目标库的安装配置，只记录了与R7-DIP相关的安装。3.1 生产数据库的配置#su oracle$sqlplus / as sysdba打开归档日志创建r7表空间 r7（大小为4G）SQL create user r7 identified by r7 default tablespace r7;SQL grant connect to r7;SQL grant select any dictionary to r7;SQL grant select any table to r7;SQL grant select any transaction to r7;SQL grant exp_full_database to r7;SQL grant EXECUTE_CATALOG_ROLE to r7;SQL grant execute on dbms_flashback to r7;SQLalter database add supplemental log data (primary key,unique index) columns;SQL select SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI from v$database;SUPPLEME SUP SUP- - -IMPLICIT YES YES3.2 目标数据库的配置#su oracle$sqlplus / as sysdbaSQL create user r7 identified by r7;SQLgrant dba to r7;3.3 R7-DIP软件的安装配置（1）安装配置R7-DIP软件见install guard（3）启动R7-DIP软件$ dcl_dipserver startup Data Replication Software betwen Database.Copyright (c) 2010, R7data Inc, all right reserved.Release - 1.0.0.0, build at 2012-04-08 20:03:10 for Linux on i686System Initializing .System Startup OK .4 系统测试条目和测试结果测试项目测试方法测试内容分析数据初始化（1）支持的初始化方法R7-DIP只需要目标库和源库数据一致即可进行运行可以采用以下几种方法进行初始化：（1）RMAN：通过备份恢复方式将生产库的数据备份恢复到目标库。（2）导入导出：可通过oracle工具EXP/IMP 或者expdp/impdp方式进行初始化（3）其他方式：例如通过insert/select方式进行的初始化（2）初始化和实时复制的衔接，是否需要业务中断R7-DIP通过SCN的衔接来实现初始化和实时数据的衔接。SQL select current_scn from v$database;CURRENT_SCN- 2099209717expdp r7/r7 schemas=xuliang TABLE_EXISTS_ACTION=replace FLASHBACK_SCN=44469748 logfile=imp.log JOB_NAME=IMPDP PARALLEL=4启动dcl_capture进程Start capture start_scn 44469748成功DML实时同步insertcreate table test_normal (id number(10),name varchar2(4000),birth date);alter table test_normal add constraint pk_test_normal primary key (id);truncate table test_normal;begin for I in 1. 1000 loop insert into test_normal (id,name,birth) values (I,aaaaaa|I,sysdate);end loop;commit;end;/生产端SQL select count(*) from test_normal; COUNT(*)- 1000目标端SQL select count(*) from test_normal; COUNT(*)- 1000成功普通表updateUpdate test_normal set name=name|sysdate;Commit;源库:SQL select * from test_normal where rownum select * from test_normal where id=168; ID-NAME-BIRTH- 168aaaaaa16811-5月 -1211-5月 -12成功普通表deleteDelete from test_normal where rownum select count(*) from test_normal; COUNT(*)- 991目标库SQL select count(*) from test_normal; COUNT(*)- 991成功Chained row 表insertcreate table TEST_CR( ID NUMBER, F1 VARCHAR2(4000), F2 VARCHAR2(4000), F3 VARCHAR2(4000);truncate table test_cr;begin for i in 1. 500 loop insert into test_cr (id,f1,f3) values (i, rpad(i,2,b), rpad(i,2048,c); end loop; commit;end;/源库：SQL desc test_cr; Name Null? Type - - - ID NUMBER F1 VARCHAR2(4000) F2 VARCHAR2(4000) F3 VARCHAR2(4000)SQL desc test_cr; Name Null? Type - - - ID NUMBER F1 VARCHAR2(4000) F2 VARCHAR2(4000) F3 VARCHAR2(4000)源库：SQL select count(*) from test_cr; COUNT(*)- 500目标：SQL select count(*) from test_cr; COUNT(*)- 500成功Chained row updateupdate test_cr set f1= rpad(id,1024,b);commit;源库：SQL select length(f1) from test_cr where rownum select length(f1) from test_cr where rownum2;LENGTH(F1)- 1024成功Chained row deletedelete from test_cr where rownum select count(*) from test_cr; COUNT(*)- 491目标库：SQL select count(*) from test_cr; COUNT(*)- 491成功手工从pl/sql developer上修改数据Select * from test_cr for update;通过Plsql工具手工修改了id=12 f1字段为test.源库：SQL select f1 from test_cr where id=12;F1-Test目标库：SQL select f1 from test_cr where id=12;F1-test成功DDL测试create table test_ddl_1 (id number(10),name varchar2(4000),birth date);目标库：SQL desc test_ddl_1F1-Test成功alter table test_ddl_1 add constraint pk_test_ddl_1 primary key (id);源库：SQL select constraint_name from dba_constraints where table_name=TEST_DDL_1;CONSTRAINT_NAME-PK_TEST_DDL_1目标库：SQL select constraint_name from dba_constraints where table_name=TEST_DDL_1;CONSTRAINT_NAME-PK_TEST_DDL_1成功Alter table test_ddl_1 add (remark varchar2(1000);源库SQL Alter table test_ddl_1 add (remark varchar2(1000);Table altered.目标段：SQL desc test_ddl_1; Name Null? Type - - - ID NOT NULL NUMBER(10) NAME VARCHAR2(4000) BIRTH DATE REMARK VARCHAR2(1000)成功Alter table test_ddl_1 modify (remark varchar2(2000);源库：SQL Alter table test_ddl_1 modify (remark varchar2(2000);Table altered.目标库：SQL desc test_ddl_1; Name Null? Type - - - ID NOT NULL NUMBER(10) NAME VARCHAR2(4000) BIRTH DATE REMARK VARCHAR2(2000)成功Alter table test_ddl_1 drop column remark;源库：SQL Alter table test_ddl_1 drop column remark;Table altered.目标库：SQL desc test_ddl_1; Name Null? Type - - - ID NOT NULL NUMBER(10) NAME VARCHAR2(4000) BIRTH DATE成功Create index idx_test_normal_name on test_normal (name);源库：SQL Create index idx_test_normal_name on test_normal (name);Index created.目标库：SQL select index_name from dba_indexes where table_name=TEST_NORMAL;INDEX_NAME-PK_TEST_NORMALIDX_TEST_NORMAL_NAME成功CREATE OR REPLACE TYPE OB_AC01 AS OBJECT( ACNT_YM VARCHAR2(7), TAX_AREA VARCHAR2(1), ACCOUNT_CODE_4 VARCHAR2(1), ACCOUNT_CODE_56 VARCHAR2(2), PREMIUM NUMBER(14, 4), PREM_RESERVE_TAX NUMBER(14, 4), SURRENDER_SURPLUS NUMBER(14, 4), RI_PREM NUMBER(14, 4), RI_COMM NUMBER(14, 4), PREMIUM_CASH NUMBER(14, 4), STABLE_FUND NUMBER(14, 4), BUSINESS_TAX NUMBER(14, 4), STAMP_TAX NUMBER(14, 4), RI_MODE_PREM NUMBER(14, 4), CONSTRUCTOR FUNCTION OB_AC01 RETURN SELF AS RESULT)目标段：SQL desc OB_AC01; Name Null? Type - - - ACNT_YM VARCHAR2(7) TAX_AREA VARCHAR2(1) ACCOUNT_CODE_4 VARCHAR2(1) ACCOUNT_CODE_56 VARCHAR2(2) PREMIUM NUMBER(14,4) PREM_RESERVE_TAX NUMBER(14,4) SURRENDER_SURPLUS NUMBER(14,4) RI_PREM NUMBER(14,4) RI_COMM NUMBER(14,4) PREMIUM_CASH NUMBER(14,4) STABLE_FUND NUMBER(14,4) BUSINESS_TAX NUMBER(14,4) STAMP_TAX NUMBER(14,4) RI_MODE_PREM NUMBER(14,4)METHOD- FINA