Hi
We snapshot environments very often for QA, includes both database and
goldengate, scripted. The refresh process takes 15 minutes to clone 5
databases and sometimes we run 4 or 5 times per day for the QA team. I
think in QA the correct process is script the entire refresh process.
On Mon, Dec 4, 2017 at 5:30 PM, Jeff Chirco <backseatdba@xxxxxxxxx> wrote:
I've heard other people mention why not just keep Dev/Staging/QA
continually updated, but if you are making a bunch of DDL and DML changes
in those environments then you will often have abended goldengate process
as those tables are updated or when those code changes go to production.
What would be the correct process for this?
On Sun, Dec 3, 2017 at 7:24 AM, Bobby Curtis <curtisbl@xxxxxxxxx> wrote:
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@gmail.
com> 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
