迪思杰RealSync部署手册

迪思杰RealSync部署手册 迪思杰 DSG RealSync部署手册 目录 一、在源端安装RealSync复制软件 .................................................................... 3 Step1:安装前的准备工作 .......................................................................................................................................... 3 1.创建操作系统用户 ....................................................................................................................................................... 3 2.创建数据库用户............................................................................................................................................................ 3 4.创建数据库视图............................................................................................................................................................ 3 Step2: 登陆系统主机 .................................................................................................................................................. 4 Step3:安装RealSync软件 ....................................................................................................................................... 4 Step4:启动Agent和Dbpsd .................................................................................................................................. 4 二、在目标端上安装RealSync复制软件.............................................................. 6 Step1:安装前的准备工作 .......................................................................................................................................... 6 1.创建操作系统用户 ....................................................................................................................................................... 6 3.创建数据库用户............................................................................................................................................................ 6 Step2: 登陆系统主机 .................................................................................................................................................. 6 Step3:安装RealSync软件 ....................................................................................................................................... 6 Step4:启动Agent ....................................................................................................................................................... 6 三、设置系统参数并启动复制 ............................................................................. 8 Step1:注册主机和数据库信息 ................................................................................................................................. 8 Step4:配置同步内容 ................................................................................................................................................ 17 Step4:发起首次同步 ................................................................................................................................................ 17 一、在源端安装RealSync复制软件 Step1:安装前的准备工作 1.创建操作系统用户 如果使用orcle用户安装,就不需要创建操作系统用户 2.创建数据库用户 创建oracle数据库用户:dsg 密码:dsg 赋予以下权限(复制数据用) 日常增量复制所需要的权限 grant select any table to dsg; grant select any dictionary to dsg; 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 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; create 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/media>./setup.sh 1, Please choice setup Directory, default is Current Directory [/dsg]: 输入软件安装目录:/dsg/特斯图test1 2, Please choice the Agent Type [ 1-Source , 2-Target ]: 输入安装Agent Type类型 1为源端,2为目标端 注: 这里是进行源端安装 选择 1 3, Please input Source Dbpsd port,default port is [50000]:50000 输入源端Dbpsd的端口号，默认即可， 4, Please input Source Vagentd port,default port is [50001]:50001 输入源端Vagentd的端口号，默认即可， 5, Please input Source Monitor port,default port is [50111]:50111 输入监控进程的端口号，默认即可， Please input Archive log interval,default is 12: 6, 输入日志归档的间隔时间，默认即可， 7, Are you want to install elib and bin program[y/n]: 安装bin软件和elib目录:y Step4:启动Agent和Dbpsd 1. 对复制源端的启动、停止、检查脚本位于下列目录下 $cd /dsg/test1/scripts 如果数据库是11G的需要手工设定LD_LIBRARY_PATH的路径 $./start_vagentd(启动脚本) $./check(查看脚本) 下列进程全部启动

表

关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf

明源端启动正常 [oracle@dsg_test scripts]$ ./check oracle 19445 1 0 09:45 pts/5 00:00:00 /dsg/test1/bin/dbpsd 50000 oracle 19461 1 0 09:45 pts/5 00:00:00 /dsg/ test1/bin/vagentd 50001 oracle 19469 19461 44 09:45 pts/5 00:22:00 /dsg/ test1/bin/vagentd 50001 oracle 19455 1 0 09:45 pts/5 00:00:00 /dsg/ test1/bin/sender -tseq 1 oracle 19456 19455 0 09:45 pts/5 00:00:00 /dsg/ test1/bin/sender -tseq 1 oracle 19434 1 0 09:45 ? 00:00:00 /dsg/ test1/bin/arch_vagentd_dsg /dsg/log/log.sender /dsg/log/archivelog/log.sender_archlog 43200 oracle 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 identified by dsg; grant dba to dsg; Step2: 登陆系统主机 以dsg用户登陆 Step3:安装RealSync软件 拷贝DSG提供的realsync.tar软件到相应的安装目录,利用DSG提供的安装脚本执行setup.sh 进行RealSync安装: [dsg@OraTest1 media]$ ./setup.sh 1、 Please choice setup Directory, default is Current Directory [/dsg]: 输入软件安装目录:/dsg/from10 2、Please choice the Agent Type [ 1-Source , 2-Target ]: 输入安装Agent Type类型 1为源端,2为目标端 注: 这里是进行目标端安装 选择 2 3、 Please input Target Vagentd port,default port is [50001]:50001 输入目标端Vagentd的端口号 4、 Pease input Target Verify port,default port is [50011]:50011 输入目标端Verify Vagentd的端口号 5、 Please input Source Monitor port,default port is [50111]:50111 输入监控进程的端口号，默认即可， Please Please input Archive log interval,default is 12: 6、 输入日志归档的间隔时间，默认即可， 7、 Please input the number of parallel loader process:<1-10>4 注:并发数一般选择为CPU个数的一半 8、 Are you want to install elib and bin program[y/n]: 安装bin软件和elib目录:y Step4:启动Agent 如果数据库是11G的需要手工设定LD_LIBRARY_PATH的路径 $./start_vagentd(启动脚本) $./check(检查复制进程启动状态脚本) 全部启动如下进程表明目标端进程启动正常 [oracle@dsg_test scripts]$ ./check oracle 12499 1 0 09:46 pts/2 00:00:00 /dsg/test1/bin/vagentd 50001 oracle 12500 12499 10 09:46 pts/2 00:05:20 /dsg/test1/bin/vagentd 50001 oracle 12519 1 0 09:46 pts/2 00:00:00 /dsg/test1/bin/loader -r -qno 0 1 oracle 12521 12519 0 09:46 pts/2 00:00:00 /dsg/test1/bin/loader -r -qno 0 1 oracle 12518 1 0 09:46 pts/2 00:00:00 /dsg/test1/bin/loader -s -qno 0 1 oracle 12522 12518 17 09:46 pts/2 00:09:09 /dsg/test1/bin/loader -s -qno 0 1 oracle 12509 1 0 09:46 pts/2 00:00:00 /dsg/test1/bin/loader -s -qno 1 1 oracle 12511 12509 19 09:46 pts/2 00:09:52 /dsg/test1/bin/loader -s -qno 1 1 oracle 12523 1 0 09:46 pts/2 00:00:00 /dsg/test1/bin/loader -s -qno 2 1 oracle 12524 12523 22 09:46 pts/2 00:11:32 /dsg/test1/bin/loader -s -qno 2 1 oracle 12512 1 0 09:46 pts/2 00:00:00 /dsg/test1/bin/loader -s -qno 3 1 oracle 12516 12512 27 09:46 pts/2 00:13:55 /dsg/test1/bin/loader -s -qno 3 1 oracle 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 为增量装载进程。 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] 50000 ########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 is [/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_ORACLE_HOME###### no default value,you must input!! /u01/11.2/product/db_1 Starting register Source Host and Database.[y] CHECK_MEMLEAK is turned off VMAN> Connected. DBPS> Authenticated SYNC:/> 1. System 2. Scheduler s. List current sessions q. Return to command mode ===> 1. User 2. Host 4. Database 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 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. 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 ===> 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. 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. System 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 SYSTEM 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 off VMAN> Connected. DBPS> Authenticated SYNC:/> 1. System 2. Scheduler s. List current sessions q. Return to command mode ===> 1. User 2. Host 4. Database 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 ===> 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. 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. System 2. Scheduler s. List current sessions q. Return to command mode ===> SYNC:/> SYNC:/dbs> SYNC:/dbs/test11g1.2> SYNC:/dbs/test11g1.2/schemas> ANONYMOUS CASCADE CTXSYS DBSNMP DSG MDSYS ODM ODM_MTR ORDPLUGINS ORDSYS OUTLN SCOTT SYS SYSTEM WMSYS XDB XJ SYNC:/dbs/test11g1.2/schemas> Target Host and Database Registered. Replication Configuration File Template Created. Wed Jul 2 14:08:08 EAT 2014 man22:/dsg/test1/scripts> DSG软件安装完成 Step4:配置同步内容 cd ../config vi mapping.ini XJ XJ real_where= u.name in ('XJ') full_where= u.name in ('XJ') Step4:发起首次同步 $cd /dsg/bin $ ./vman VMAN> @vm 即可发起全同步,同步完成后会自动转为实时同步。