My company is really sensitive about keeping up the performance on our core system. Our users also have a requirement to replicate or mirror all data to another location (in another location within city limits) in case a disaster happens. A software vendor came up with a proposal to implement GoldenGate system.
I'm having trouble believing the proposal saying it will have no impact on performance because it utilizes the log that is written during database write. They keep saying that reading the log will have no impact on the server performance. I know for sure writing the log does though.
Also doesn't data transfer from the source to the destination impact the performance of the source server? I'm a beginner at this. Does communication through sockets really have no impact on the source server?
Is there a better way to mirror data without sacrificing performance, at all?