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 =