goldengate如何判断数据是否完成同步

 

1.投递pump进程的Write部分的rba与rep复制进程一致,说明数据已经完成同步

 

主库

复制代码
GGSCI (rac01) 101> info dpep,showch

EXTRACT    DPEP      Last Started 2021-06-30 15:55   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:00 ago)
Process ID           26675
Log Read Checkpoint  File /goldengate12c/dirdat/ep000000007
                     2021-06-30 15:58:38.000000  RBA 784090


Current Checkpoint Detail:

Read Checkpoint #1

  GGS Log Trail

  Startup Checkpoint (starting position in the data source):
    Sequence #: 6
    RBA: 3912891
    Timestamp: 2021-06-30 15:38:08.000000
    Extract Trail: /goldengate12c/dirdat/ep
    Seqno Length: 9

  Current Checkpoint (position of last record read in the data source):
    Sequence #: 7
    RBA: 784090
    Timestamp: 2021-06-30 15:58:38.000000
    Extract Trail: /goldengate12c/dirdat/ep
    Seqno Length: 9

Write Checkpoint #1

  GGS Log Trail

  Current Checkpoint (current write position):
    Sequence #: 4
    RBA: 784188
    Timestamp: 2021-06-30 15:59:55.829571
    Extract Trail: ./dirdat/ep
    Seqno Length: 9
    Flip Seqno Length: No
    Trail Type: RMTTRAIL

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

File Information:
  Block Size = 2048
  Max Blocks = 100
  Record Length = 2048
  Current Offset = 0

Configuration:
  Data Source = 0
  Transaction Integrity = 1
  Task Type = 0

Status:
  Start Time = 2021-06-30 15:55:20
  Last Update Time = 2021-06-30 15:59:55
  Stop Status = A
  Last Result = 400
复制代码

 

 

从库复制进程

复制代码
GGSCI (ora11g) 51> info repep,showch

REPLICAT   REPEP     Last Started 2021-06-30 11:40   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:04 ago)
Process ID           2204
Log Read Checkpoint  File /goldengate12c/dirdat/ep000000004
                     2021-06-30 15:58:34.320225  RBA 784188


Current Checkpoint Detail:

Read Checkpoint #1

  GGS Log Trail

  Startup Checkpoint (starting position in the data source):
    Sequence #: 1
    RBA: 208555
    Timestamp: 2021-06-29 23:32:08.582683
    Extract Trail: /goldengate12c/dirdat/ep
    Seqno Length: 9

  Current Checkpoint (position of last record read in the data source):
    Sequence #: 4
    RBA: 784188
    Timestamp: 2021-06-30 15:58:34.320225
    Extract Trail: /goldengate12c/dirdat/ep
    Seqno Length: 9

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

File Information:
  Block Size = 2048
  Max Blocks = 100
  Record Length = 2048
  Current Offset = 0

Configuration:
  Data Source = 0
  Transaction Integrity = -1
  Task Type = 0

Status:
  Start Time = 2021-06-30 11:40:34
  Last Update Time = 2021-06-30 15:59:30
  Stop Status = A
  Last Result = 400
复制代码

 

2.投递进程pump的read部分rba与抽取extract部分的write的rba一致说明,投递进程已经读完抽取进行的日志

复制代码
GGSCI (rac01) 104> info extep,showch

EXTRACT    EXTEP     Last Started 2021-06-30 15:55   Status RUNNING
Checkpoint Lag       00:00:04 (updated 00:00:06 ago)
Process ID           26692
Log Read Checkpoint  Oracle Redo Logs
                     2021-06-30 16:03:58  Thread 1, Seqno 7, RBA 65249792
                     SCN 0.2307511 (2307511)
Log Read Checkpoint  Oracle Redo Logs
                     2021-06-30 16:04:29  Thread 2, Seqno 8, RBA 48878592
                     SCN 0.2307589 (2307589)


Current Checkpoint Detail:

Read Checkpoint #1

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 1
    Sequence #: 7
    RBA: 58812944
    Timestamp: 2021-06-30 15:47:23.000000
    SCN: 0.2299680 (2299680)
    Redo File: +REDO/SLNNGK/ONLINELOG/group_1.257.1076389009

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 1
    Sequence #: 7
    RBA: 65249296
    Timestamp: 2021-06-30 16:03:58.000000
    SCN: 0.2307511 (2307511)
    Redo File: +REDO/SLNNGK/ONLINELOG/group_1.257.1076389009

  Current Checkpoint (position of last record read in the data source):
    Thread #: 1
    Sequence #: 7
    RBA: 65249792
    Timestamp: 2021-06-30 16:03:58.000000
    SCN: 0.2307511 (2307511)
    Redo File: +REDO/SLNNGK/ONLINELOG/group_1.257.1076389009

  BR Previous Recovery Checkpoint:
    Thread #: 1
    Sequence #: 0
    RBA: 0
    Timestamp: 2021-06-30 14:26:38.661046
    SCN: Not available
    Redo File: 

  BR Begin Recovery Checkpoint:
    Thread #: 1
    Sequence #: 7
    RBA: 58797056
    Timestamp: 2021-06-30 15:46:56.000000
    SCN: 0.2299621 (2299621)
    Redo File: 

  BR End Recovery Checkpoint:
    Thread #: 1
    Sequence #: 7
    RBA: 58797056
    Timestamp: 2021-06-30 15:46:56.000000
    SCN: 0.2299621 (2299621)
    Redo File: 

Read Checkpoint #2

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 2
    Sequence #: 8
    RBA: 42483728
    Timestamp: 2021-06-30 15:47:23.000000
    SCN: 0.2299697 (2299697)
    Redo File: +REDO/SLNNGK/ONLINELOG/group_4.260.1076389139

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 2
    Sequence #: 8
    RBA: 48878096
    Timestamp: 2021-06-30 16:04:29.000000
    SCN: 0.2307589 (2307589)
    Redo File: +REDO/SLNNGK/ONLINELOG/group_4.260.1076389139

  Current Checkpoint (position of last record read in the data source):
    Thread #: 2
    Sequence #: 8
    RBA: 48878592
    Timestamp: 2021-06-30 16:04:29.000000
    SCN: 0.2307589 (2307589)
    Redo File: +REDO/SLNNGK/ONLINELOG/group_4.260.1076389139

  BR Previous Recovery Checkpoint:
    Thread #: 2
    Sequence #: 0
    RBA: 0
    Timestamp: 2021-06-30 14:26:38.661046
    SCN: Not available
    Redo File: 

  BR Begin Recovery Checkpoint:
    Thread #: 2
    Sequence #: 8
    RBA: 42469376
    Timestamp: 2021-06-30 15:46:55.000000
    SCN: 0.2299621 (2299621)
    Redo File: 

  BR End Recovery Checkpoint:
    Thread #: 2
    Sequence #: 8
    RBA: 42469376
    Timestamp: 2021-06-30 15:46:55.000000
    SCN: 0.2299621 (2299621)
    Redo File: 

Write Checkpoint #1

  GGS Log Trail

  Current Checkpoint (current write position):
    Sequence #: 7
    RBA: 784090
    Timestamp: 2021-06-30 16:04:33.316744
    Extract Trail: ./dirdat/ep
    Seqno Length: 9
    Flip Seqno Length: No
    Trail Type: EXTTRAIL

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

File Information:
  Block Size = 2048
  Max Blocks = 100
  Record Length = 4096
  Current Offset = 0

Configuration:
  Data Source = 3
  Transaction Integrity = 1
  Task Type = 0

Status:
  Start Time = 2021-06-30 15:55:24
  Last Update Time = 2021-06-30 16:04:33
  Stop Status = A
  Last Result = 0



GGSCI (rac01) 105> info dpep

EXTRACT    DPEP      Last Started 2021-06-30 15:55   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:06 ago)
Process ID           26675
Log Read Checkpoint  File /goldengate12c/dirdat/ep000000007
                     2021-06-30 15:58:38.000000  RBA 784090
复制代码

 

posted @   slnngk  阅读(133)  评论(0)  编辑  收藏  举报
编辑推荐：
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识（上）
· 浏览器原生「磁吸」效果！Anchor Positioning 锚点定位神器解析
阅读排行：
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布：重大改进与新特性概览！
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 单线程的Redis速度为什么快？
历史上的今天：
2020-06-30 mysql主库磁盘空间爆满导致从库错误
2020-06-30 从库机器停电导致日志损坏处理
点击右上角即可分享
微信分享提示
AI FOR CODE 大赛