迪思杰RealSync部署手册

1、迪思杰DSG RealSync部署手册目录 TOC o 1-3 h z u HYPERLINK l _Toc392073699 一、在源端安装RealSync复制软件 PAGEREF _Toc392073699 h 2 HYPERLINK l _Toc392073700 Step1：安装前的准备工作 PAGEREF _Toc392073700 h 2 HYPERLINK l _Toc392073701 1.创建操作系统用户 PAGEREF _Toc392073701 h 2 HYPERLINK l _Toc392073702 2.创建数据库用户 PAGEREF _Toc392073702 h

2、3 HYPERLINK l _Toc392073703 4.创建数据库视图 PAGEREF _Toc392073703 h 3 HYPERLINK l _Toc392073704 Step2: 登陆系统主机 PAGEREF _Toc392073704 h 3 HYPERLINK l _Toc392073705 Step3：安装RealSync软件 PAGEREF _Toc392073705 h 4 HYPERLINK l _Toc392073706 Step4：启动Agent和Dbpsd PAGEREF _Toc392073706 h 5 HYPERLINK l _Toc392073707 二

3、、在目标端上安装RealSync复制软件 PAGEREF _Toc392073707 h 5 HYPERLINK l _Toc392073708 Step1：安装前的准备工作 PAGEREF _Toc392073708 h 5 HYPERLINK l _Toc392073709 1.创建操作系统用户 PAGEREF _Toc392073709 h 5 HYPERLINK l _Toc392073710 3.创建数据库用户 PAGEREF _Toc392073710 h 5 HYPERLINK l _Toc392073711 Step2: 登陆系统主机 PAGEREF _Toc392073711

4、 h 6 HYPERLINK l _Toc392073712 Step3：安装RealSync软件 PAGEREF _Toc392073712 h 6 HYPERLINK l _Toc392073713 Step4：启动Agent PAGEREF _Toc392073713 h 7 HYPERLINK l _Toc392073714 三、设置系统参数并启动复制 PAGEREF _Toc392073714 h 8 HYPERLINK l _Toc392073715 Step1：注册主机和数据库信息 PAGEREF _Toc392073715 h 8 HYPERLINK l _Toc3920737

5、16 Step4：配置同步内容 PAGEREF _Toc392073716 h 12 HYPERLINK l _Toc392073717 Step4：发起首次同步 PAGEREF _Toc392073717 h 12一、在源端安装RealSync复制软件Step1：安装前的准备工作1.创建操作系统用户如果计划使用orcle用户安装，就不需要创建操作系统用户2.创建数据库用户创建oracle数据库用户：dsg 密码：dsg赋予以下权限(复制数据用) 日常增量复制所需要的权限grant select any table to dsg;grant select any dictionary to d

6、sg;grant connect,resource to dsg; 首次同步需要的权限grant alter system to dsg;grant exp_full_database to dsg;grant execute on sys.dbms_ijob to dsg;4.创建数据库视图用sys用户登陆oracle系统:在oracle 上：connect /as sysdba;用sys用户在源端数据库上创建以下视图：create or replace view DBPS_XKCCLE as select * from sys.x$kccle;create or replace view

7、DBPS_XKCCLH as select * from sys.x$kcclh;create or replace view DBPS_XKCCCF as select * from sys.x$kcccf;create or replace view DBPS_XKCCCP as select * from sys.x$kcccp;create or replace view DBPS_XKCCDI as select * from sys.x$kccdi;create or replace view DBPS_XKCRMF as select * from sys.x$kcrmf;cre

8、ate or replace view DBPS_XKTUXE as select * from sys.x$ktuxe;create or replace view DBPS_XLE as select * from sys.x$le;create or replace view DBPS_XBH as select * from sys.x$bh;Step2: 登陆系统主机以oracle用户登陆Step3：安装RealSync软件拷贝DSG提供的realsync.tar软件到相应的安装目录，利用DSG提供的安装脚本执行setup.sh进行RealSync安装：man22:/dsg/medi

9、a./setup.shPlease choice setup Directory, default is Current Directory /dsg:输入软件安装目录：/dsg/特斯图test1Please choice the Agent Type 1-Source , 2-Target :输入安装Agent Type类型 1为源端，2为目标端 注： 这里是进行源端安装 选择 1Please input Source Dbpsd port,default port is 50000:50000输入源端Dbpsd的端口号（默认即可）Please input Source Vagentd po

10、rt,default port is 50001:50001输入源端Vagentd的端口号（默认即可）Please input Source Monitor port,default port is 50111:50111输入监控进程的端口号（默认即可）Please input Archive log interval,default is 12:输入日志归档的间隔时间（默认即可）Are you want to install elib and bin programy/n: 安装bin软件和elib目录：yStep4：启动Agent和Dbpsd对复制源端的启动、停止、检查脚本位于下列目录下$

11、cd /dsg/test1/scripts如果数据库是11G的需要手工设定LD_LIBRARY_PATH的路径$./start_vagentd(启动脚本)$./check(查看脚本) 下列进程全部启动表明源端启动正常oracledsg_test scripts$ ./checkoracle 19445 1 0 09:45 pts/5 00:00:00 /dsg/test1/bin/dbpsd 50000oracle 19461 1 0 09:45 pts/5 00:00:00 /dsg/ test1/bin/vagentd 50001oracle 19469 19461 44 09:45 pt

12、s/5 00:22:00 /dsg/ test1/bin/vagentd 50001oracle 19455 1 0 09:45 pts/5 00:00:00 /dsg/ test1/bin/sender -tseq 1oracle 19456 19455 0 09:45 pts/5 00:00:00 /dsg/ test1/bin/sender -tseq 1oracle 19434 1 0 09:45 ? 00:00:00 /dsg/ test1/bin/arch_vagentd_dsg /dsg/log/log.sender /dsg/log/archivelog/log.sender_

13、archlog 43200oracle 19433 1 0 09:45 ? 00:00:00 /dsg/ test1/bin/arch_vagentd_dsg /dsg/ test1/log/log.vagentd /dsg/ test1/log/archivelog/log.vagentd_archlog 43200二、在目标端上安装RealSync复制软件Step1：安装前的准备工作1.创建操作系统用户如果计划使用orcle用户安装，就不需要创建操作系统用户3.创建数据库用户创建oracle数据库用户：dsg 密码：dsg赋予dba权限(复制数据用)create user dsg iden

14、tified by dsg;grant dba to dsg;Step2: 登陆系统主机以dsg用户登陆Step3：安装RealSync软件拷贝DSG提供的realsync.tar软件到相应的安装目录，利用DSG提供的安装脚本执行setup.sh进行RealSync安装：dsgOraTest1 media$ ./setup.shPlease choice setup Directory, default is Current Directory /dsg:输入软件安装目录：/dsg/from102、Please choice the Agent Type 1-Source , 2-Target

15、 :输入安装Agent Type类型 1为源端，2为目标端 注： 这里是进行目标端安装 选择 2Please input Target Vagentd port,default port is 50001:50001输入目标端Vagentd的端口号Pease input Target Verify port,default port is 50011:50011 输入目标端Verify Vagentd的端口号Please input Source Monitor port,default port is 50111:50111输入监控进程的端口号（默认即可）Please Please inpu

16、t Archive log interval,default is 12:输入日志归档的间隔时间（默认即可）Please input the number of parallel loader process:4 注：并发数一般选择为CPU个数的一半Are you want to install elib and bin programy/n: 安装bin软件和elib目录：yStep4：启动Agent如果数据库是11G的需要手工设定LD_LIBRARY_PATH的路径$./start_vagentd(启动脚本)$./check(检查复制进程启动状态脚本) 全部启动如下进程表明目标端进程启动正

17、常oracledsg_test scripts$ ./checkoracle 12499 1 0 09:46 pts/2 00:00:00 /dsg/test1/bin/vagentd 50001oracle 12500 12499 10 09:46 pts/2 00:05:20 /dsg/test1/bin/vagentd 50001oracle 12519 1 0 09:46 pts/2 00:00:00 /dsg/test1/bin/loader -r -qno 0 1oracle 12521 12519 0 09:46 pts/2 00:00:00 /dsg/test1/bin/loa

18、der -r -qno 0 1oracle 12518 1 0 09:46 pts/2 00:00:00 /dsg/test1/bin/loader -s -qno 0 1oracle 12522 12518 17 09:46 pts/2 00:09:09 /dsg/test1/bin/loader -s -qno 0 1oracle 12509 1 0 09:46 pts/2 00:00:00 /dsg/test1/bin/loader -s -qno 1 1oracle 12511 12509 19 09:46 pts/2 00:09:52 /dsg/test1/bin/loader -s

19、 -qno 1 1oracle 12523 1 0 09:46 pts/2 00:00:00 /dsg/test1/bin/loader -s -qno 2 1oracle 12524 12523 22 09:46 pts/2 00:11:32 /dsg/test1/bin/loader -s -qno 2 1oracle 12512 1 0 09:46 pts/2 00:00:00 /dsg/test1/bin/loader -s -qno 3 1oracle 12516 12512 27 09:46 pts/2 00:13:55 /dsg/test1/bin/loader -s -qno

20、3 1oracle 12493 1 0 09:46 ? 00:00:00 /dsg/test1/bin/arch_vagentd_dsg /dsg/test1/log/log.r0 /dsg/test1/log/archivelog/log.r0_archlog 43200进程说明：vagentd进程是DSG RealSync的XF1文件接收进程，用来接收从源端sender进程发送过来的XF1文件。loader进程将vagentd接收的XF1文件装载到数据库中其中loader s 为首次同步装载进程，启动的个数跟并发数有关 注：上图为6个并发装载进程显示的结果 loader r 为增量装载进程

21、。arch_vagentd_realsync进程是DSG RealSync的归档进程，它会根据设置自动的将realsync运行时生成的日志进行归档处理，避免由于日志过大无法进行查看。$./stop(停止脚本)三、设置系统参数并启动复制Step1：注册主机和数据库信息man22:/dsg/test1/scripts./reg: not found.now! we will config the realsync! you must start_vagentd for source and target!#SVR_PORT#default source dbpsd port is 50000 50

22、000#SOURCE_HOST_IP#default source ip is localhost #SOURCE_AGENT_PORT#default source agent port is 50001 #SOURCE_DB_USER#default source user is dsg #SOURCE_DB_PSWD#default source user pswd is dsg #SOURCE_ORACLE_SID#default source ORACLE_SID is test11g1 #SOURCE_ORACLE_HOME#default source ORACLE_HOME i

23、s /u01/11.2/product/db_1 #TARGET_HOST_IP#no default value,you must input! 180.2.30.231#TARGET_AGENT_PORT#default target agent port is 50001 #TARGET_DB_USER# default target user is dsg#TARGET_DB_PSWD# default target user pswd is dsg#TARGET_ORACLE_SID# no default value,you must input!test11g1#TARGET_O

24、RACLE_HOME# no default value,you must input!/u01/11.2/product/db_1Starting register Source Host and Database.y CHECK_MEMLEAK is turned offVMAN Connected.DBPS AuthenticatedSYNC:/ 1. System 2. Scheduler s. List current sessions q. Return to command mode= 1. User 2. Host 4. Database q. quit = 1. List a

25、ll 2. List one in detail 3. Add 4. Delete 5. Edit 6. Detect and update hardware/os_type/vagentd q. quit = HID: Host Name: Agent Port: 2688 Enabled: Y VcfsHostNew: host localhost used by HID:1VcfsHostNew: host localhost used by HID:1 1. List all 2. List one in detail 3. Add 4. Delete 5. Edit 6. Detec

26、t and update hardware/os_type/vagentd q. quit = 1. User 2. Host 4. Database q. quit = 1. List all 2. List one in detail 3. Add 4. Delete 5. Edit q. quit = DBID: Please select data source type: 1. Oracle 2. DB2 3. Sybase 4. Sql Server 5. Informix 6. Lotus Notes 7. Exchange Server 8. Access Server 9.

27、File Server (for generic files/directries)Data Source Type: Host Name: DB Name: DB User: DB Password: OS Owner: OS Group: SID: TNS Name: ORACLE_HOME: TNS Admin: Data source test11g1 added 1. List all 2. List one in detail 3. Add 4. Delete 5. Edit q. quit = 1. User 2. Host 4. Database q. quit = 1. Sy

28、stem 2. Scheduler s. List current sessions q. Return to command mode= SYNC:/ SYNC:/dbs SYNC:/dbs/.1 SYNC:/dbs/.1/schemas ANONYMOUS CASCADE CTXSYS DBSNMP DSG GOLDENGATE HR MDSYS ODM ODM_MTR OE ORDPLUGINS ORDSYS OUTLN PM QS QS_ADM QS_CB QS_CBADM QS_CS QS_ES QS_OS QS_WS RUNZHI1 RUNZHI2 SCOTT SH SYS SYS

29、TEM TEST3 WKPROXY WKSYS WMSYS XDB XJ SYNC:/dbs/.1/schemas Source Host and Database Registered.Starting Register Target Host and Database.CHECK_MEMLEAK is turned offVMAN Connected.DBPS AuthenticatedSYNC:/ 1. System 2. Scheduler s. List current sessions q. Return to command mode= 1. User 2. Host 4. Da

30、tabase q. quit = 1. List all 2. List one in detail 3. Add 4. Delete 5. Edit 6. Detect and update hardware/os_type/vagentd q. quit = HID: Host Name: Agent Port: 2688 Enabled: Y VcfsHostNew: host 180.2.30.231 used by HID:2VcfsHostNew: host 180.2.30.231 used by HID:2 1. List all 2. List one in detail 3. Add 4. Delete 5. Edit 6. Detect and update hardware/os_type/vagentd q. quit = 1. User 2. Host 4. Database q. quit = 1. List all 2. List one in detail 3. Add 4. Delete 5. Edit q. quit =