RE: How do you refresh your databases?
- From: "Amaral, Rui" <Rui.Amaral@xxxxxxxxxxxxxxxx>
- To: "'cicciuxdba@xxxxxxxxx'" <cicciuxdba@xxxxxxxxx>, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 22 Mar 2011 16:04:41 -0400
if you're using 11r1 or up maybe duplicate db from active database with skip
tablespace (I am assuming that those tables are in a separate tablespace?). or
maybe Streams?
Rui Amaral
Database Administrator
ITS - SSG
TD Bank Financial Group
220 Bay St., 11th Floor
Toronto, ON, CA, M5K1A2
(bb) (647) 204-9106
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Guillermo Alan Bort
Sent: Tuesday, March 22, 2011 4: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.-
NOTICE: Confidential message which may be privileged. Unauthorized
use/disclosure prohibited. If received in error, please go to www.td.com/legal
for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié.
Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière
d'aller au www.td.com/francais/avis_juridique pour des instructions.
Other related posts:
