My Oracle Support Banner

Alter Classic Extract Not Taking Specific TimeStamp With Begin (Doc ID 2625040.1)

Last updated on MAY 29, 2020

Applies to:

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

Symptoms

ALTER EXTRACT to a specific time against GG 12.3 and it appears it isn't
working correctly.

Sample example 12.3 gg :-

extract before alter :

EXTRACT <EXT NAME> Last Started 2019-11-14 18:27 Status STOPPED
Checkpoint Lag 00:02:01 (updated 71:27:37 ago)
Log Read Checkpoint Oracle Redo Logs
2019-11-14 18:38:46 Seqno 142504, RBA 2064
SCN 1407.654920853 (6043673906325)

Alter command: - alter <EXT NAME> begin 2019-11-14 13:00

after alter command : -EXTRACT <EXT NAME> Initialized 2019-11-17 18:09 Status
STOPPED
Checkpoint Lag 106:39:04 (updated 00:00:05 ago)
Log Read Checkpoint Oracle Redo Logs
2019-11-13 07:30:00 Seqno 0, RBA 0
SCN 0.0 (0)

expected result should be it should start with timing 1:00 pm on 14th Nov as
per command but it shows the timing as 2019-11-13 07:30:00 which is wrong.

Following is sample example for 12.1 gg where it works fine:-

Extract before alter :-

EXTRACT    <EXT NAME>    Last Started 2019-11-14 21:02   Status STOPPED
Checkpoint Lag       00:00:00 (updated 59:04:08 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2019-11-14 18:55:00  Seqno 0, RBA 0
                     SCN 0.0 (0)

altert command:- alter <EXT NAME> begin 2019-11-14 13:00

extract after alter comand:-

EXTRACT   <EXT NAME>    Initialized   2019-11-17 22:05   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2019-11-14 13:00:00  Seqno 0, RBA 0
                     SCN 0.0 (0)

As it shows that after alter command the extract reached at exact time i.e.
2019-11-14 13:00.

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
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.