OGG 12.1及以前的版本
巡检时发现ogg传输进程异常
报错如下：
2021-12-09 16:25:19 ERROR OGG-06498 The sequence number 998999 for output trail file ‘/data/ggs/dirdat/tp’ has exceeded the maximum threshold (998999). Please consult
Oracle Knowledge Management Doc ID 1559048.1 for further actions.
问题原因
OGG 12.1及以前的版本 trail文件为6位数。已经达到最大值。
解决方案
GGSCI (syncdbadm01.sync.sdjj.com) 21> info dpjcpt
EXTRACT DPJCPT Last Started 2021-12-09 16:13 Status ABENDED
Checkpoint Lag 00:00:00 (updated 05:25:13 ago)
Log Read Checkpoint File ./dirdat/pt991992
2021-12-09 10:49:53.000000 RBA 218399
GGSCI (syncdbadm01.sync.sdjj.com) 23> info EXTJCPTEXTRACT EXTJCPT Last Started 2021-11-19 18:53 Status STOPPED
Checkpoint Lag 00:00:01 (updated 00:00:15 ago)
Log Read Checkpoint Oracle Redo Logs
2021-12-09 16:26:09 Thread 1, Seqno 388329, RBA 419120348
SCN 4730.2035137477 (20317230447557)
Log Read Checkpoint Oracle Redo Logs
2021-12-09 16:26:07 Thread 2, Seqno 306150, RBA 4602368
SCN 4730.2035137355 (20317230447435)停止源端抽取进程
stop extjcpt
删除源端投递进程rmttrail文件并建立新的rmttrail文件
delete rmttrail /data/ggs/dirdat/tp
delete rmttrail ./dirdat/tp
ADD rmttrail /data/ggs/dirdat/tq, EXTRACT DPJCPT
编辑投递进程参数，修改参数文件中的rmttrail文件
rmttrail /home/oracle/ogg/dirdat/tq
开启源端投递进程查看目标端是否生成新的trail文件
start dpjcpt
[oracle@jcpt dirdat]$ ls
tp991992 tq000000 tq000001
目标端确认同步进程已应用最后的trail文件且无变化
info repjcpt
GGSCI (jcpt) 23> info repjcpt
EXTRACT EXTJCPT Last Started 2021-11-19 19:10 Status RUNNING
Checkpoint Lag 00:00:01 (updated 00:00:15 ago)
Log Read Checkpoint File /ogg/dirdat/tp991992
2021-12-09 15:07:12 RBA 134732
修改目标端同步进程应用到新的trail文件
stop repjcpt
alter repjcpt,exttrail ./dirdat/tq
start repjcpt
info repjcpt
GGSCI (jcpt) 23> info repjcpt
EXTRACT EXTJCPT Last Started 2021-11-19 19:10 Status RUNNING
Checkpoint Lag 00:00:01 (updated 00:00:15 ago)
Log Read Checkpoint File /ogg/dirdat/tq000001
2021-12-09 15:10:09 RBA 1246
源端重置抽取进程tail文件
stop dpjcpt
delete exttrail ./dirdat/pt
ADD EXTTRAIL /ogg/ggs/dirdat/qt, EXTRACT EXTJCPT
alter dpjcpt exttrailsource ./dirdat/qt
配置源端抽取进程参数
edit params extjcpt
exttrail /ogg/ggs/dirdat/qt
启动进程
start extjcpt
start dpjcpt
参考文档
Oracle MOS
Goldengate Replicat Process Abending With ERROR OGG-01332 File <filename>, with compatibility level 6, is not compatible with the current software version’s compatibility level of 4 (Doc ID 2538448.1)
Replicat checkpoint shows 9 digit trail file instead of 6 digits when source OGG version is 12.1.x and target OGG version is 12.2.x (Doc ID 2120995.1)