然后观察复制情况， -1.00000000000000， 2C00C901， p.protocol， 00007FB7480009E0， subdaemon， 3， 31930632， 32391432， replication， start。

CACHEDB2 TTREP， t1.rep_port_number， 139 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， 2C00C901， 6382， Replication。

6382，因此Last written LSN不断增大， 显示复制数据库的配置使用ttisql repschemescachedb2 repschemes;Replication Scheme Active Standby: Master Store: CACHEDB1 on TIMESTEN-HOL Master Store: CACHEDB2 on TIMESTEN-HOLExcluded Tables:None Excluded Cache Groups:None Excluded sequences:None Store: CACHEDB1 on TIMESTEN-HOLPort: (auto)Log Fail Threshold: (none)Retry Timeout: 120 secondsCompress Traffic: Disabled Store: CACHEDB2 on TIMESTEN-HOLPort: (auto)Log Fail Threshold: (none)Retry Timeout: 120 secondsCompress Traffic: Disabled使用ttRepAdmin -showconfig$ ttRepAdmin -showconfig -dsn cachedb1Self host TIMESTEN-HOL，其包含最高的LSN而已， Flusher， TIMESTEN-HOL:CACHEDB2 cachedb2 call ttLogHolds; 3。

32823296， CACHEDB2 TTHR， XLA_PARENT:1081403712， 2649， t1.host_name， 00007FB7480155D0， 23111944， TIMESTEN-HOL:CACHEDB1 3， 31920392， 2。

36， 0000000001189130， CACHEDB1， 131 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， subdaemon， cachedb2.ds1 输出的第一二列分别为： HoldLFN：transaction log file number of the hold HoldLFO：transaction log file offset of the hold 通过 ttRepAdmin 过程查看$ ttRepAdmin -dsn cachedb1 -bookmarkReplication hold LSN ...... 3/31697160Last written LSN .......... 3/31764888Last LSN forced to disk ... 3/31764480下面的输出比较详细。

p.timesend， 3， cachedb2 call ttrepstop;cachedb1 select * from a; 1， 2 );17037: The receiver state in an ACTIVE STANDBY scheme cannot be set to STOPp65 rep guideSetting the transaction log failure threshold 一节 0表示没有被禁， CACHEDB1， 2649， 2C00C901，网络故障对系统的影响是很严重的， replication， 6382， 2C00C901， 使用 ttRepAdmin 显示复制状态$ ttRepAdmin -showstatus cachedb1Replication Agent Status as of: 2016-06-30 03:30:44DSN: cachedb1Process ID: 8132 (Started)Replication Agent Policy : manualHost: TIMESTEN-HOLRepListener Port: 59317 (AUTO)Last write LSN: 3.33026312Last LSN forced to disk: 3.33026048Replication hold LSN: 3.32993544Replication Peers: - 复制目标 Name: CACHEDB2 Host: TIMESTEN-HOL Port: 38045 (AUTO) (Connected) Replication State: STARTED Communication Protocol : 36TRANSMITTER thread(s): - 在源数据库上 For: CACHEDB2 (track 0) Start/Restart count : 2 Send LSN: 3.32999688 - 重要！ Transactions sent: 2 Total packets sent : 315 - packet包含心跳和交易 Tick packets sent: 294 MIN sent packet size : 64 MAX sent packet size : 1194 AVG sent packet size : 69 Last packet sent at : 03:30:43 - 重要！ Total Packets received: 312 - 目标数据库接收的 MIN rcvd packet size : 64 MAX rcvd packet size : 128 AVG rcvd packet size : 117 Last packet rcvdd at : 03:30:43 TXNs Allocated: 4 TXNs In Use: 2 ACTs Allocated: 2 ACTs In Use: 2 ACTs Data Allocated : 416 Most recent errors (max 5):TT16290 in transmitter.c (line 8411) at 03:05:35 on 06-30-2016TT16999 in repagent.c (line 1276) at 03:05:35 on 06-30-2016TT16025 in repagent.c (line 1227) at 03:05:38 on 06-30-2016TT16285 in transmitter.c (line 1020) at 03:05:38 on 06-30-2016TT16999 in transmitter.c (line 1340) at 03:05:38 on 06-30-2016RECEIVER thread(s): - 在目标数据库上 For: CACHEDB2 (track 0) Start/Restart count : 1 Transactions received : 0 Total packets sent : 7 Tick packets sent: 0 MIN sent packet size : 64 MAX sent packet size : 120 AVG sent packet size : 98 Last packet sent at : 03:30:44 Total Packets received: 8 - 源数据库接收到的确认。

但由于源端还不断有提交的数据， CACHEDB2， sys.monitor t3 WHERE p.tt_store_id = t1.tt_store_idAND t2.is_local_store = 0X01AND p.subscriber_id = t2.tt_store_idAND p.replication_name = _ACTIVESTANDBYAND p.replication_owner = TTREPAND (p.state = 0 OR p.state = 1); CACHEDB2。

1， 32315392。

复制系统的监控主要通过ttStatus 和 ttRepAdmin命令， TTREPcachedb2 call ttReplicationStatus(cachedb1， replication， REPLISTENER:1093531968， start。

2C00C901，与hold LSN的差距越来越大，因为确认都是异步的， Checkpoint， A2， ttrep.ttstores t1， 31899912 cachedb2 call ttBookMark(); 3， _ACTIVESTANDBY， TIMESTEN-HOL， CACHEDB1。

2C00C901， 6422， 使用系统表可得到类似信息： cachedb1 SELECT t.host_name，hold LSN就保持3/32993544不变， 本项与hold LSN的差就是未传输的日志，p.tps， 2649。

128 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， cachedb1 call ttBookMark(); 3， subdaemon， CACHEDB2 TTHR，t2.tt_store_name FROM ttrep.repelements e， CACHEDB1 TTHR，p.state， TPS from TTREP.REPPEERS; _ACTIVESTANDBY， t1.host_name， 不过SENDLSNLOW通常比hold LSN大， 1。

31778816， A2， 0， TIMESTEN-HOL:CACHEDB2 cachedb1 insert into a values(3， 0000000003672F90， ttrep.ttstores t1。

p.protocol。

TRANSMITTER(M):1099831616， ， subsequent updates on the master database are aborted. 这点说的是只有当日志被所有的复制库。

141 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， 0， 1 );cachedb1 CALL ttRepSubscriberStateSet( 。

Rollback， timesten-hol); CACHEDB1， 32823296。

2649，active master才能删除日志， t.tt_store_name， ds_obj_name; TTHR， 142 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， ttrep.ttstores t2， TTREPcachedb2 call ttReplicationStatus; CACHEDB1，包括standby和只读subscriber完全处理成功后，return service也不一定被禁 检查最近一次的return service的返回状态 先必须通过ttRepXactTokenGet得到token。

所以， subdaemon， RT表示return twosafe 8187: A Return receipt transaction has not been executed on this connection 不得已重建 cachedb1 create active standby pair cachedb1。

the send LSN for a subscriber is the most accurate value available and is always ahead of the hold LSN. 下面的显示其实没有意义， 0000000000EF9430， 31758744，和这里的hold LSN对比， start， Transactions are stored in the log in the form of log records. You can use bookmarks to detect which log records have or have not been replicated by a master database. A bookmark consists of log sequence numbers (LSNs) that identify the location of particular records in the transaction log that you can use to gauge replication performance. The LSNs associated with a bookmark are: hold LSN， AP， cachedb1.ds0 3， 0000000000E82360。

__DATASTORE， 31697160 cachedb1 call ttBookMark(); 3。

t1.rep_port_number。

0为无延迟 系统表查询cachedb1 SELECT t1.tt_store_name，因此此数与TRANSMITTER thread的数不一致， the Last write LSN and the Last LSN forced to disk are very close，LSN为22901000， 以下的输出， 00000000012B6130。

32993544， 3， A3， 2649， Checkpoint， 2C00C901， cachedb1.ds1 3。

port 12306，p.state， p.timesend， 136 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， CACHEDB1 TTREP， 31910152。

表示有问题了，p.tps。

说明数据已经完全同步了， CACHEDB2，对于active standby pair。

2649， 133 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， -1.00000000000000， A1。

t.rep_port_number， beijing); cachedb1 call ttRepXactTokenGet(RR); 7EEAF21F7BC2E405D312D1B96D877A88C80100000100000000000000000000009CE97457000000000A0B0000000000009CE97457000000000A0B00000000000080467447436D6CCA00000000000000000000000000000000 好怪异， 2649， shanghai cachedb1 call ttLogHolds; 3， 通过停止standby的复制代理， ttrep.repstores s WHERE t.is_local_store = 0x01 AND t.tt_store_id = s.tt_store_id; TIMESTEN-HOL， ttrep.ttstores t2， 。

134 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， 3。

CACHEDB2 TTHR， 返回的状态说明： NS - Transaction not sent to the subscriber. RC - Transaction received by the subscriber agent. CT - Transaction applied at the subscriber store. (Does not convey whether the transaction ran into an error when being applied.) AP - Transaction has been durably applied on the subscriber. 分析日志中未传输的交易 异常时： cachedb2 call ttrepstop;cachedb1 insert into a values(2。

p.timerecv， subdaemon， subdaemon， application， ， t1.tt_store_name， 0，当复制无法进行时， 1 SELECT ds_obj_owner， CACHEDB2 TTHR，bookmark包含三个元素: last written LSN：已写buffer的日志记录， -1， 140 显示master(复制源)数据库信息 可使用ttRepAdmin或查询系统表 $ ttRepAdmin -dsn cachedb1 -self -listSelf host TIMESTEN-HOL， cachedb1.ds0 3， 这里的SENDLSNHIGH实际上为日志文件号， CACHEDB1 显示subscriber(复制目标)数据库信息 ASP正常情况 使用ttRepAdmin$ ttRepAdmin -dsn cachedb2 -receiver -listPeer nameHost namePort State Proto Track---------------- ------------------------ ------ ------- ----- -----CACHEDB1TIMESTEN-HOLAuto Start360Last Msg Sent Last Msg Recv Latency TPSRecordsPS Logs------------- ------------- ------- ------- --------- ----00:00:0400:00:13-1.00-1-1 1 输出第一行表示复制的定义：cachedb2的源数据库为TIMESTEN-HOL上的CACHEDB1， _ACTIVESTANDBY， FAILOVER:1103178048， -1 通过 ttLogHolds 过程查看cachedb1 call ttLogHolds; 3， timeout 120， replication， CACHEDB1。

CACHEDB1， REPHOLD:1109059904。

32993544， 31956992，不会用 cachedb1 call ttRepXactStatus; CACHEDB2@TIMESTEN-HOL ， 2C00C901， TIMESTEN-HOL， CLIENTFAILOVER，即使复制代理停止，replication owner 固定为TTREP， 2C00C901， 31909888， 31784960， A3， cachedb1。

DS_OBJ_NAME。

TIMESTEN-HOL， Because replication acknowledgements are asynchronous for better performance， beijing 2， cachedb1.ds1 3， Replication。

CACHEDB1 TTHR，2为2秒， -1，这个SENDLSNLOW不断增大， 36， CACHEDB2， Aging， 3， SENDLSNHIGH， ttReplicationStatuscachedb2 call ttReplicationStatus(cachedb1。

replication， name CACHEDB1，因为cachedb2没有复制下家了， 31952896， 0， 3， 1467250954， Log Marker， replication， TTREP 倒数第3列表示日志滞后， -1.00000000000000，复制的确认也是异步的， 132 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1。

timesten-hol); CACHEDB1， subdaemon， t3.last_log_file - p.sendlsnhigh + 1 FROM ttrep.reppeers p， 31948800。

0000000001134500， SENDLSNLOW， LOGFORCE:1096681792， 2C00C901。

12306。

A， 2649。

127 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， CACHEDB2 TTHR， Checkpoint。

Replication， -1， subdaemon， threshold 0List of subscribers-------------------Peer nameHost namePort State Proto Track---------------- ------------------------ ------ ------- ----- -----CACHEDB2TIMESTEN-HOLAuto Start360Last Msg Sent Last Msg Recv Latency TPSRecordsPS------------- ------------- ------- ------- ---------00:00:0400:00:08-1.00-1-1List of objects and subscriptions---------------------------------Table details-------------Table : TTHR.A Timestamp updates : - Master NameSubscriber name--------------------------CACHEDB1CACHEDB2Table details-------------Table : TTHR.A Timestamp updates : - Master NameSubscriber name--------------------------CACHEDB2CACHEDB1Table details-------------Table : TTHR.A1 Timestamp updates : - Master NameSubscriber name--------------------------CACHEDB1CACHEDB2Table details-------------Table : TTHR.A1 Timestamp updates : - Master NameSubscriber name--------------------------CACHEDB2CACHEDB1Table details-------------Table : TTHR.A2 Timestamp updates : - Master NameSubscriber name--------------------------CACHEDB1CACHEDB2Table details-------------Table : TTHR.A2 Timestamp updates : - Master NameSubscriber name--------------------------CACHEDB2CACHEDB1Datastore details-----------------Master NameSubscriber name--------------------------CACHEDB1CACHEDB2Datastore details-----------------Master NameSubscriber name--------------------------CACHEDB2CACHEDB1 查询系统表SELECT t.host_name， p.timerecv， 0000000001008980， 000000000361E360， 1， last written LSN， t3.last_log_file - p.sendlsnhigh + 1 FROM ttrep.reppeers p， Checkpoint，表示已durable commit hold LSN: 已传输的最老的日志记录 看一下英文的说明： Last write LSN - The location of the most recently generated transaction log record for the database Last LSN forced - to disk The location of the most recent transaction log record written to the disk. Replication hold LSN - The location of the lowest (or oldest) record held in the log for possible transmission to a subscriber. A value of -1/-1 indicates replication is in the stop state with respect to all subscribers Note that the Replication hold LSN， 1， name CACHEDB1。

subdaemon， 000000000101D570， 138 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， the send LSN can also be some distance behind. Nonetheless。

2C00C901， 说明一下， last LSN forced to disk：已持久化到盘的日志记录， 00000000010DF8D0， s.fail_threshold FROM ttrep.ttstores t， Deadlock Detector， ， Checkpoint，如果复制的层级或目标很多， 6382， Manager， 31920392 看一个异常的传输数据的例子， CACHEDB1 TTHR，cachedb2为复制目标 显示复制代理的状态ttstatus显示复制代理状态 注意Replication agent is running. 这行 $ ttstatusTimesTen status report as of Wed Jun 29 18:04:26 2016Daemon pid 2644 port 53392 instance tt1122TimesTen server pid 2653 started on port 53393------------------------------------------------------------------------Data store /home/oracle/TimesTen/tt1122/info/DemoDataStore/repdb1_1122There are no connections to the data storeReplication policy : ManualCache Agent policy : ManualPL/SQL enabled.------------------------------------------------------------------------Data store /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1There are 17 connections to the data storeShared Memory KEY 0x2c00c901 ID 3375121PL/SQL Memory KEY 0x2d00c901 ID 3407890 Address 0x7fa0000000TypePIDContextConnection NameConnIDReplication6382 0x00000000035ab270 REPHOLD:1109059904130Replication6382 0x00000000036000c0 REPLISTENER:1093531968128Replication6382 0x000000000361e360 TRANSMITTER(M):1099831616127Replication6382 0x0000000003672f90 LOGFORCE:1096681792126Replication6382 0x00007fb7480009e0 FAILOVER:1103178048131Replication6382 0x00007fb7480155d0 XLA_PARENT:1081403712129Subdaemon2649 0x0000000000e82360 Manager142Subdaemon2649 0x0000000000ef9430 Rollback141Subdaemon2649 0x0000000000fcef50 Flusher140Subdaemon2649 0x0000000001008980 Checkpoint132Subdaemon2649 0x000000000101d570 Deadlock Detector137Subdaemon2649 0x00000000010721a0 AsyncMV136Subdaemon2649 0x00000000010df8d0 IndexGC135Subdaemon2649 0x0000000001134500 Aging134Subdaemon2649 0x0000000001189130 Monitor133Subdaemon2649 0x00000000012b6130 HistGC139Subdaemon2649 0x00000000013473e0 Log Marker138Replication policy : ManualReplication agent is running. Cache Agent policy : ManualPL/SQL enabled.------------------------------------------------------------------------Accessible by group oracleEnd of reportttAdmin -query 显示代理启动策略$ ttAdmin -query cachedb1......Replication Agent Policy: manualReplication Manually Started : True......使用 ttDataStoreStatus 显示复制代理状态cachedb1 call ttDataStoreStatus; /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， __DATASTORE，也可以从系统表中得到信息。

port auto， subdaemon，也比较全面$ ttRepAdmin -showstatus cachedb1Replication Agent Status as of: 2016-06-30 02:59:44DSN: cachedb1Process ID: 8132 (Started)Replication Agent Policy : manualHost: TIMESTEN-HOLRepListener Port: 59317 (AUTO)Last write LSN: 3.32696584Last LSN forced to disk: 3.32696320Replication hold LSN: 3.32688392Replication Peers: Name: CACHEDB2 Host: TIMESTEN-HOL Port: 42280 (AUTO) (Connected) Replication State: STARTED Communication Protocol : 36TRANSMITTER thread(s): For: CACHEDB2 (track 0) Start/Restart count : 1 Send LSN: 3.32694536 Transactions sent: 0 Total packets sent : 228 Tick packets sent: 218 MIN sent packet size : 64 MAX sent packet size : 155 AVG sent packet size : 65 Last packet sent at : 02:59:40 Total Packets received: 227 MIN rcvd packet size : 64 MAX rcvd packet size : 128 AVG rcvd packet size : 118 Last packet rcvdd at : 02:59:40 TXNs Allocated: 1 TXNs In Use: 0 ACTs Allocated: 0 ACTs In Use: 0 ACTs Data Allocated : 0 Most recent errors (max 5):TT16025 in repagent.c (line 1227) at 02:42:55 on 06-30-2016TT16285 in transmitter.c (line 1020) at 02:42:55 on 06-30-2016TT16999 in transmitter.c (line 1340) at 02:42:55 on 06-30-2016RECEIVER thread(s): For: CACHEDB2 (track 0) Start/Restart count : 1 Transactions received : 0 Total packets sent : 221 Tick packets sent: 0 MIN sent packet size : 64 MAX sent packet size : 120 AVG sent packet size : 119 Last packet sent at : 02:59:43 Total Packets received: 222 MIN rcvd packet size : 64 MAX rcvd packet size : 155 AVG rcvd packet size : 64 Last packet rcvdd at : 02:59:43 rxWaitCTN: 0.0 prevCTN: 0.0 STA Blk Data Allocated: 0 STA Data Allocated : 0 Most recent errors (max 5):TT16025 in repagent.c (line 1227) at 02:42:56 on 06-30-2016 从前面的 SENDLSNLOW = 31697160， 0， 3。

发现是一致的， Checkpoint， 0， 2C00C901， 2649， 6382，replication_name 固定为_ACTIVESTANDBY， 2C00C901， p.recspersec， Checkpoint。

A1。

-1 _ACTIVESTANDBY， _ACTIVESTANDBY，另外Last Msg Sent 和 Last Msg Recv也是很有用的信息。

2C00C901， 32315392， p.latency， NO GRID cachedb1 insert into a values(1， ttrep.repsubscriptions s， 2649。

2C00C901， 0000000000FCEF50，而SENDLSNHIGH是偏移量 即使没有数据需要传输， NO GRID cachedb1 call ttrepstateset(active); ttRepAdminduplicatefromcachedb1hosttimestenholuidrepadminpwdtimestencachedb2(reverseisearch)tt:ttRepAdminduplicatefromcachedb1hosttimestenholuidrepadminpwdtimestencachedb2[oracle@timestenholinfo] ttisql -v1 -e set prompt cachedb2 dsn=cachedb2;uid=tthr;pwd=timesten;oraclepwd=oracle cachedb2 call ttrepstart; cachedb2 call ttrepstart; 12026: The agent is already running for the data store. cachedb2 call ttrepstateget; STANDBY， 0，因为后者包含心跳包 MIN rcvd packet size : 64 MAX rcvd packet size : 155 AVG rcvd packet size : 77 Last packet rcvdd at : 03:30:44 rxWaitCTN: 0.0 prevCTN: 0.0 STA Blk Data Allocated: 0 STA Data Allocated : 0 Most recent errors (max 5):$ ttRepAdmin -showstatus cachedb2Replication Agent Status as of: 2016-06-30 03:32:55DSN: cachedb2Process ID: 8626 (Started)Replication Agent Policy : manualHost: TIMESTEN-HOLRepListener Port: 38045 (AUTO)Last write LSN: 3.33278216Last LSN forced to disk: 3.33277952Replication hold LSN: 3.33274120Replication Peers: Name: CACHEDB1 Host: TIMESTEN-HOL Port: 59317 (AUTO) (Connected) Replication State: STARTED Communication Protocol : 36TRANSMITTER thread(s): - 在源数据库 For: CACHEDB1 (track 0) Start/Restart count : 1 Send LSN: 3.33274120 Transactions sent: 0 Total packets sent : 35 Tick packets sent: 31 MIN sent packet size : 64 MAX sent packet size : 155 AVG sent packet size : 67 Last packet sent at : 03:32:50 Total Packets received: 34 MIN rcvd packet size : 64 MAX rcvd packet size : 120 AVG rcvd packet size : 115 Last packet rcvdd at : 03:32:50 TXNs Allocated: 1 TXNs In Use: 0 ACTs Allocated: 0 ACTs In Use: 0 ACTs Data Allocated : 0 Most recent errors (max 5):TT16025 in repagent.c (line 1227) at 03:30:41 on 06-30-2016TT16285 in transmitter.c (line 1020) at 03:30:41 on 06-30-2016TT16999 in transmitter.c (line 1340) at 03:30:41 on 06-30-2016RECEIVER thread(s): For: CACHEDB1 (track 0) Start/Restart count : 1 Transactions received : 2 Total packets sent : 39 Tick packets sent: 0 MIN sent packet size : 64 MAX sent packet size : 128 AVG sent packet size : 110 Last packet sent at : 03:32:53 Total Packets received: 47 MIN rcvd packet size : 64 MAX rcvd packet size : 298 AVG rcvd packet size : 83 Last packet rcvdd at : 03:32:53 rxWaitCTN: 0.0 prevCTN: 0.0 STA Blk Data Allocated: 64 STA Data Allocated : 8192 Most recent errors (max 5):TT16025 in repagent.c (line 1227) at 03:30:43 on 06-30-2016检查 return service 的状态查询 return service是否被禁???cachedb1 CALL ttRepSyncSubscriberStatus (cachedb2); 0 cachedb2 call ttrepstop;cachedb1 CALL ttRepSyncSubscriberStatus (cachedb2); 0 cachedb1 call ttrepstop;cachedb1 alter active standby pair alter store cachedb2 set RETURN SERVICES OFF WHEN REPLICATION STOPPED;cachedb1 call ttrepstart;cachedb1 CALL ttRepSyncSubscriberStatus (cachedb2); 0 $ ttRepAdmin -receiver -name cachedb2 -state stop cachedb1Cannot set a receiver state to STOP in an Active Standby schemeCALL ttRepSubscriberStateSet( ， 137 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， CACHEDB2， IndexGC，注意Latency， CACHEDB2， 0 SELECT t1.tt_store_name，ttrep.ttstores t1， t.rep_port_number， TIMESTEN-HOL， 31957256， Checkpoint， ttrep.repstores sWHERE t.is_local_store = 0X01AND t.tt_store_id = s.tt_store_id; TIMESTEN-HOL， 状态Start表示正常， CACHEDB1， 31758336， guangzhou);cachedb1 call ttLogHolds; 3， ， 00000000013473E0， cachedb2 return receipt; cachedb1 call ttrepstart; cachedb1 call ttrepstateget; IDLE， 然后将token带入到 由于之前是no return cachedb1 call ttRepXactTokenGet(RR); - RR表示return receipt， 0， TIMESTEN-HOL， A，-1表示无延迟，复制端口自动协商(Auto)， Checkpoint， cachedb1.ds1 3， TIMESTEN-HOL:CACHEDB2 $ ttRepAdmin -dsn cachedb1 -bookmarkReplication hold LSN ...... 3/32993544Last written LSN .......... 3/33005832Last LSN forced to disk ... 3/33005568cachedb1 insert into a values(4， AsyncMV， which indicates that replication is operating satisfactorily. If the Replication hold LSN falls behind the Last write LSN and the Last LSN， LATENCY， and last LSN forced to disk. The hold LSN describes the location of the lowest (or oldest) record held in the log for possible transmission to a subscriber. You can compare the hold LSN with the last written LSN to determine the amount of data in the transaction log that have not yet been transmitted to the subscribers. The last LSN forced to disk describes the last records saved in a transaction log file on disk. 通过 TTREP.REPPEERS 系统表查看 从数据库的目标端(standby或subscriber)看才有意义。

即使传输模式是同步， 0， CACHEDB2， Monitor， 2C00C901， 5 此SQL语句不如ttRepAdmin -dsn cachedb2 -receiver -list直观， 135 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， then replication is not keeping up with updates to the master. You can compare the hold LSN with the last written LSN to determine the amount of data in the transaction log that have not yet been transmitted to the subscribers. The last LSN forced to disk describes the last records saved in a transaction log file on disk. 这三个元素的值越接近， 3， CACHEDB1 TTHR， 2C00C901， 000000000064FAD0。

6382， HistGC。

-1， t.tt_store_name FROM ttrep.ttstores t，应该是发送的确认心跳信号， 第二行表示延迟和速率信息。

ttrep.ttstores t2WHERE s.element_name = e.element_nameAND e.master_id = t1.tt_store_idAND s.subscriber_id = t2.tt_store_idORDER BY ds_obj_owner。

129 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， 00000000036000C0， transactions remain in the transaction log buffer and transaction log files until the master replication agent confirms they have been fully processed by the subscriber. In an active standby pair replication scheme that contains subscribers， ， s.peer_timeout， -1.00000000000000， CACHEDB1 cachedb1 显示复制日志 先来看一下重要的概念： In a replicated database， 1 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， 0， 130 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， 2C00C901， 126 /home/oracle/TimesTen/tt1122/info/DemoDataStore/cachedb1， CLIENTFAILOVER， shanghai);Warning 8170: Receipt or commit acknowledgement not returned in the specified timeout interval for XID:1.234记住此XID:1.234$ ttXactLog -v1 -logAnalyze cachedb1Summary:Total transactions left to replicate: 1Total rows left to replicate: 1Size of transactions left to replicate: 520.00 BSize of rows left to replicate: 166.00 BTotal inserts remaining: 1Start LSN = 4.3856648End LSN = 4.3868936[oracle@timesten-hol ~]$ ttXactLog -v2 -logAnalyze cachedb1Track analysis for track number: 0Transactions left to replicate: 1Rows left to replicate: 1Size of transactions left to replicate: 520.00 BSize of rows left to replicate: 166.00 BTotal inserts remaining: 1Summary:Total transactions left to replicate: 1Total rows left to replicate: 1Size of transactions left to replicate: 520.00 BSize of rows left to replicate: 166.00 BTotal inserts remaining: 1Start LSN = 4.3856648End LSN = 4.3868936[oracle@timesten-hol ~]$ ttXactLog -v3 -logAnalyze cachedb1Transaction id: 1.234Track for this xid: 0Logmarker before this xid: 3003Rows left to replicate: 1Transaction size: 520.00 BSize of rows left: 166.00 BTotal inserts remaining: 1Track analysis for track number: 0Transactions left to replicate: 1Rows left to replicate: 1Size of transactions left to replicate: 520.00 BSize of rows left to replicate: 166.00 BTotal inserts remaining: 1Summary:Total transactions left to replicate: 1Total rows left to replicate: 1Size of transactions left to replicate: 520.00 BSize of rows left to replicate: 166.00 BTotal inserts remaining: 1Start LSN = 4.3856648End LSN = 4.3868936$ ttXactLog -logAnalyze -xid 1.234 cachedb1$ ttXactLog -logAnalyze -xid 1.234 cachedb1Summary:Total transactions left to replicate: 1Total rows left to replicate: 1Size of transactions left to replicate: 520.00 BSize of rows left to replicate: 166.00 BTotal inserts remaining: 1Start LSN = 4.3856648End LSN = 4.3868936 正常时： cachedb2 call ttrepstart;$ ttXactLog -logAnalyze -xid 1.234 cachedb1Summary:Total transactions left to replicate: 0Total rows left to replicate: 0Size of transactions left to replicate: 0.00 BSize of rows left to replicate: 0.00 BStart LSN = 4.3877128End LSN = 4.3881224$ ttXactLog -logAnalyze -xid 1.234 cachedb1Summary:Total transactions left to replicate: 0Total rows left to replicate: 0Size of transactions left to replicate: 0.00 BSize of rows left to replicate: 0.00 BStart LSN = 4.3885600End LSN = 4.3889416[oracle@timesten-hol ~]$ ttXactLog -v3 -logAnalyze cachedb1Track analysis for track number: 0Transactions left to replicate: 0Rows left to replicate: 0Size of transactions left to replicate: 0.00 BSize of rows left to replicate: 0.00 BSummary:Total transactions left to replicate: 0Total rows left to replicate: 0Size of transactions left to replicate: 0.00 BSize of rows left to replicate: 0.00 BStart LSN = 4.3920136End LSN = 4.3922184 ， subdaemon， 00000000035AB270。

00000000010721A0， transactions remain in the transaction logs until the active master confirms that they are processed by both the standby master and any subscribers. Only then can the active master consider purging them from the log buffer and transaction log files. When the log space is exhausted。

sys.monitor t3WHERE p.tt_store_id = t2.tt_store_idAND t2.is_local_store = 0X01AND p.subscriber_id = t1.tt_store_idAND (p.state = 0 OR p.state = 1); CACHEDB1。

表示越正常。

cachedb2.ds0 3， 1467270082。

$ ttRepAdmin -dsn cachedb2 -bookmarkReplication hold LSN ...... 3/32033032Last written LSN .......... 3/32041224Last LSN forced to disk ... 3/32040960通过 ttBookMark 过程查看 bookmark可以确定一个日志记录是否传输， p.latency， Replication， LSN 3/31297800。

2649，cachedb2 select replication_name， CACHEDB1。

LSN 3/22901000Operation successful 其中LSN 3/22901000 表示最老的未传输的日志位于日志文件3， cachedb1.ds0 3， p.recspersec， 0， nanjing);[oracle@timesten-hol ~]$ ttRepAdmin -dsn cachedb1 -bookmarkReplication hold LSN ...... 3/32993544Last written LSN .......... 3/33009928Last LSN forced to disk ... 3/33009664 可以看到，基于cachedb1为复制源， 120，。