We have a setup of Oracle Golden Gate 19c Microservices with source being Oracle SaaS DB. Thus downstream mining is running in Oracle VM DB system. We receive the redo logs from Source SaaS to our mining Database, where extract process runs. And we have 2 two instance for replication process. Everything was working fine, until the Source SaaS database was refreshed few days back
After the refresh, we had to setup the extract process again using Begin Now parameter and when we tried to start the replication, we got the below errors:-
Oracle GoldenGate Delivery for Oracle, REP33.prm: Error mapping from EKBN_DEV4_US6_GSI_F.FUSION.fnd_wls_active to SBXRPTDB_PDB1.FUSION.fnd_wls_active
We did not see any erros in gg logs and report file logs. So we took the logdump of the trail files and observed that the in the trail files the all the columns are not reported in before and after image.
Thus, we came to conclusion that after the refresh, one of our colleague did not enabled the trandata. Once we enabled the trandata, we were able to start the replicate with the required SCN number.
choose the option "start with options" and then provide the sequence number.
ADD SCHEMATRANDATA DB_name.schema
Hope this helps someone. Keep learning
