Re: Got Questions: Golden Gate replication between cloned environments

Additional details.

1. To clone the environments we snapshot the storage protection group and provide the snapshot as the cloned db (Pure Storage Array - take snapshot of Prod Disk Group, and mount that snapshot on Dev/Staging/QA servers as a dev/staging or QA database) The cloned copies (OLTP and DW) are in sync initially but eventually the OLTP and DW Dev/Staging/QA environments get out of sync:

> Through in a few version and env details while you're at it. I wouldn't
> think your scenario would be impacted to much with the release but we've
> had different issues where the release was critical in getting the
> requirement to work.
>
> On Fri, Dec 1, 2017 at 8:42 AM, Ls Cheng <exriscer_at_gmail.com> wrote:
>
>> Hi Chris
>>
>> I have setup in a few environments where QA environment is refreshed
>> using Storage Snapshots, works good. How are you refreshing the
>> environments?
>>
>> Thank you
>>
>>
>> On Fri, Dec 1, 2017 at 3: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
>>>
>>>
>>
>
>
> --
> Dave
>

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