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/