欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

【ogg实战】如何查看rep的恢复进度info rep,showch

程序员文章站 2024-02-10 09:19:34
...

第一次info rlzsi,showch

REPLICAT   RLZSI     Last Started 2019-10-26 02:14   Status RUNNING
Checkpoint Lag       57:14:58 (updated 00:00:05 ago)
Log Read Checkpoint  File ./dirdat/si001435
                     2019-10-23 17:19:11.523405  RBA 6342975


Current Checkpoint Detail:

Read Checkpoint #1

  GGS Log Trail

  Startup Checkpoint (starting position in the data source):
    Sequence #: 1435
    RBA: 14327
    Timestamp: 2019-10-23 17:09:06.523711
    Extract Trail: ./dirdat/si

  Current Checkpoint (position of last record read in the data source):
    Sequence #: 1435
    RBA: 6342975
    Timestamp: 2019-10-23 17:19:11.523405
    Extract Trail: ./dirdat/si

Header:
  Version = 2
  Record Source = A
  Type = 1
  # Input Checkpoints = 1
  # Output Checkpoints = 0

第二次info rlzsi,showch

REPLICAT   RLZSI     Last Started 2019-10-26 02:14   Status RUNNING
Checkpoint Lag       57:06:20 (updated 00:00:06 ago)
Log Read Checkpoint  File ./dirdat/si001435
                     2019-10-23 17:29:28.523335  RBA 11574381


Current Checkpoint Detail:

Read Checkpoint #1

  GGS Log Trail

  Startup Checkpoint (starting position in the data source):
    Sequence #: 1435
    RBA: 14327
    Timestamp: 2019-10-23 17:09:06.523711
    Extract Trail: ./dirdat/si

  Current Checkpoint (position of last record read in the data source):
    Sequence #: 1435
    RBA: 11574381
    Timestamp: 2019-10-23 17:29:28.523335
    Extract Trail: ./dirdat/si

Header:
  Version = 2
  Record Source = A
  Type = 1
  # Input Checkpoints = 1
  # Output Checkpoints = 0

对比发现红色部分的rba对应的timestamp一直在推进,很慢啊,让电脑自己跑去吧

REPLICAT   RLZSI     Last Started 2019-10-26 02:14   Status RUNNING
Checkpoint Lag       57:06:20 (updated 00:00:06 ago)
Log Read Checkpoint  File ./dirdat/si001435
                     2019-10-23 17:29:28.523335  RBA 11574381


Current Checkpoint Detail:

Read Checkpoint #1

  GGS Log Trail

  Startup Checkpoint (starting position in the data source):
    Sequence #: 1435
    RBA: 14327
    Timestamp: 2019-10-23 17:09:06.523711
    Extract Trail: ./dirdat/si

  Current Checkpoint (position of last record read in the data source):
    Sequence #: 1435
    RBA: 11574381
    Timestamp: 2019-10-23 17:29:28.523335

    Extract Trail: ./dirdat/si

Header:
  Version = 2
  Record Source = A
  Type = 1
  # Input Checkpoints = 1
  # Output Checkpoints = 0