Pluggable database duplication

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 18 Feb 2016 11:15:32 -0500

I know that I can unplug the pluggable database and plug it back into the same CDB or another CDB, but I cannot duplicate it:

   [oracle@rac1 ~]$ rman target sys/qwerty@ora12c-1:1521/rcat.home.com
   auxiliary /

   Recovery Manager: Release 12.1.0.2.0 - Production on Thu Feb 18
   10:44:08 2016

   Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights
   reserved.

   connected to target database: ORCL (DBID=1407298449)
   connected to auxiliary database: ORCL (DBID=1424599749)

   RMAN> duplicate target database to orcl pluggable database rcat from
   active database;

   Starting Duplicate Db at 18-FEB-16
   RMAN-00571: ===========================================================
   RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
   RMAN-00571: ===========================================================
   RMAN-03002: failure of Duplicate Db command at 02/18/2016 10:44:49
   RMAN-05501: aborting duplication of target database
   RMAN-07536: command not allowed when connected to a Pluggable Database


The difference between unplugging and plugging back into another CDB and duplicating is drastic. Duplication can be done without downtime, while unplugging cannot. The first step of unplugging the database reads:
Do "alter pluggable database <pdb name> close immediate;
That is downtime. Are there any plans to allow "duplicate database", while connected to a pluggable database?
Regards


--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217

Other related posts: