Goldengate ERROR: Extract can not be positioned to specified timestamp

Hi,

Sometimes you can get ” ERROR: Extract ‘EMSD0101’ can not be positioned to specified timestamp. ” error during changing the extract start time.

Details of error are as follows.

GGSCI (goldenmsd01 as GGS_ADMIN19C@MSDBA_1) 4> alter EMSD0101 begin 2020-04-14 16:30:18.001472
ERROR: Extract 'EMSD0101' can not be positioned to specified timestamp.

You should firstly delete extract as follows.

GGSCI (goldenmsd01 as GGS_ADMIN19C@MSDBA_1) 8> delete EMSD0101
Deleted EXTRACT EMSD0101.

Then add extract again with the BEGIN parameter as follows.

ADD EXTRACT EMSD0101, INTEGRATED TRANLOG, BEGIN 2020-04-14 16:30

GGSCI (goldenmsd01 as GGS_ADMIN19C@MSDBA_1) 10>  ADD EXTRACT EMSD0101, INTEGRATED TRANLOG, BEGIN 2020-04-14 16:30
EXTRACT (Integrated) added.

Add exttrail as follows.

GGSCI (goldenmsd01 as GGS_ADMIN19C@MSDBA_1) 11>  ADD EXTTRAIL /ggatea01/MSDBA_19c/e1 EXTRACT EMSD0101, MEGABYTES 1000
EXTTRAIL added.

Now start it, it was started as follows.

GGSCI (goldenmsd01 as GGS_ADMIN19C@MSDBA_1) 12> start EMSD0101

Sending START request to MANAGER ...
EXTRACT EMSD0101 starting


GGSCI (goldenmsd01 as GGS_ADMIN19C@MSDBA_1) 13>

Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/