Re: Pluggable database duplication
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 18 Feb 2016 15:11:47 -0500
Message-ID: <56C62583.4090006_at_gmail.com>
On 02/18/2016 11:34 AM, vit.spinka wrote:
> Well…
> First of all, your command will work, if you connect to the CDB root.
> It will create a new CDB, with just the one PDB (rcat) in it.
>
> If you don’t want a new CDB, but just move/copy the PDB into the
> same/another existing CDB, then you should use a clone operation. Safe
> harbor, NDA aside and so on, the word is that it will be possible to
> do do a hot clone in 12.2.
>
> Vit
I have been asked that by a user who is used to restoring SQL Server databases to another machine, without stopping the access. Strange that Oracle didn't think of something that common in SQL Server world or DB2 world.
Date: Thu, 18 Feb 2016 15:11:47 -0500
Message-ID: <56C62583.4090006_at_gmail.com>
On 02/18/2016 11:34 AM, vit.spinka wrote:
> Well…
> First of all, your command will work, if you connect to the CDB root.
> It will create a new CDB, with just the one PDB (rcat) in it.
>
> If you don’t want a new CDB, but just move/copy the PDB into the
> same/another existing CDB, then you should use a clone operation. Safe
> harbor, NDA aside and so on, the word is that it will be possible to
> do do a hot clone in 12.2.
>
> Vit
I have been asked that by a user who is used to restoring SQL Server databases to another machine, without stopping the access. Strange that Oracle didn't think of something that common in SQL Server world or DB2 world.
-- Mladen Gogala Oracle DBA Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 18 2016 - 21:11:47 CET