Re: PROD to PERF refresh

 Mark
I need to Restore the PROD PDB so as to replace the existing UAT PDB with prod data. Oracle version is 12.1.0.2 and so RMAN restore on Dev server will go to AUX instance with PDB name as PROD itself. Then I need to unplug this PDB from Aux instance and plug to UAT CDB with UAT PDB name. I know lots of people is doing this approach for big TB environment where Expdp/Impdp is not feasible approach. Also doing RMAN PDB process, all UAT user/Db links etc will be lost and so has to be replaced after the PDB is refresh or plugged TXSanjay

    On Sunday, January 20, 2019, 10:32:08 PM EST, Mark W. Farnham <mwf_at_rsiz.com> wrote:  

 #yiv7973538778 #yiv7973538778 -- _filtered #yiv7973538778 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv7973538778 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv7973538778 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}#yiv7973538778 #yiv7973538778 p.yiv7973538778MsoNormal, #yiv7973538778 li.yiv7973538778MsoNormal, #yiv7973538778 div.yiv7973538778MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;color:black;}#yiv7973538778 a:link, #yiv7973538778 span.yiv7973538778MsoHyperlink {color:blue;text-decoration:underline;}#yiv7973538778 a:visited, #yiv7973538778 span.yiv7973538778MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv7973538778 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;color:black;}#yiv7973538778 pre {margin:0in;margin-bottom:.0001pt;font-size:10.0pt;color:black;}#yiv7973538778 span.yiv7973538778HTMLPreformattedChar {font-family:Consolas;color:black;}#yiv7973538778 span.yiv7973538778EmailStyle20 {color:#1F497D;}#yiv7973538778 .yiv7973538778MsoChpDefault {font-size:10.0pt;} _filtered #yiv7973538778 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv7973538778 div.yiv7973538778WordSection1 {}#yiv7973538778 _filtered #yiv7973538778 {}#yiv7973538778 ol {margin-bottom:0in;}#yiv7973538778 ul {margin-bottom:0in;}#yiv7973538778 That’s right.

Where is the part where you clone the files? And you’ve got that bit about some UAT users and additional objects.

This hints that *possibly* you don’t really want to move the entire database as a pluggable unit. Possibly you do the restore rename as suggested to an interim, (avoiding having to prepare prod tablespaces for transport), prepare the tablespaces you want to move from “PRE_AUX” for transport, drop same on AUX from the previous move, and add the new ones from PRE_AUX.

Then your UAT users and objects remain where they are. I think the only wrinkle would be possibly new or changed users on PROD since you initially primed the pump, so you’d need a difference report from PRE_AUX to AUX.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Friday, January 18, 2019 11:36 PM
To: oracle-l_at_freelists.org
Subject: Re: PROD to PERF refresh

You can rename pluggable database by changing its global name..

On 1/18/19 2:34 PM, Sanjay Mishra (Redacted sender smishra_97 for DMARC) wrote:

Hi all

I am working on automating the process of PROD to PERF refresh for Multitenant environment in 12c R1 (12.1.0.2) where PDB name are different in Prod and Perf

So Prod is cdbname ==> CDBP and PDBname ==> PDBP  as Source environment

UAT is dcbname==> CDBU and PDBName ==> PDBU as target environment

So looking for some advise in some of the following steps    

• Restore the CDBP/PDBP into AUX instance on UAT Server. HELP Needed: I want that PDBP files should be restored in <Diskgroup>/CDBU/PDBU location instead of <Diskgroup/AuxCDBname/PDBP. So I should use db_file_name_convert or pdb_file_name_convert or so as if both are used then one can take precedence or so. The reason to have restore in <Diskgroup>/CDBU/PDBU location is to have them available at correct location when Plugging PDBP as PDBU and need not to require to move the datafiles and save time
• Once PDBP restore to Aux instance, Close the PDBP and unplug to XML file
• Shutdown the Aux Instance 
• Create the PDBU using XML file. Here I need to know how I can make it happen fast like syntax using Copy or move or so.
• Open the PDBU and completed the refresh
• Add any Old UAT user as well as other objects required for UAt.

Tx

Sanjay

• Mladen GogalaDatabase ConsultantTel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-l