Re: Got Questions: Golden Gate replication between cloned environments

From: Bobby Curtis <>
Date: Sun, 3 Dec 2017 15:24:16 +0000
Message-Id: <>


There are multiple ways that you can achieve what you want to do with GoldenGate. Just off the top of my head, I would ask the following questions:

  1. Do we need to refresh monthly? If so, what is the level of effort to reset extract and replicats?
  2. Are you scripting any of the refresh?
  3. Can we do an mid-tier approach with GoldenGate?
  4. Yes, this is doable and would provide you with a way that just needs to be reset based on SCN
  5. Why not keep Dev/Staging/QA continually updated?
  6. This would allow you to ship changes to these environments and keep them refreshed near-real-time without having to do clones

Depending on these questions/answers, then develop a plan for implementing.

In a nutshell, Oracle GoldenGate can do what you are asking just depends on the level of work you would like to do before, after, or during a refresh.



> On Dec 1, 2017, at 2:38 PM, Chris Taylor <> wrote:
> We have Golden Gate replication in production and there is some discussion about using Golden Gate replication in the cloned production copies (Dev, Staging, QA).
> We refresh Dev/Staging/QA monthly.
> I don't know Golden Gate very well (beginner/intermediate) but I'm thinking this won't work in the cloned environments as the clones would lose the Golden Gate Extract process each time the clone happened and the SCNs would get out of sync anyway.
> Questions
> 1. Am I wrong in thinking this?
> 2. Is there a way to keep Golden Gate running in cloned environments without a lot of manual intervention?
> I'd like to hear any of the technical issues related to such a setup.
> Thanks,
> Chris

Received on Sun Dec 03 2017 - 16:24:16 CET

Original text of this message