Re: Oracle multi Tb refresh for UAT from Prod

 Chris
I was also checking for the same but never used it. The environment where I need the help like both Prod and UAt are Exadata V6 different OVM and so was looking the link online  and found some details and really appreciate if you can share your experience and reference doc. I can do the test with ASM diskgroup as had plenty of space to test I was not able to get more details like1. What are the impact for this on Prod environment while collecting the changed block? We are all Multi tenant Architecture and so had to refresh PDB using clone and are still on 12.1. So not sure if need to make pdb read onlyu like done for pdb clone in 12.1.2. Storage requiremnt like for test Master or clones ?3. Can we able to use Standby for any setup ? We also have Dedicated Exadata DR ? I read some details while exploring on best solution as need to do multiple such refresh in coming months on regular basis. So if you can share your experience with Exadata ASM environment and reference docs. TxSanjay

    On Friday, November 16, 2018, 5:09:50 PM EST, Chris Taylor <christopherdtaylor1994_at_gmail.com> wrote:  

 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_at_freelists.org 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_at_freelists.org> 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. TxSanjay On Friday, November 16, 2018, 11:58:43 AM EST, Upendra nerilla <nupendra_at_hotmail.com> 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_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sanjay Mishra <dmarc-noreply_at_freelists.org> 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   

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