Re: Got Questions: Golden Gate replication between cloned environments

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_at_gmail.com> 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_at_gmail.com> 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_at_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
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l