RDBMS version: Oracle 19c
OS: Oracle Linux 8.3
I am kind of a newbie in Goldengate.
Currently, I am migrating GG processes from 19c Classic architecture to Mircroservices v21.3.
I have a question on how to reposition Distribution path as part of the migration using the java-based migration utility.
In this scenario, the Source_DB in Server X is already running on Microservices architecture.
Now, I am migrating processes in Server Y (Target_DB) from Classic to Mircroservices version 21.3
Source_DB (Server X) Target_DB (Server Y)
EXTABC ----- PABCDistPath --------------------> REPABC
As part of recreating the replicat REPABC, I will be doing the following
Step1. In the source, make a note of the trail sequence number and RBA offset of PABCDistPath by running info distpath PABCDistPath detail
Step2. Stop DistPath at source gracefully
Step3. On target, run the migration utility
Step5. Delete the Distpatch PABCDistPath at source
Step6. Recreate the DistPatch PABCDistPath from GUI on source by using trail sequence number and RBA offset noted from Step1
Step7. In source, start the DistPath PABCDistPath
Step5. Now, start the replicat REPABC in the newly migrated server
My question:
For Step1, I captured the below output from source. So, while recreating the Distribution path PABCDistPath at source, I should be repositioning it to the following Sequence trail number and RBA seen under Current section shown below. Right ?
Sequence: 29274
Offset: 49931950
I don't want to miss any transaction and I don't want transactions to be duplicated.
OGG (http://localhost:9001 DEPLOY01) 8> info distpath PABCDistPath detail
Path Name: PABCDistPath
Status: running
Source: trail://10.25.9.1:9002/services/v2/sources?trail=./ha
Target: ogg://manhdevtest278.com:7809/services/v2/targets?trail=/opt/oracle/goldengate/version/19.1/dirdat/ha
Size (MB): 500
Sequence Length: 9
Encryption Algorithm: None
Begin Position: seqno: 24456 rba: 418351
AutoRestart: retries 4, delay 4
Critical: no
Process Id: 3905259
Thread Id: 3905280
Last Started: 2024-08-01T12:21:54.394Z
Source Database Name: CDB_07D
Processing Lag: 0
Since Lag Reported: 4
Encryption Profile: LocalWallet
Checkpoints:
Input Checkpoint:
Current:
Name: ha
Sequence: 29274
Offset: 49931950
Path: /u03/trails/microservices/deploy_01/var/lib/data/./
Sequence Length: 9
Sequence Length Flip: no
Timestamp: 2024-08-28T09:45:36.000Z
Starting:
Name: ha
Sequence: 25420
Offset: 40442619
Path: /u03/trails/microservices/deploy_01/var/lib/data/./
Sequence Length: 9
Sequence Length Flip: no
Timestamp: 2024-07-30T13:50:08.660Z
Output Checkpoint:
Current:
Name: ha
Sequence: 3027
Offset: 279022366
Path: unknown
Sequence Length: 9
Sequence Length Flip: no
Timestamp: 2024-08-28T09:45:55.082Z