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

推荐订阅源

H
Help Net Security
博客园 - Franky
GbyAI
GbyAI
Threat Intelligence Blog | Flashpoint
Threat Intelligence Blog | Flashpoint
爱范儿
爱范儿
IT之家
IT之家
酷 壳 – CoolShell
酷 壳 – CoolShell
aimingoo的专栏
aimingoo的专栏
博客园_首页
MongoDB | Blog
MongoDB | Blog
CTFtime.org: upcoming CTF events
CTFtime.org: upcoming CTF events
Recent Announcements
Recent Announcements
Scott Helme
Scott Helme
有赞技术团队
有赞技术团队
M
MIT News - Artificial intelligence
C
CERT Recently Published Vulnerability Notes
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
Jina AI
Jina AI
F
Fortinet All Blogs
N
Netflix TechBlog - Medium
L
LangChain Blog
L
LINUX DO - 最新话题
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
cs.AI updates on arXiv.org
cs.AI updates on arXiv.org
H
Hacker News: Front Page
MyScale Blog
MyScale Blog
P
Palo Alto Networks Blog
G
Google Developers Blog
Google DeepMind News
Google DeepMind News
AI
AI
T
Troy Hunt's Blog
Microsoft Azure Blog
Microsoft Azure Blog
阮一峰的网络日志
阮一峰的网络日志
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
Vercel News
Vercel News
Microsoft Security Blog
Microsoft Security Blog
罗磊的独立博客
S
Secure Thoughts
大猫的无限游戏
大猫的无限游戏
博客园 - 叶小钗
人人都是产品经理
人人都是产品经理
Blog — PlanetScale
Blog — PlanetScale
博客园 - 司徒正美
Apple Machine Learning Research
Apple Machine Learning Research
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
博客园 - 三生石上(FineUI控件)
S
Security @ Cisco Blogs
Cloudbric
Cloudbric
E
Exploit-DB.com RSS Feed
Attack and Defense Labs
Attack and Defense Labs

博客园 - 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)