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: /sxdb_bak/sxdb_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: /sxdb_bak/sxdb_1_568251.arch

查看goldengate 异常恢复很有用的两个命令

send  extract_name status

info extrace_name,detail

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-747825/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-747825/