溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
這篇文章主要講解了“怎么部署SharePlex環境”，文中的講解內容簡單清晰，易于學習與理解，下面請大家跟著小編的思路慢慢深入，一起來研究和學習“怎么部署SharePlex環境”吧！
目標在 Linux 系統下安裝 Oracle；利用 SharePlex 實現數據同步；可復制 DML 和 DDL 操作
| 源端 | 目標端 | |
|---|---|---|
| 操作系統 | linux 7.6 | linux 7.6 |
| IP | 192.168.66.111 | 192.168.66.112 |
| 數據庫版本 | 19.3.0.0.0 | 19.3.0.0.0 |
創建shareplex專用表空間
create tablespace splex_tbs datafile '/oradata/datafile/splex_tbs01.dbf' size 1G;
數據庫開歸檔
開啟補充日志
alter database add supplemental log data (primary key, unique index) columns;
解壓安裝
使用oracle用戶解壓，安裝。
node1-orcl[oracle]/home/oracle>./SharePlex-9.2.1-b39-ONEOFF-rhel-amd64-m64.tpm Unpacking .................................................................. .......................................................................... .......................................................................... .......................................................................... .......................................................................... .......................................................................... .......................................................................... .......................................................................... .......................................................................... .......................................................................... .......................................................................... .......................................................................... .......................................................................... ................................ SharePlex installation program: SharePlex Version: 9.2.1 Build platform: rhel-amd64 Target platform: lin-amd64 Please enter the product directory location? /home/oracle/splex/soft Please enter the variable data directory location? /home/oracle/splex/data Please specify the SharePlex Admin group (select a number): 1. [oinstall] 2. dgdba 3. kmdba 4. backupdba 5. dba 6. oper ? 5 Please enter the TCP/IP port number for SharePlex communications? [2100] Preparing to install SharePlex v.9.2.1: User: oracle Admin Group: dba Product Directory: /home/oracle/splex/soft Variable Data Directory: /home/oracle/splex/data Proceed with installation? [yes] Installing ................................................................ ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ............................... Setting file ownerships ................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ............................................ Setting file permissions .................................................. ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ......................................................................... ............................................. Do you have a valid SharePlex v. 9.2.1 license? [yes] Please enter the License key? 序列號 Please enter the customer name associated with this license key? CHINA MINISTRY OF RAILWAY SharePlex v. 9.2.1 license validation successful: Customer Name: CHINA MINISTRY OF RAILWAY License Key: 序列號 Product Name: SharePlex for Oracle - RAC License Key Type: "Perpetual Key" NOTE: You can upgrade this license key or add license keys for additional machines by executing utility /home/oracle/splex/soft/install/splex_add_key. Installation log saved to: /home/oracle/.shareplex/INSTALL-SharePlex-9.2.1-1911290513.log SharePlex v.9.2.1 installation successful.
ora_setup配置
配置shareplex，配置時如果需要自定義復制的源與目標端的ORACLE_SID，則需要配置tnsnames.ora別名，且/etc/oratab中必須有對應于自定義的tnsnames別名的ORACLE_SID。
node1-orcl[oracle]/home/oracle/splex/soft/bin>./ora_setup Welcome to the Oracle SharePlex setup process for port 2100. This process creates tables and user accounts needed to run Oracle SharePlex replication. Will the SharePlex install be using a BEQUEATH connection? (Entering 'n' implies a SQL*net connection) [y] : Please note the following: ** In response to prompts, a carriage return will choose the default given in brackets. If there is no default, a reply must be entered. ** To exit the program while the program is waiting for input, use the CTRL-C key sequence. This sequences can be entered by holding down the CONTROL key and pressing the C key. Enter the Oracle SID for which SharePlex should be installed [orcl] : In order to create the SharePlex tables and user account, we must connect to the database as a DBA user Enter a DBA user for orcl : system Enter password for the DBA account, which will not echo : connecting--This may take a few seconds. validating user name and password. . . This may take a few seconds. SharePlex objects will need to be created under a special account. You can pick an existing user or create a new one. Would you like to create a new SharePlex user ? [y] : Enter username for new user [splex/splex] : Warning: This user is now being granted unlimited tablespace. This privilege will remain in effect until it is explicitly changed. Granting select on sys.user$ to splex SPLEX_ROLE_BOTH already exists; continuing setup . . . Do you want to enable replication of tables with TDE? [n] : To enable replication of tables with TDE in the future, please rerun ora_setup. Setup will now install SharePlex objects. These are the existing tablespaces. SYSTEM SYSAUX UNDOTBS1 TEMP USERS SPLEX_TBS Enter the default tablespace for use by SharePlex [USERS] : SPLEX_TBS Enter the temporary tablespace for use by SharePlex [TEMP] : Enter the index tablespace for use by SharePlex [ ] : SPLEX_TBS Creating SharePlex objects [Installation type: Fresh]. . . Creating SharePlex Oracle-timezone-region map . . . Done. Creating Conflict Resolution Package . . . Done. Creating SharePlex Dataequator package . . . Loading Compare Package from "/home/oracle/splex/soft/util/sp_deq_pkg.plb"...Done. Note: The SharePlex object that supports replication of SDO_GEOMETRY cannot be installed because the Oracle Spatial and Graph feature is not installed. Do you want to continue with the setup without support for SDO_GEOMETRY? [n] : y Will the current setup for sid: [orcl] be used as source (including cases as source for failover or master-master setups)? [y] : Setup of SharePlex objects successful . . . Changing SharePlex connection database . . . Setup of orcl completed successfully -- The datasource identifier in the SharePlex configuration is 'o.orcl' --
sp_cop -u 2300 & 啟動
可以使用該參數指定 shareplex 啟動到指定的 IP 上，可以使用 netstat -an | grep <port_number>
啟動 -u可以啟動shareplex實例到指定端口，可以復制多個庫。
node1-orcl[oracle]/home/oracle/splex/soft/bin>./sp_cop & [1] 2672 node1-orcl[oracle]/home/oracle/splex/soft/bin> ******************************************************* * SharePlex for Oracle Startup * Copyright 2018 Quest Software Inc. * ALL RIGHTS RESERVED. * Protected by U.S. Patents: 7,461,103 and 7,065,538 * Version: 9.2.1.39-m64-ONEOFF-SPO17172-SPO17624C-SPO17384-SPO17377-oracle * VarDir : /home/oracle/splex/data * Port : 2100 * * IMPORTANT SECURITY NOTICE: * * YOU HAVE NOT YET SELECTED THE NETWORK SECURITY MODEL. * PLEASE RUN: * * sp_security --setup * * TO SELECT YOUR NETWORK SECURITY MODEL. *******************************************************
狀態驗證
node1-orcl[oracle]/home/oracle/splex/soft/bin>./sp_ctrl ******************************************************* * SharePlex Command Utility * Copyright 2018 Quest Software Inc. * ALL RIGHTS RESERVED. * Protected by U.S. Patents: 7,461,103 and 7,065,538 ******************************************************* sp_ctrl (node1:2100)> status Brief Status for node1 Process State PID Running Since --------------- ------------------------------ -------- -------------------- Cop Running 2672 29-Nov-19 05:18:20 Cmd & Ctrl Running 2696 29-Nov-19 05:18:34 There are no active configuration files
創建配置文件(源數據庫)
sp_ctrl控制臺
SharePlex日常操作都在sp_ctrl控制臺中進行，啟動命令為：/<prodir>/bin/sp_ctrl,一般啟動之后首先進入控制臺執行sp_ctrl > stop post，停止。
sp_ctrl (node2:2100)> stop post
config 配置文件
Config配置文件為復制鏈路需要復制對象以及鏈路映射文件。
列出config文件
sp_ctrl (node1:2100)> list config # 列出config文件 File Name State Datasource -------------------------------------------------- ---------- --------------- ORA_config Inactive o.SOURCE_SID Last Modified At: 26-Nov-19 09:13 Size: 151
復制修改配置文件
sp_ctrl (node1:2100)> copy config ORA_config to test_config # 復制config文件 sp_ctrl (node1:2100)> edit config test_config # 修改config文件 datasource:o.orcl #source tables target tables routing map #splex.demo_src splex.demo_dest target_system:進程名@o.target_sid expand hr.% hr.% 192.168.66.112:splex_hr@o.orcl
splex.demo_src --源庫的用戶名.表名，可以使用%通配符，全匹配半匹配等。priv%not(table_name)排除表。
splex.demo_dest --目標庫的用戶名.表名
target_system@o.target_sid --目標庫的IP或hosts文件中映射名@為目標端的sid或別名。
hr.test hr.test 192.168.204.151:scott_tab@o.honor1 --IP或主機名后加冒號，可以為該表復制單獨起一個隊列。
mary.cust2!key(c1,c2) mary.cust2 proda@o.sid --自定義pk
config 生效
sp_ctrl (node1:2100)> activate config test_config
驗證Capture、Read和Export進程是否被創建
sp_ctrl (node1:2100)> show Process Source Target State PID ---------- ------------------------------------ ---------------------- -------------------- ------ Capture o.orcl Running 60407 Read o.orcl Running 60423 Export node1 node2 Running 60438 sp_ctrl (node1:2100)> show capture detail Host: node1 System time: 28-Nov-19 10:17:58 Operations Source Status Captured Since ---------- --------------- ---------- ------------------ o.orcl Running 0 28-Nov-19 09:34:52 Oracle current redo log : 25 Capture current redo log : 25 Capture log offset : 10206852 Last change processed: Operation on SHAREPLEX internal table at 11/28/19 10:17:55 Capture state : Processing Activation id : 2 Error count : 0 Operations captured : 0 Transactions captured : 0 Concurrent sessions : 0 HWM concurrent sessions : 2 Checkpoints performed : 23 Total operations processed : 3948 Total transactions completed : 3948 Total Kbytes read : 0 Redo records in progress : 0 Redo records processed : 18556 Redo records ignored : 14608 Redo records - last HRID : N/A sp_ctrl (node1:2100)> show export Host : node1 Queue : node1 Kbytes Target Status Exported Since Total Backlog ---------- --------------- ------------ ------------------ ---------- ---------- node2 Running 12 28-Nov-19 09:34:56 0 0 sp_ctrl (node1:2100)>
同步數據
開啟同步(目標端)
設置恢復的起點(源端需要有數據流入)
sp_ctrl (node2:2100)> reconcile queue splex_hr for o.orcl-o.orcl scn 1573836
開啟同步
sp_ctrl (node2:2100)> start post
感謝各位的閱讀，以上就是“怎么部署SharePlex環境”的內容了，經過本文的學習后，相信大家對怎么部署SharePlex環境這一問題有了更深刻的體會，具體使用情況還需要大家實踐驗證。這里是億速云，小編將為大家推送更多相關知識點的文章，歡迎關注！
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
