Re: Oracle multi Tb refresh for UAT from Prod
Date: Fri, 16 Nov 2018 16:57:51 +0000
Message-ID: <SN1PR10MB036876325714E2BF1F138F94D8DD0_at_SN1PR10MB0368.namprd10.prod.outlook.com>
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.
Tx
Sanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 16 2018 - 17:57:51 CET