PROD to PERF refresh
From: Sanjay Mishra <"Sanjay>
Date: Fri, 18 Jan 2019 19:34:51 +0000 (UTC)
Message-ID: <1236231591.3837.1547840091568_at_mail.yahoo.com>
Date: Fri, 18 Jan 2019 19:34:51 +0000 (UTC)
Message-ID: <1236231591.3837.1547840091568_at_mail.yahoo.com>
- 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. TxSanjay -- http://www.freelists.org/webpage/oracle-l