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

Last updated on APRIL 17, 2023

Applies to:

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

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