怎么部署SharePlex環(huán)境-創(chuàng)新互聯(lián)
這篇文章主要講解了“怎么部署SharePlex環(huán)境”，文中的講解內(nèi)容簡單清晰，易于學(xué)習(xí)與理解，下面請大家跟著小編的思路慢慢深入，一起來研究和學(xué)習(xí)“怎么部署SharePlex環(huán)境”吧！
目標在 Linux 系統(tǒng)下安裝 Oracle；利用 SharePlex 實現(xiàn)數(shù)據(jù)同步；可復(fù)制 DML 和 DDL 操作
一、環(huán)境描述
| 源端 | 目標端 | |
|---|---|---|
| 操作系統(tǒng) | linux 7.6 | linux 7.6 |
| IP | 192.168.66.111 | 192.168.66.112 |
| 數(shù)據(jù)庫版本 | 19.3.0.0.0 | 19.3.0.0.0 |
二、數(shù)據(jù)庫準備
創(chuàng)建shareplex專用表空間
create tablespace splex_tbs datafile '/oradata/datafile/splex_tbs01.dbf' size 1G;
數(shù)據(jù)庫開歸檔
開啟補充日志
alter database add supplemental log data (primary key, unique index) columns;
二、SharePlex 安裝（源 & 目標）
解壓安裝
使用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，配置時如果需要自定義復(fù)制的源與目標端的ORACLE_SID，則需要配置tnsnames.ora別名，且/etc/oratab中必須有對應(yīng)于自定義的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 & 啟動
可以使用該參數(shù)指定 shareplex 啟動到指定的 IP 上，可以使用 netstat -an | grep <port_number>
啟動 -u可以啟動shareplex實例到指定端口，可以復(fù)制多個庫。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. *******************************************************
狀態(tài)驗證
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
三、同步配置
創(chuàng)建配置文件(源數(shù)據(jù)庫)
sp_ctrl控制臺
SharePlex日常操作都在sp_ctrl控制臺中進行，啟動命令為：/<prodir>/bin/sp_ctrl,一般啟動之后首先進入控制臺執(zhí)行sp_ctrl > stop post，停止。sp_ctrl (node2:2100)> stop post
config 配置文件
Config配置文件為復(fù)制鏈路需要復(fù)制對象以及鏈路映射文件。列出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
復(fù)制修改配置文件
sp_ctrl (node1:2100)> copy config ORA_config to test_config # 復(fù)制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或主機名后加冒號，可以為該表復(fù)制單獨起一個隊列。
mary.cust2!key(c1,c2) mary.cust2 proda@o.sid --自定義pk
config 生效
sp_ctrl (node1:2100)> activate config test_config
驗證Capture、Read和Export進程是否被創(chuàng)建
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)>
同步數(shù)據(jù)
開啟同步(目標端)
設(shè)置恢復(fù)的起點(源端需要有數(shù)據(jù)流入)
sp_ctrl (node2:2100)> reconcile queue splex_hr for o.orcl-o.orcl scn 1573836
開啟同步
sp_ctrl (node2:2100)> start post
感謝各位的閱讀，以上就是“怎么部署SharePlex環(huán)境”的內(nèi)容了，經(jīng)過本文的學(xué)習(xí)后，相信大家對怎么部署SharePlex環(huán)境這一問題有了更深刻的體會，具體使用情況還需要大家實踐驗證。這里是創(chuàng)新互聯(lián)，小編將為大家推送更多相關(guān)知識點的文章，歡迎關(guān)注！
當前名稱：怎么部署SharePlex環(huán)境-創(chuàng)新互聯(lián)
文章轉(zhuǎn)載：http://muchs.cn/article0/dheeoo.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供外貿(mào)網(wǎng)站建設(shè)、網(wǎng)站策劃、外貿(mào)建站、網(wǎng)站排名、軟件開發(fā)、自適應(yīng)網(wǎng)站
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)
猜你還喜歡下面的內(nèi)容
- 自適應(yīng)網(wǎng)站有哪些缺點？ 2021-11-19
- 成都了解自適應(yīng)和自適應(yīng)網(wǎng)站設(shè)計之間的區(qū)別 2023-02-11
- 網(wǎng)站建造與自適應(yīng)網(wǎng)站建設(shè) 2023-03-24
- 自適應(yīng)網(wǎng)站建設(shè)有什么優(yōu)勢 2021-08-16
- 成都網(wǎng)站建設(shè)之自適應(yīng)網(wǎng)站設(shè)計受歡迎的原因介紹 2016-10-18
- 自適應(yīng)網(wǎng)站建設(shè)的三個規(guī)范要求 2022-10-22
- 企業(yè)營銷型網(wǎng)站制作是否應(yīng)該選擇自適應(yīng)網(wǎng)站設(shè)計? 2022-08-10
- 如何判斷響應(yīng)式網(wǎng)站和自適應(yīng)網(wǎng)站 2016-10-07
- 自適應(yīng)網(wǎng)站建設(shè)有哪些優(yōu)勢 2021-01-01
- 深度刨析自適應(yīng)網(wǎng)站設(shè)計的特點 2021-04-29
- 什么是自適應(yīng)網(wǎng)站？與傳統(tǒng)式網(wǎng)站有哪些區(qū)別？ 2023-03-15
- 響應(yīng)時和自適應(yīng)網(wǎng)站設(shè)計布局如何選擇 2022-06-02