I have configured OGG for one-to-one replication and working fine
Now I would like to have muliple schema's to multiple targets, using one souce Database (Master DB)
a - do I set up indivdual extract files (for each schema) that then map to their target(s)
b - as the extracts are reading from one set of redo log files, how to you legislate against failure, when the Databases roles are switched.
I understand that in DG the main DB will switch roles but at this point the scn will be out of synch for the replication and therefore
recovery will be inoperable when I switch back.
We are operating in a DG 12c env not RAC
Am I misunderstanding here - any advice will be most welcome
Junior Oracle DBA
Oracle is a never ending learning curve
learn to share and share to enhance one's knowledge
Ron Jeremy circa 1974