Oracle GoldenGate(OGG) 异常长事务排查处理

#########################################################################

Oracle GoldenGate(OGG) 异常长事务排查处理

#########################################################################

问题现象

1、无法正常停止抽取进程
GGSCI (rac1) 233> STOP EXT_124

 Sending STOP request to EXTRACT EXT_124 ...
 
 STOP request pending. There are open, long-running transactions.
 Before you stop Extract, make the archives containing data for those transactions available for when Extract restarts.
 To force Extract to stop, use the SEND EXTRACT EXT_124, FORCESTOP command.Oldest redo log files necessary to restart Extract are:
 
 Redo Thread 1, Redo Log Sequence Number 652694, SCN 69.3490852697 (299843596121), RBA 3941174288
 Redo Thread 2, Redo Log Sequence Number 61948, SCN 72.4167556123 (313405201435), RBA 221872656.
 
 2021-08-04 14:43:14  WARNING OGG-01742  Command sent to EXTRACT EXT_124 returned with an invalid response.
 
 
 GGSCI (rac1) 234> 

处理步骤

1、查询超过1天的长事务列表
– 命令语法：
SEND EXTRACT <进程名>, SHOWTRANS DURATION [S|SEC|SECS|SECOND|SECONDS|M|MIN|MINS|MINUTE|MINUTES|H|HOUR|HOURS|D|DAY|DAYS] TABULAR

 -- 操作示例：
 GGSCI (rac1) 224> SEND EXTRACT EXT_1