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