Sanjay,
What is your storage device under your primary db? (or even your standby
db?)
We snap clone our Prod (or Standby) db on Pure storage but the same
technology exists for EMC etc.
Snapclones are bad fast and appear to be full size clones to the user/dba.
But is a fraction of the space on the storage device.
Chris
On Fri, Nov 16, 2018, 12:56 PM Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx
wrote:
Tim
Thanks for sharing the script and providing all detailed information. This
is very good starting point and can be to add any extra stuff like you
mentioned for dropping prod user etc or any masking.
thanks again for your time.
Sanjay
On Friday, November 16, 2018, 12:51:11 PM EST, Sanjay Mishra <
dmarc-noreply@xxxxxxxxxxxxx> wrote:
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.
Tx
Sanjay
On Friday, November 16, 2018, 11:58:43 AM EST, Upendra nerilla <
nupendra@xxxxxxxxxxx> wrote:
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.
Tx
Sanjay
