How do you refresh your databases?
From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Tue, 22 Mar 2011 17:00:44 -0300
Message-ID: <AANLkTimwBicvXxOcyqi3Y7x-AG4K3HhpE97WJ4E4QphY_at_mail.gmail.com>
List,
Date: Tue, 22 Mar 2011 17:00:44 -0300
Message-ID: <AANLkTimwBicvXxOcyqi3Y7x-AG4K3HhpE97WJ4E4QphY_at_mail.gmail.com>
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.-
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 22 2011 - 15:00:44 CDT