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
