Hi OGG Gurus,
I have thought about a scenario where the source database had to be restored using point in time recovery and the target database had also be synced with the source.
But without any full initial load, just with recovering from backup to an earlier point in time recovery (preferably with table space point in time recovery) and later syncing the OGG.
My scenario seems to work. But Oracle has not described it in any form of documentation or MOS note.
It requires some messing up with the checkpoint tables in the SYS schema.
Have I missed something or might it actually work like in my lab?
Here is a full description of my recovery scenario:
https://www.bersler.com/blog/oracle-goldengate-point-in-time-source-database-recovery/
What do you think about it?
Kind regards,
Adam