Re: Got Questions: Golden Gate replication between cloned environments

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