Mark
I need to Restore the PROD PDB so as to replace the existing UAT PDB with prod
data. Oracle version is 12.1.0.2 and so RMAN restore on Dev server will go to
AUX instance with PDB name as PROD itself. Then I need to unplug this PDB from
Aux instance and plug to UAT CDB with UAT PDB name.
I know lots of people is doing this approach for big TB environment where
Expdp/Impdp is not feasible approach.
Also doing RMAN PDB process, all UAT user/Db links etc will be lost and so has
to be replaced after the PDB is refresh or plugged
TXSanjay
On Sunday, January 20, 2019, 10:32:08 PM EST, Mark W. Farnham
<mwf@xxxxxxxx> wrote:
#yiv7973538778 #yiv7973538778 -- _filtered #yiv7973538778
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv7973538778
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv7973538778
{font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}#yiv7973538778
#yiv7973538778 p.yiv7973538778MsoNormal, #yiv7973538778
li.yiv7973538778MsoNormal, #yiv7973538778 div.yiv7973538778MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;color:black;}#yiv7973538778
a:link, #yiv7973538778 span.yiv7973538778MsoHyperlink
{color:blue;text-decoration:underline;}#yiv7973538778 a:visited, #yiv7973538778
span.yiv7973538778MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv7973538778 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;color:black;}#yiv7973538778
pre
{margin:0in;margin-bottom:.0001pt;font-size:10.0pt;color:black;}#yiv7973538778
span.yiv7973538778HTMLPreformattedChar
{font-family:Consolas;color:black;}#yiv7973538778
span.yiv7973538778EmailStyle20 {color:#1F497D;}#yiv7973538778
.yiv7973538778MsoChpDefault {font-size:10.0pt;} _filtered #yiv7973538778
{margin:1.0in 1.0in 1.0in 1.0in;}#yiv7973538778 div.yiv7973538778WordSection1
{}#yiv7973538778 _filtered #yiv7973538778 {}#yiv7973538778 ol
{margin-bottom:0in;}#yiv7973538778 ul {margin-bottom:0in;}#yiv7973538778
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Mladen Gogala
Sent: Friday, January 18, 2019 11:36 PM
To: oracle-l@xxxxxxxxxxxxx
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
- 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.
Tx
Sanjay
-- Mladen GogalaDatabase ConsultantTel: (347) 321-1217
