My Oracle Support Banner

OGG Integrated Extract Is Having Lag During Database Logfile Switch (Doc ID 2725586.1)

Last updated on NOVEMBER 18, 2020

Applies to:

Oracle GoldenGate - Version 19.1.0.0.4 and later
Information in this document applies to any platform.

Symptoms

OGG Integrated Extract is having lag during database logfile switch:

EXTRACT    IETEST   Last Started 2020-10-18 19:44   Status RUNNING
Checkpoint Lag       00:00:27 (updated 00:00:02 ago)
Process ID           69475
Log Read Checkpoint  Oracle Integrated Redo Logs
                     2020-10-20 17:23:48
                     SCN 3276.2341978668 (14072654840364)

When a log switch occurs in other nodes other than the node where IE is
running, there are frequent redo recognition of LOGMNR and capture (Begin) delay.
Under each Node you can see ##GAP.

2020-10-07T14:27:52.187653+09:00
Thread 1 advanced to log sequence 4197 (LGWR switch),  current SCN: 14071989098149
  Current log# 1 seq# 4197 mem# 0: +REXX/TEST/LOG/group_1.538.1050595595
  Current log# 1 seq# 4197 mem# 1: +DATA/TEST/LOG/group_1.1694.1050595595
2020-10-07T14:27:52.777602+09:00
ARC2 (PID:280831): Archived Log entry 5905 added for T-1.S-4196 ID 0xb5ff5246 LAD:1
2020-10-07T14:27:55.380971+09:00
LOGMINER: End   mining logfile for session 1 thread 1 sequence 4196, +REXX/TEST/LOG/group_2.534.1050595597
2020-10-07T14:27:55.381058+09:00
LOGMINER: End   mining logfile for session 2 thread 1 sequence 4196, +REXX/TEST/LOG/group_2.534.1050595597
2020-10-07T14:27:57.459436+09:00
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 4197, +REXX/TEST/LOG/group_1.538.1050595595
2020-10-07T14:27:57.459440+09:00 <<##GAP >>>>>>>>>>>>>>>Logfile switch delay
LOGMINER: Begin mining logfile for session 2 thread 1 sequence 4197, +REXX/TEST/LOG/group_1.538.1050595595
2020-10-07T14:28:20.555265+09:00 <<##GAP>>>>>>>>>>>>>>Logfile switch delay 23 Sec ,Read Thread2's Logfiles
LOGMINER: End   mining logfile for session 1 thread 2 sequence 1809, +DATA/TEST/LOG/group_9.1669.1050596915
2020-10-07T14:28:20.555397+09:00
LOGMINER: End   mining logfile for session 2 thread 2 sequence 1809, +DATA/TEST/LOG/group_9.1669.1050596915

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.