oracle goldengate恢复过程

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:1270

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

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】