RE: How do you refresh your databases?
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: "cicciuxdba@xxxxxxxxx" <cicciuxdba@xxxxxxxxx>, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 22 Mar 2011 20:21:04 +0000
Would this tool work? I am not sure if it meets your needs as I think you may
have to copy the sensitive data and then obfuscate it.
http://www.datamasker.com/ and/or
http://www.datamasker.com/DataMasking_WhatYouNeedToKnow.pdf
Disclaimer: I have never used the tool but have used their DDL Wizard tool and
have been very happy with it and all my interactions with the company (Net2000,
Ltd.) have been very pleasant.
Hth,
-joe
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Guillermo Alan Bort
Sent: Tuesday, March 22, 2011 2:01 PM
To: oracle-l-freelists
Subject: How do you refresh your databases?
List,
We have to refresh a QA database from production (to have some real data) but
we need to exclude all the PCI/PII from the refresh (it absolutely cannot be
copied from Prod to QA). In addition, we have GG replication on Prod so
anything we do is subject to that.
What would be your approach?
My idea was rman duplicate, but those pci/pii tables rule this out.
Oh, GG cannot be used due to firewall restrictions, we only have database ports
and SSH from Prod to QA
any ideas?
Alan.-
Confidentiality Note: This message contains information that may be
confidential and/or privileged. If you are not the intended recipient, you
should not use, copy, disclose, distribute or take any action based on this
message. If you have received this message in error, please advise the sender
immediately by reply email and delete this message. Although ICAT Managers,
LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for
viruses, it does not guarantee that either are virus-free and accepts no
liability for any damage sustained as a result of viruses. Thank you.
Other related posts:
