RE: How do you refresh your databases?
Date: Tue, 22 Mar 2011 20:21:04 +0000
Message-ID: <D18D6513433DF04394041EA42B53E91C018A1F_at_ICATEXCH2.ICAT.com>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 22 2011 - 15:21:04 CDT