RE: How do you refresh your databases?
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <deshpande.subodh@xxxxxxxxx>, <cicciuxdba@xxxxxxxxx>
- Date: Wed, 23 Mar 2011 07:47:54 -0400
The easiest in my opinion if possible is the RMAN duplicate, then just drop the
tables after via script before changing passwords. I assume you change
passwords from production if the data is that sensitive.
An alternative as well is to alter table and move it to a tablespace that
isolates all the tables, and then rman and skip that tablespace option solves
the issue.
Once you have done either option once, you have the tools to repeat it easily.
Joel Patterson
Database Administrator
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Subodh Deshpande
Sent: Wednesday, March 23, 2011 12:30 AM
To: cicciuxdba@xxxxxxxxx
Cc: oracle-l-freelists
Subject: Re: How do you refresh your databases?
is this one time task or going to be periodic one..
database refresh rman duplicate is one way and it will copy entire so exclusion
on particular object basis won't be possible
schema refresh is one option..from the source prepare table list and prepare
dmps with rows if structure of tables are same
on the target empty thosr tables disable constraints, import the data and
enable the constraints..if structures are not same those object will throw
errors, after refresh, compare schems with toad kind of tool..
trasport tablespace is also an available option..and please check version
specific errors or bug history on MOS
thanks..
subodh
On 23 March 2011 01:30, Guillermo Alan Bort
<cicciuxdba@xxxxxxxxx<mailto:cicciuxdba@xxxxxxxxx>> wrote:
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.-
--
==============================
DO NOT FORGET TO SMILE TODAY
==============================
Other related posts:
