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>

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 PerfSo Prod is cdbname ==> CDBP and PDBname ==> PDBP as Source environmentUAT 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. TxSanjay -- http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 18 2019 - 20:34:51 CET

This message: [ Message body ]
Next message: Upendra nerilla: "Re: Characterset change"
Previous message: Scott Canaan: "RE: Cloud Control 13c Issue"
Next in thread: Mladen Gogala: "Re: PROD to PERF refresh"
Reply: Mladen Gogala: "Re: PROD to PERF refresh"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message