OGG入门--replicate进程abended

凌晨时ogg目标端上的恢复进程异常终止，后来通过将问题表从参数文件中剔除，采用从源端将表导出再在目标端导入，再重新启动进程repdayu，最后恢复。

GGSCI (pdayurptdb1) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     DPERPT      00:00:00      00:00:01    
EXTRACT     RUNNING     EXTRPT      00:00:02      00:00:01    
REPLICAT    ABENDED     REPdayu     00:00:00      06:10:08    
REPLICAT    RUNNING     REPdayu2    00:00:04      00:00:01 

 

在这个过程中用到了logdump工具，特此记录一下。

[pdayurptdb1:oracle]:/ora_share/goldengate>cd logdump
ksh: logdump: 0403-037 The specified path name is not a directory.
[pdayurptdb1:oracle]:/ora_share/goldengate>./logdump

Oracle GoldenGate Log File Dump Utility for Oracle
Version 12.2.0.1.170221 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_170123.1033

Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.
 
Logdump 237 >open 
Error: Expected a filename 
Logdump 240 >open ./dirdat/xp011352                      
LogTrail /ora_share/goldengate/gglog-DPERPT-20185322.dmp closed 
Current LogTrail is /ora_share/goldengate/dirdat/xp011352 
Logdump 241 >pos 189745938                                    --指定位置到189745938位置
Reading forward from RBA 189745938 
Logdump 242 >n

2018/10/21 01:06:45.999.178 Delete               Len   307 RBA 189745938 
Name: dayu.RICH_CUSTPROFIT  (TDR Index: 10) 
Before Image:                                             Partition 12   G  m   
 0000 000a 0000 0000 0000 168f 88df 0001 0015 0000 | ....................  
 0011 3231 3030 3037 3737 3737 3135 3233 3530 3400 | ..21000777771523504.  
 0200 1700 0000 1336 3231 3735 3837 3030 3030 3031 | .......6217587000001  
 3133 3234 3638 0003 000c 0000 0008 414d 524a 594c | 132468........AMRJYL  
 3031 0004 000a 0000 0000 0000 0000 0000 0005 0015 | 01..................  
 0000 3230 3138 2d30 372d 3139 3a30 303a 3030 3a30 | ..2018-07-19:00:00:0  
 3000 0600 1500 0032 3031 382d 3037 2d32 303a 3030 | 0......2018-07-20:00  
   

 

 

 

以下为来自网络的图片：

 

转载于:https://www.cnblogs.com/dayu-liu/p/9835727.html