Step by Step TimesTen --- DataStore的雙向複製( 二)
Step 4, 檢視replication 的狀態
1,A機器:
$ ttRepAdmin -showstatus fxtest_aa
Replication Agent Status as of: 2008-08-18 15:49:46
DSN : fxtest_aa
Process ID : 18411 (Started)
Replication Agent Policy : manual
Host : BJINMS216.BJ.COM
RepListener Port : 59916 (AUTO)
Last write LSN : 0.823656
Last LSN forced to disk : 0.823656
Replication hold LSN : 0.819456
Replication Peers:
Name : FXTEST_BB
Host : BJINMS221.BJ.COM
Port : 60934 (AUTO) (Connected)
Replication State : STARTED
Communication Protocol : 23
TRANSMITTER thread(s):
For : FXTEST_BB
Start/Restart count : 1
Send LSN : 0.821280
Transactions sent : 0
Total packets sent : 19
Tick packets sent : 15
MIN sent packet size : 64
MAX sent packet size : 152
AVG sent packet size : 69
Last packet sent at : 15:49:37
Total Packets received: 19
MIN rcvd packet size : 64
MAX rcvd packet size : 120
AVG rcvd packet size : 109
Last packet rcvd'd at : 15:49:37
RECEIVER thread(s):
For : FXTEST_BB
Start/Restart count : 1
Transactions received : 0
Total packets sent : 19
Tick packets sent : 0
MIN sent packet size : 64
MAX sent packet size : 120
AVG sent packet size : 109
Last packet sent at : 15:49:45
Total Packets received: 19
MIN rcvd packet size : 64
MAX rcvd packet size : 152
AVG rcvd packet size : 69
Last packet rcvd'd at : 15:49:45
2,B機器:
bjinms221.bj.com> ttRepAdmin -showstatus fxtest_bb
Replication Agent Status as of: 2008-08-18 16:02:59
DSN : fxtest_bb
Process ID : 13820 (Started)
Replication Agent Policy : manual
Host : BJINMS221.BJ.COM
RepListener Port : 60934 (AUTO)
Last write LSN : 0.844184
Last LSN forced to disk : 0.844184
Replication hold LSN : 0.839984
Replication Peers:
Name : FXTEST_AA
Host : BJINMS216.BJ.COM
Port : 59916 (AUTO) (Connected)
Replication State : STARTED
Communication Protocol : 23
TRANSMITTER thread(s):
For : FXTEST_AA
Start/Restart count : 1
Send LSN : 0.841808
Transactions sent : 0
Total packets sent : 29
Tick packets sent : 25
MIN sent packet size : 64
MAX sent packet size : 152
AVG sent packet size : 67
Last packet sent at : 16:02:54
Total Packets received: 29
MIN rcvd packet size : 64
MAX rcvd packet size : 120
AVG rcvd packet size : 112
Last packet rcvd'd at : 16:02:54
RECEIVER thread(s):
For : FXTEST_AA
Start/Restart count : 1
Transactions received : 0
Total packets sent : 30
Tick packets sent : 0
MIN sent packet size : 64
MAX sent packet size : 120
AVG sent packet size : 113
Last packet sent at : 16:02:56
Total Packets received: 30
MIN rcvd packet size : 64
MAX rcvd packet size : 152
AVG rcvd packet size : 67
Last packet rcvd'd at : 16:02:56
Step 5, 檢查replication是否正常工作
1,檢查 fxtest_aa 複製到 fxtest_bb
A機器:
Command> insert into reptable values(1,'Tom');
1 row inserted.
Command> commit;
B機器:
Command> select * from reptable;
< 1, Tom >
1 row found.
2,檢查fxtest_bb 複製到 fxtest_aa
B機器:
Command> insert into reptable values(2,'Jerry');
1 row inserted.
Command> commit;
A機器:
Command> select * from reptable;
< 1, Tom >
< 2, Jerry >
2 rows found.
Step6, 修改replication, Datastore 屬性,
設定為自動啟動
A機器:
$ ttAdmin -repPolicy always fxtest_aa
RAM Residence Policy : inUse
Replication Agent Policy : always
Cache Agent Policy : manual
Cache Agent Manually Started : False
$ ttAdmin -ramPolicy always fxtest_aa
RAM Residence Policy : always
Replication Agent Policy : always
Cache Agent Policy : manual
Cache Agent Manually Started : False
B機器:
bjinms221.bj.com> ttAdmin -repPolicy always fxtest_bb
RAM Residence Policy : inUse
Replication Agent Policy : always
Cache Agent Policy : manual
Cache Agent Manually Started : False
bjinms221.bj.com> ttAdmin -ramPolicy always fxtest_bb
RAM Residence Policy : always
Replication Agent Policy : always
Cache Agent Policy : manual
Cache Agent Manually Started : False
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/81/viewspace-429796/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Step by Step TimesTen --- DataStore的雙向複製( 一)AST
- Step by Step TimesTen --- ttIsqlSQL
- Oracle高階複製Step by StepOracle
- Step by Step TimesTen ----- 配置client-server連線clientServer
- STREAMS筆記(1) step by step 建立一個Streams複製環境筆記
- Step by Step TimesTen-- 使用ODBC訪問TimesTen資料庫C++篇(一個例子)(1)資料庫C++
- Step by Step TimesTen-- 使用ODBC訪問TimesTen資料庫C++篇(一個例子)(2)資料庫C++
- oracle10g simpe AQ step by step(二)Oracle
- React Step by StepReact
- Promise的實現(step by step)Promise
- 使用RMAN備份集搭建Oracle Dataguard Step by Step(二)Oracle
- Oracle 11gR2 Active DataGuard配置Step By Step(二)Oracle
- Command 模式 Step by Step模式
- BAPI Step by step GuidanceAPIGUI
- GoldenGate配置(二)之雙向複製配置Go
- Oracle 12c GI/RAC Step-by-Step安裝指南(二)Oracle
- Learn c++ step by step (轉)C++
- Linux Software RAID step by stepLinuxAI
- Git Step by Step (3):Git物件模型Git物件模型
- 安裝linux(step by step)(轉)Linux
- Learn C++ step by step(2) (轉)C++
- 單步除錯 step into/step out/step over 區別詳解除錯
- Step-to-Step Installation of 10G RAC on RedHat AS 3.0 – Single Node(二)Redhat
- Step-by-step,打造屬於自己的vue ssrVue
- ABP應用開發(Step by Step)-下篇
- ABP應用開發(Step by Step)-上篇
- TIDB DM資料同步step by stepTiDB
- Git Step by Step (4):探索.git目錄Git
- ClearCase使用入門--step by step(序) (轉)
- 實時 Linux 抖動分析 Step by stepLinux
- Git Step by Step (6):Git遠端倉庫Git
- STEP BY STEP INSTALL SSH ON AIX5.3(6.1)AI
- install 11G ASM on RedHat step by stepASMRedhat
- oracle10g simpe AQ step by step(一)Oracle
- linux中配置NFS服務step by stepLinuxNFS
- step by step install netbackup client 6.5 on aixclientAI
- Step by Step Data Replication Using Oracle GoldenGateOracleGo
- Timesten11g建立datastoreAST