OGG的rep進程處理大事務時的查看rep處理進度的命令，oggrep

OGG的rep進程處理大事務時的查看rep處理進度的命令，oggrep

GGSCI (hosta) 17> info repxyREPLICAT   REPXY     Last Started 2015-07-10 13:17   Status RUNNINGCheckpoint Lag       11:35:56 (updated 00:00:31 ago)Log Read Checkpoint  File /u03/ggs/dirdat/aa004004                     2015-07-10 01:50:21.094559  RBA 42328189GGSCI (hosta) 18> !info repxyREPLICAT   REPXY     Last Started 2015-07-10 13:17   Status RUNNINGCheckpoint Lag       11:35:56 (updated 00:01:29 ago)Log Read Checkpoint  File /u03/ggs/dirdat/aa004004                     2015-07-10 01:50:21.094559  RBA 42328189--->記住這個RBA號（以下稱為“info repxy”RBA號）GGSCI (hosta) 19> send repxy, statusSending STATUS request to REPLICAT REPXY ...  Current status: Processing data  Sequence #: 4004  RBA: 49440615 --->記住這個RBA號（以下稱為“send repxy, status”RBA號）  36521 records in current transactionGGSCI (hosta) 20> info REPXYREPLICAT   REPXY     Last Started 2015-07-10 13:17   Status RUNNINGCheckpoint Lag       11:35:56 (updated 00:01:54 ago)Log Read Checkpoint  File /u03/ggs/dirdat/aa004004                     2015-07-10 01:50:21.094559  RBA 42328189--->還是這個RBA號（“info repxy”RBA號未變）GGSCI (hosta) 21> send repxy, statusSending STATUS request to REPLICAT REPXY ...  Current status: Processing data  Sequence #: 4005  RBA: 7106039 --->（“send repxy, status”RBA號已經該改變，實際上已經切換到了4005號trail，見一行。）  63454 records in current transactionGGSCI (hosta) 22> info REPXYREPLICAT   REPXY     Last Started 2015-07-10 13:17   Status RUNNINGCheckpoint Lag       11:35:56 (updated 00:02:22 ago)Log Read Checkpoint  File /u03/ggs/dirdat/aa004004                     2015-07-10 01:50:21.094559  RBA 42328189--->還是這個RBA號（“info repxy”RBA號未變）

 

總結：若是rep進程處理大的事務，會導致rep進程檢查點的更新有延遲，此種情況下，使用"info rep進程"命令不足以真實反映rep進程的處理進度，此時，應該使用"send rep進程, status"命令

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。