Upendra
I cannot have UAt on NFs with delphix as it has to be on same platform
architecture like Prod with same configuration. We are using delphix for Dev
environment and also these prod don't have any Data masking requirement which
can make the process more complex. Currently doing expdp for set or subset of
table but now looking for full DB to match for some Critical new interface
where multiple UAT env has to be tested with prod equivalent data for all
application schema.
TxSanjay On Friday, November 16, 2018, 11:58:43 AM EST, Upendra nerilla
<nupendra@xxxxxxxxxxx> wrote:
#yiv7029178779 P {margin-top:0;margin-bottom:0;}Are you looking at any 3rd
party products? If so, you may want to look into a product Delphix. It appears
to be a candidate for what you are looking for. It can do data mask as well as
refresh environments quickly.Tim Gorman is in the list - works for Delphix -
reach out to him for any technical details..
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
Sent: Friday, November 16, 2018 11:21 AM
To: Oracle-L Freelists
Subject: Oracle multi Tb refresh for UAT from Prod Can someone share the
process used in your experience/organization where you have several multi TB
database and need to frequently refresh UAT for performance testing ? I am
looking not much from Masking the data which are sometimes required but based
on dropping prod user and adding Test user and application schema back ?
Appreciate If someone can share any script used for sync user/password which
can be main challenge as other Registration with OEM/Catalog can be handled
easily.
TxSanjay