惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

人人都是产品经理
人人都是产品经理
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
宝玉的分享
宝玉的分享
月光博客
月光博客
爱范儿
爱范儿
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
WordPress大学
WordPress大学
有赞技术团队
有赞技术团队
阮一峰的网络日志
阮一峰的网络日志
博客园_首页
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
博客园 - 三生石上(FineUI控件)
博客园 - 聂微东
小众软件
小众软件
量子位
MongoDB | Blog
MongoDB | Blog
Blog — PlanetScale
Blog — PlanetScale
The Cloudflare Blog
Stack Overflow Blog
Stack Overflow Blog
U
Unit 42
Hugging Face - Blog
Hugging Face - Blog
T
The Blog of Author Tim Ferriss
H
Help Net Security
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC

博客园 - margiex

OGG的一些常用网址 ogg初始化抽取的快速配置方法一: 将存量数据落地为标准trail 利用GoldenGate 21实现mysql8远程DDL同步 GoldenGate 21c发布 OGG配置文件中参数化的运用 GoldenGate基于中间队列文件的初始化 一次linux中毒,挖矿病毒 ogg同步Oracle数据库用户验证 GoldenGate在MySQL 集群中的应用 Oracle GoldenGate现在支持从 PostgreSQL 捕获数据 GoldenGate 2020.7 发布新特性 - 19.1.0.0.200714 GoldenGate如何修改抽取进程的读取点? 使用AutoHotKey提升工作效率 InnoDB和NDB,MySQL群集和InnoDB群集之间有什么区别? GoldenGate 19.1实时文本文件加载攻略 windows 10 excel 打开超连接提示 组织策略阻止... 验证ogg同步数据库表无主键表且目标表包含隐藏字段 配置ogg从Oracle到PostgreSQL的同步复制json数据 pi
goldengate新版本中查看日志读取点
margiex · 2021-03-03 · via 博客园 - margiex

在goldengate新版本中通过info extract, showch不会显示recovery checkpoint对应的seqno/rba,有时候为了准确定位读取的日志,希望能看到相应的seqno.
通过info extract,可以看到当前读取点,如下:
以下是集成抽取,当前读取点默认也未显示,只有当前时间及对应的scn
info ex1

EXTRACT EX1 Last Started 2021-03-02 13:47 Status RUNNING
Checkpoint Lag 00:00:04 (updated 00:00:02 ago)
Process ID 12554
Log Read Checkpoint Oracle Integrated Redo Logs
2021-03-03 10:48:33
SCN 0.9055659 (9055659)

这是传统抽取,可以看到当前读取点
info exc

EXTRACT EXC Last Started 2021-02-26 12:55 Status STOPPED
Checkpoint Lag 00:00:00 (updated 117:41:14 ago)
Log Read Checkpoint Oracle Redo Logs
2021-02-26 13:07:26 Seqno 376, RBA 898560
SCN 0.8638302 (8638302)

不过集成抽取可以使用send ex1, status看当前读取点
Sending STATUS request to EXTRACT EX1 ...
EXTRACT EX1 (PID 12554)
Current status: Recovery complete: Processing data

Current read position:
Redo thread #: 1
Sequence #: 396
RBA: 3632796
Timestamp: 2021-03-03 10:52:49.000000
SCN: 0.9055843 (9055843)
Current write position:
Sequence #: 12
RBA: 2476
Timestamp: 2021-03-03 10:52:49.041473
Extract Trail: ./dirdat/e1

这是集成抽取的showch日志,看不到recovery checkpoint对应的seqno/rba
Read Checkpoint #1

Oracle Integrated Redo Log

Startup Checkpoint (starting position in the data source):
Timestamp: 2021-02-02 15:11:22.000000
SCN: 0.0 (0)

Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Timestamp: 2021-03-03 10:48:48.000000
SCN: 0.9055668 (9055668)

Current Checkpoint (position of last record read in the data source):
Timestamp: 2021-03-03 10:48:48.000000
SCN: 0.9055668 (9055668)

经典抽取的showch日志,也看不到recovery checkpoint对应的seqno/rba
Read Checkpoint #1

Oracle Redo Log

Startup Checkpoint (starting position in the data source):
Timestamp: 2021-02-26 12:54:48.000000
SCN: 0.0 (0)

Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Timestamp: 2021-02-26 13:07:26.000000
SCN: 0.8638301 (8638301)

Current Checkpoint (position of last record read in the data source):
Timestamp: 2021-02-26 13:07:26.000000
SCN: 0.8638302 (8638302)

如果想看到recovery checkpoint对应的seqno/rba,则要使用下面的语法
info exc, showch debug
...
Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 376
RBA: 897,552
Timestamp: 2021-02-26 13:07:26.000000
SCN: 0.8638301 (8638301)
Redo File: /u01/app/oracle/oradata/orcl/redo01.log

Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 396
RBA: 3,651,088
Timestamp: 2021-03-03 10:53:50.000000
SCN: 0.9055880 (9055880)
Redo File: /u01/app/oracle/oradata/orcl/redo03.log

Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 396
RBA: 3,652,096
Timestamp: 2021-03-03 10:53:50.000000
SCN: 0.9055881 (9055881)
Redo File: /u01/app/oracle/oradata/orcl/redo03.log

集成抽取的当前读取点,也可以这样看
info ex1 debug
EXTRACT EX1 Last Started 2021-03-02 13:47 Status RUNNING
Checkpoint Lag 00:00:10 (updated 00:00:04 ago)
Process ID 12554
Log Read Checkpoint Oracle Integrated Redo Logs
2021-03-03 10:54:19 Seqno 396, RBA 3661536
SCN 0.9055910 (9055910)