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

推荐订阅源

F
Fortinet All Blogs
MyScale Blog
MyScale Blog
Microsoft Security Blog
Microsoft Security Blog
量子位
B
Blog
aimingoo的专栏
aimingoo的专栏
Apple Machine Learning Research
Apple Machine Learning Research
阮一峰的网络日志
阮一峰的网络日志
The GitHub Blog
The GitHub Blog
T
The Exploit Database - CXSecurity.com
N
News | PayPal Newsroom
Cloudbric
Cloudbric
A
About on SuperTechFans
AI
AI
Hacker News: Ask HN
Hacker News: Ask HN
S
Schneier on Security
Recent Commits to openclaw:main
Recent Commits to openclaw:main
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
C
Cyber Attacks, Cyber Crime and Cyber Security
L
LINUX DO - 最新话题
T
The Blog of Author Tim Ferriss
Simon Willison's Weblog
Simon Willison's Weblog
有赞技术团队
有赞技术团队
H
Heimdal Security Blog
J
Java Code Geeks
大猫的无限游戏
大猫的无限游戏
D
Docker
Security Archives - TechRepublic
Security Archives - TechRepublic
N
News and Events Feed by Topic
IT之家
IT之家
Know Your Adversary
Know Your Adversary
N
Netflix TechBlog - Medium
T
Tailwind CSS Blog
B
Blog RSS Feed
C
Cybersecurity and Infrastructure Security Agency CISA
C
Cisco Blogs
博客园 - 叶小钗
美团技术团队
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
H
Hackread – Cybersecurity News, Data Breaches, AI and More
L
LangChain Blog
The Hacker News
The Hacker News
Y
Y Combinator Blog
I
Intezer
The Register - Security
The Register - Security
F
Full Disclosure
V
V2EX
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
Last Week in AI
Last Week in AI
Martin Fowler
Martin Fowler

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