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
以下为来自网络的图片: