Hi All,
Hope all is well for everyone.
I had a working GG env. It was working well . Now I had created a new database in a new server by refreshing it from the source database.
Now I need to replicate the source to the new database that I created. I had changed the tnsnames entry in the golden gate replication server to point to the new db that I replicated so that the replication process will be pointing to the new DB that I created. I had started created the check point table and started the replication process. The replication process started, no error but not replicating the source data.
I can see the EXTRACT process created the files bb000000039 , transferred to the GG server as bb000000039 , but the replicate process is looking for file bb000000000. So my question is how can I ask replicated process to starts with bb000000039 instead of bb000000000?
Appreciate your advice for this asap
info EXTRACT1
EXTRACT EXTRACT1 Last Started 2019-07-22 03:08 Status RUNNING
Checkpoint Lag 00:00:10 (updated 00:00:02 ago)
Process ID 1443
Log Read Checkpoint Oracle Integrated Redo Logs
2019-07-22 04:21:42
SCN 0.11012961 (11012961)
info REPLCAT1
REPLICAT REPLCAT1 Last Started 2019-07-22 03:18 Status RUNNING
INTEGRATED
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Process ID 1557
Log Read Checkpoint File /goldengate/dirdat/bb000000000
First Record RBA 0