Chris,
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?
a. Are you scripting any of the refresh?
2. Can we do an mid-tier approach with GoldenGate?
a. Yes, this is doable and would provide you with a way that just needs
to be reset based on SCN
3. Why not keep Dev/Staging/QA continually updated?
a. 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.
Thanks
Bobby
On Dec 1, 2017, at 2:38 PM, Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
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