RE: PROD to PERF refresh

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

1. 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
2. Once PDBP restore to Aux instance, Close the PDBP and unplug to XML file
3. Shutdown the Aux Instance
4. 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.
5. Open the PDBU and completed the refresh
6. Add any Old UAT user as well as other objects required for UAt.

Tx

Sanjay

--

Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 21 2019 - 04:31:04 CET