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