goldengate新版本中查看日志读取点
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了goldengate新版本中查看日志读取点,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3080字,纯文字阅读大概需要5分钟。
内容图文
在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)
原文:https://www.cnblogs.com/margiex/p/14473271.html
内容总结
以上是互联网集市为您收集整理的goldengate新版本中查看日志读取点全部内容,希望文章能够帮你解决goldengate新版本中查看日志读取点所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。