Re: How do you refresh your databases?

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Wed, 23 Mar 2011 09:59:53 +0530
Message-ID: <AANLkTimaRie41_7o5uotXPKSegxau1nZPZaVG1rHbcqm_at_mail.gmail.com>

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_at_gmail.com> 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
==============================

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 22 2011 - 23:29:53 CDT