Checkpoint RBA Of OGG Extract Not Moving While Configured In ALO Mode (Doc ID 2121118.1)

Last updated on JANUARY 05, 2017

Applies to:

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

Goal

Extract is not capturing in ALO mode and is stuck at RBA 0

++ Parameters Used

TRANLOGOPTIONS LOGRETENTION DISABLED
TRANLOGOPTIONS _NOREADAHEAD ANY
TRANLOGOPTIONS ARCHIVEDLOGONLY
TRANLOGOPTIONS ALTARCHIVELOGDEST /arch/PRCL/
TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT %t_%s_%r.arc
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 5500 IOLATENCY 180000

eg:-

ggsci> send E2,status

Sending STATUS request to EXTRACT E2 ...

EXTRACT E2 (PID 24204)
Current status: Recovery complete: At EOF

Current read positions:
Redo thread #: 1
Sequence #: 0
RBA: 0
Timestamp: 2016-03-27 10:07:37.000000
SCN: 0.0
Redo thread #: 2
Sequence #: 0
RBA: 0
Timestamp: 2016-03-27 10:07:37.000000
SCN: 0.0
Current write position:
Sequence #: 0
RBA: 1496
Timestamp: 2016-03-27 16:38:02.896061
Extract Trail: /u01/app/ggadmin/product/12.1.2.1.0/dirdat/extract/prcl/e2

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms