风哥教程

培训 . 交流 . 分享
Make progress together!

oracle goldengate恢复过程

[复制链接]
内容发布:paulyi| 发布时间:2014-3-1 16:22:29
oracle goldengate恢复过程

上次客户数据库异常down机,goldengate 起来时提示要恢复归档,而且当时又有长事物,
需要几天前的归档。恢复归档后,goldengate恢复非常慢,而且看起来没什么进展。
用以下命令可以看到 恢复进度。
先做bound recovery ,然后应用归档

send ESX00004 status
Sending STATUS request to EXTRACT ESX00004 ...

EXTRACT ESX00004 (PID 7279854)
Current status: In recovery[1]: Reading from data source
Current read position:
Sequence #: 568246
RBA: 126091080
Timestamp: 2012-10-09 15:21:08.000000
Current write position:
Sequence #: 543
RBA: 7328035
Timestamp: 2012-10-09 15:21:11.183112
Extract Trail: /gglog/dirdat/esx00004/ex


send ESX00004 status
Sending STATUS request to EXTRACT ESX00004 ...

EXTRACT ESX00004 (PID 7279854)
Current status: Recovery complete: Reading from data source
Current read position:
Sequence #: 568247
RBA: 121504
Timestamp: 2012-10-09 15:27:51.000000
Current write position:
Sequence #: 547
RBA: 1275
Timestamp: 2012-10-10 10:00:12.666305
Extract Trail: /gglog/dirdat/esx00004/ex


send ESX00004 status
Sending STATUS request to EXTRACT ESX00004 ...

EXTRACT ESX00004 (PID 7279854)
Current status: Recovery complete: Reading from data source
Current read position:
Sequence #: 568247
RBA: 211006772
Timestamp: 2012-10-09 15:28:35.000000
Current write position:
Sequence #: 547
RBA: 15433
Timestamp: 2012-10-10 10:00:32.733882
Extract Trail: /gglog/dirdat/esx00004/ex


Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Sequence #: 568247
RBA: 2356192
Timestamp: 2012-10-09 15:27:54.000000
Redo File: Not Avaliable
Current Checkpoint (position of last record read in the data source):
Sequence #: 568248
RBA: 862226464
Timestamp: 2012-10-09 15:30:20.000000
Redo File: /db_bak/db_1_568248.arch




Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Sequence #: 568247
RBA: 450462196
Timestamp: 2012-10-09 15:28:52.000000
Redo File: Not Avaliable
Current Checkpoint (position of last record read in the data source):
Sequence #: 568251
RBA: 66576352
Timestamp: 2012-10-09 15:31:43.000000
Redo File: /db_bak/db_1_568251.arch

查看goldengate 异常恢复很有用的两个命令
send extract_name status
info extrace_name,detail


上一篇:oracle goldengate 目标端表空间满导致进程abended处理过程
下一篇:oracle goldengate OGG-01264问题处理
回复

使用道具 举报

内容发布:ioriakyo| 发布时间:2014-8-18 17:30:52
:lol这个我们瞎忙了一个通宵,哈哈!OGG的意外宕机处理恢复还是不错的,通过这次我们才了解到,类似数据库
回复 支持 反对

使用道具 举报

1框架
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

热门文章教程

  • 实战PHP与MySQL权威指南PDF电子书下载
  • 大数据技术与应用入门培训教程(电子版下载
  • Oracle 12cR2 九大新功能全面曝光_详解云数
  • Oracle OCP认证考试IZ0-053题库共712题数据
  • MySQL5权威指南(第3版)PDF电子版下载
  • 风哥Oracle数据库巡检工具V1.0(附2.6网页
快速回复 返回顶部 返回列表