[oracle@oel62-ora12c-prm ~]$ export ORACLE_SID=prmcdb

[oracle@oel62-ora12c-prm ~]$ sqlplus / as  sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Mon Apr 14 09:51:44 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> alter pluggable database prmpdb02 close immediate;

Pluggable database altered.

SQL> alter pluggable database prmpdb02 open read only;

Pluggable database altered.

SQL> create pluggable database prmpdb03 from prmpdb02

  2  file_name_convert=('prmpdb02','prmpdb03');

Pluggable database created.

SQL> alter pluggable database all close;

Pluggable database altered.

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> select name, open_mode from v$pdbs;

NAME                           OPEN_MODE

------------------------------ ----------

PDB$SEED                       READ ONLY

PRMPDB01                       READ WRITE

PRMPDB02                       READ WRITE

PRMPDB03                       READ WRITE

[oracle@oel62-ora12c-dup ~]$ cd $ORACLE_BASE/oradata/dupcdb

[oracle@oel62-ora12c-dup dupcdb]$ mkdir prmpdb03

[oracle@oel62-ora12c-dup dupcdb]$ ls -l

total 16

drwxr-xr-x 2 oracle oinstall 4096 Apr 14 09:10 pdbseed

drwxr-xr-x 2 oracle oinstall 4096 Apr 14 09:10 prmpdb01

drwxr-xr-x 2 oracle oinstall 4096 Apr 14 09:10 prmpdb02

drwxr-xr-x 2 oracle oinstall 4096 Apr 14 09:46 prmpdb03

[oracle@oel62-ora12c-dup dupcdb]$

duplicate database to dupcdb pluggable database prmpdb01,prmpdb03 

  from active database 

  spfile 

parameter_value_convert='prmcdb','dupcdb' 

set db_file_name_convert='prmcdb','dupcdb'

set log_file_name_convert='prmcdb','dupcdb';

[oracle@oel62-ora12c-prm ~]$ rman

Recovery Manager: Release 12.1.0.1.0 - Production on Mon Apr 14 10:50:38 2014

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

RMAN> connect target "sys/*****@prmcdb as sysdba";

connected to target database: PRMCDB (DBID=2508276746)

RMAN> connect auxiliary "sys/******@dupcdb as sysdba";

connected to auxiliary database: DUPCDB (not mounted)

RMAN>duplicate database to dupcdb pluggable database prmpdb01,prmpdb03 

2>  from active database 

3>  spfile 

4>   parameter_value_convert='prmcdb','dupcdb' 

5>   set db_file_name_convert='prmcdb','dupcdb'

6>   set log_file_name_convert='prmcdb','dupcdb';

Starting Duplicate Db at 14-APR-14

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=21 device type=DISK

current log archived

contents of Memory Script:

{

   restore clone from service  'prmcdb' spfile to 

 '/u01/app/oracle/product/12.1.0/dbhome/dbs/spfiledupcdb.ora';

   sql clone "alter system set spfile= ''/u01/app/oracle/product/12.1.0/dbhome/dbs/spfiledupcdb.ora''";

}

executing Memory Script

Starting restore at 14-APR-14

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: restoring SPFILE

output file name=/u01/app/oracle/product/12.1.0/dbhome/dbs/spfiledupcdb.ora

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

Finished restore at 14-APR-14

sql statement: alter system set spfile= ''/u01/app/oracle/product/12.1.0/dbhome/dbs/spfiledupcdb.ora''

contents of Memory Script:

{

   sql clone "alter system set  db_name = 

 ''DUPCDB'' comment=

 ''duplicate'' scope=spfile";

   sql clone "alter system set  audit_file_dest = 

 ''/u01/app/oracle/admin/dupcdb/adump'' comment=

 '''' scope=spfile";

   sql clone "alter system set  control_files = 

 ''/u01/app/oracle/oradata/dupcdb/control01.ctl'', ''/u01/app/oracle/fra/dupcdb/control02.ctl'' 
comment='''' scope=spfile";

   sql clone "alter system set  dispatchers = 

 ''(PROTOCOL=TCP) (SERVICE=dupcdbXDB)'' comment=

 '''' scope=spfile";

   sql clone "alter system set  db_file_name_convert = 

 ''prmcdb'', ''dupcdb'' comment=

 '''' scope=spfile";

   sql clone "alter system set  log_file_name_convert = 

 ''prmcdb'', ''dupcdb'' comment=

 '''' scope=spfile";

   shutdown clone immediate;

   startup clone nomount;

}

executing Memory Script

sql statement: alter system set  db_name =  ''DUPCDB'' comment= ''duplicate'' scope=spfile

sql statement: alter system set  audit_file_dest =  ''/u01/app/oracle/admin/dupcdb/adump'' 
comment= '''' scope=spfile

sql statement: alter system set  control_files =  ''/u01/app/oracle/oradata/dupcdb/control01.ctl'', 
''/u01/app/oracle/fra/dupcdb/control02.ctl'' comment= '''' scope=spfile

sql statement: alter system set  dispatchers =  ''(PROTOCOL=TCP) (SERVICE=dupcdbXDB)'' comment= '''' scope=spfile

sql statement: alter system set  db_file_name_convert =  ''prmcdb'', ''dupcdb'' comment= '''' scope=spfile

sql statement: alter system set  log_file_name_convert =  ''prmcdb'', ''dupcdb'' comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area    1219260416 bytes

Fixed Size                     2287768 bytes

Variable Size                838862696 bytes

Database Buffers             369098752 bytes

Redo Buffers                   9011200 bytes

contents of Memory Script:

{

   sql clone "alter system set  db_name = 

 ''PRMCDB'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   sql clone "alter system set  db_unique_name = 

 ''DUPCDB'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   shutdown clone immediate;

   startup clone force nomount

   restore clone from service  'prmcdb' primary controlfile;

   alter clone database mount;

}

executing Memory Script

sql statement: alter system set  db_name =  ''PRMCDB'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''DUPCDB'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area    1219260416 bytes

Fixed Size                     2287768 bytes

Variable Size                838862696 bytes

Database Buffers             369098752 bytes

Redo Buffers                   9011200 bytes

Starting restore at 14-APR-14

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=19 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: restoring control file

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07

output file name=/u01/app/oracle/oradata/dupcdb/control01.ctl

output file name=/u01/app/oracle/fra/dupcdb/control02.ctl

Finished restore at 14-APR-14

database mounted

Skipping pluggable database PRMPDB02

Automatically adding tablespace SYSTEM

Automatically adding tablespace SYSAUX

Automatically adding tablespace PDB$SEED:SYSTEM

Automatically adding tablespace PDB$SEED:SYSAUX

Automatically adding tablespace UNDOTBS1

Skipping tablespace USERS

contents of Memory Script:

{

   set newname for datafile  1 to 

 "/u01/app/oracle/oradata/dupcdb/system01.dbf";

   set newname for datafile  3 to 

 "/u01/app/oracle/oradata/dupcdb/sysaux01.dbf";

   set newname for datafile  4 to 

 "/u01/app/oracle/oradata/dupcdb/undotbs01.dbf";

   set newname for datafile  5 to 

 "/u01/app/oracle/oradata/dupcdb/pdbseed/system01.dbf";

   set newname for datafile  7 to 

 "/u01/app/oracle/oradata/dupcdb/pdbseed/sysaux01.dbf";

   set newname for datafile  8 to 

 "/u01/app/oracle/oradata/dupcdb/prmpdb01/system01.dbf";

   set newname for datafile  9 to 

 "/u01/app/oracle/oradata/dupcdb/prmpdb01/sysaux01.dbf";

   set newname for datafile  10 to 

 "/u01/app/oracle/oradata/dupcdb/prmpdb01/prmpdb01_users01.dbf";

   set newname for datafile  31 to 

 "/u01/app/oracle/oradata/dupcdb/prmpdb03/system01.dbf";

   set newname for datafile  32 to 

 "/u01/app/oracle/oradata/dupcdb/prmpdb03/sysaux01.dbf";

   set newname for datafile  33 to 

 "/u01/app/oracle/oradata/dupcdb/prmpdb03/prmpdb03_users01.dbf";

   restore

   from service  'prmcdb'   clone database

   skip forever tablespace  "USERS",

 "PRMPDB02":"USERS",

 "PRMPDB02":"SYSTEM",

 "PRMPDB02":"SYSAUX"   ;

   sql 'alter system archive log current';

}

executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 14-APR-14

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/dupcdb/system01.dbf

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:35

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/dupcdb/sysaux01.dbf

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:35

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/dupcdb/undotbs01.dbf

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/dupcdb/pdbseed/system01.dbf

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/dupcdb/pdbseed/sysaux01.dbf

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:05

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/dupcdb/prmpdb01/system01.dbf

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/dupcdb/prmpdb01/sysaux01.dbf

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:05

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/dupcdb/prmpdb01/prmpdb01_users01.dbf

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00031 to /u01/app/oracle/oradata/dupcdb/prmpdb03/system01.dbf

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00032 to /u01/app/oracle/oradata/dupcdb/prmpdb03/sysaux01.dbf

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:05

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00033 to /u01/app/oracle/oradata/dupcdb/prmpdb03/prmpdb03_users01.dbf

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

Finished restore at 14-APR-14

sql statement: alter system archive log current

current log archived

contents of Memory Script:

{

   restore clone force from service  'prmcdb' 

           archivelog from scn  4859442;

   switch clone datafile all;

}

executing Memory Script

Starting restore at 14-APR-14

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting archived log restore to default destination

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=87

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:04

channel ORA_AUX_DISK_1: starting archived log restore to default destination

channel ORA_AUX_DISK_1: using network backup set from service prmcdb

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=88

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03

Finished restore at 14-APR-14

datafile 1 switched to datafile copy

input datafile copy RECID=14 STAMP=844855543 file name=/u01/app/oracle/oradata/dupcdb/system01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=15 STAMP=844855544 file name=/u01/app/oracle/oradata/dupcdb/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=16 STAMP=844855545 file name=/u01/app/oracle/oradata/dupcdb/undotbs01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=17 STAMP=844855546 file name=/u01/app/oracle/oradata/dupcdb/pdbseed/system01.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=18 STAMP=844855547 file name=/u01/app/oracle/oradata/dupcdb/pdbseed/sysaux01.dbf

datafile 8 switched to datafile copy

input datafile copy RECID=19 STAMP=844855548 file name=/u01/app/oracle/oradata/dupcdb/prmpdb01/system01.dbf

datafile 9 switched to datafile copy

input datafile copy RECID=20 STAMP=844855549 file name=/u01/app/oracle/oradata/dupcdb/prmpdb01/sysaux01.dbf

datafile 10 switched to datafile copy

input datafile copy RECID=21 STAMP=844855550 file name=/u01/app/oracle/oradata/dupcdb/prmpdb01/prmpdb01_users01.dbf

datafile 31 switched to datafile copy

input datafile copy RECID=22 STAMP=844855551 file name=/u01/app/oracle/oradata/dupcdb/prmpdb03/system01.dbf

datafile 32 switched to datafile copy

input datafile copy RECID=23 STAMP=844855551 file name=/u01/app/oracle/oradata/dupcdb/prmpdb03/sysaux01.dbf

datafile 33 switched to datafile copy

input datafile copy RECID=24 STAMP=844855553 file name=/u01/app/oracle/oradata/dupcdb/prmpdb03/prmpdb03_users01.dbf

contents of Memory Script:

{

   set until scn  4860625;

   recover

   clone database

   skip forever tablespace  "USERS",

 "PRMPDB02":"USERS",

 "PRMPDB02":"SYSTEM",

 "PRMPDB02":"SYSAUX"    delete archivelog

   ;

}

executing Memory Script

executing command: SET until clause

Starting recover at 14-APR-14

using channel ORA_AUX_DISK_1

Executing: alter database datafile 6 offline drop

Executing: alter database datafile 30 offline drop

Executing: alter database datafile 28 offline drop

Executing: alter database datafile 29 offline drop

starting media recovery

archived log for thread 1 with sequence 87 is already on disk as file 
/u01/app/oracle/fra/DUPCDB/archivelog/2014_04_14/o1_mf_1_87_9npv50f0_.arc

archived log for thread 1 with sequence 88 is already on disk as file 
/u01/app/oracle/fra/DUPCDB/archivelog/2014_04_14/o1_mf_1_88_9npv54k3_.arc

archived log file 
name=/u01/app/oracle/fra/DUPCDB/archivelog/2014_04_14/o1_mf_1_87_9npv50f0_.arc thread=1 sequence=87

archived log file 
name=/u01/app/oracle/fra/DUPCDB/archivelog/2014_04_14/o1_mf_1_88_9npv54k3_.arc thread=1 sequence=88

media recovery complete, elapsed time: 00:00:24

Finished recover at 14-APR-14

Oracle instance started

Total System Global Area    1219260416 bytes

Fixed Size                     2287768 bytes

Variable Size                838862696 bytes

Database Buffers             369098752 bytes

Redo Buffers                   9011200 bytes

contents of Memory Script:

{

   sql clone "alter system set  db_name = 

 ''DUPCDB'' comment=

 ''Reset to original value by RMAN'' scope=spfile";

   sql clone "alter system reset  db_unique_name scope=spfile";

}

executing Memory Script

sql statement: alter system set  db_name =  ''DUPCDB'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile

Oracle instance started

Total System Global Area    1219260416 bytes

Fixed Size                     2287768 bytes

Variable Size                838862696 bytes

Database Buffers             369098752 bytes

Redo Buffers                   9011200 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUPCDB" RESETLOGS ARCHIVELOG 

  MAXLOGFILES     16

  MAXLOGMEMBERS      3

  MAXDATAFILES     1024

  MAXINSTANCES     8

  MAXLOGHISTORY      292

 LOGFILE

  GROUP   1 ( '/u01/app/oracle/oradata/dupcdb/redo01.log' ) SIZE 50 M  REUSE,

  GROUP   2 ( '/u01/app/oracle/oradata/dupcdb/redo02.log' ) SIZE 50 M  REUSE,

  GROUP   3 ( '/u01/app/oracle/oradata/dupcdb/redo03.log' ) SIZE 50 M  REUSE

 DATAFILE

  '/u01/app/oracle/oradata/dupcdb/system01.dbf',

  '/u01/app/oracle/oradata/dupcdb/pdbseed/system01.dbf',

  '/u01/app/oracle/oradata/dupcdb/prmpdb01/system01.dbf',

  '/u01/app/oracle/oradata/dupcdb/prmpdb03/system01.dbf'

 CHARACTER SET AL32UTF8

contents of Memory Script:

{

   set newname for tempfile  1 to 

 "/u01/app/oracle/oradata/dupcdb/temp01.dbf";

   set newname for tempfile  2 to 

 "/u01/app/oracle/oradata/dupcdb/pdbseed/pdbseed_temp01.dbf";

   set newname for tempfile  3 to 

 "/u01/app/oracle/oradata/dupcdb/prmpdb01/temp01.dbf";

   set newname for tempfile  5 to 

 "/u01/app/oracle/oradata/dupcdb/prmpdb03/temp01.dbf";

   switch clone tempfile all;

   catalog clone datafilecopy  "/u01/app/oracle/oradata/dupcdb/sysaux01.dbf", 

 "/u01/app/oracle/oradata/dupcdb/undotbs01.dbf", 

 "/u01/app/oracle/oradata/dupcdb/pdbseed/sysaux01.dbf", 

 "/u01/app/oracle/oradata/dupcdb/prmpdb01/sysaux01.dbf", 

 "/u01/app/oracle/oradata/dupcdb/prmpdb01/prmpdb01_users01.dbf", 

 "/u01/app/oracle/oradata/dupcdb/prmpdb03/sysaux01.dbf", 

 "/u01/app/oracle/oradata/dupcdb/prmpdb03/prmpdb03_users01.dbf";

   switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/dupcdb/temp01.dbf in control file

renamed tempfile 2 to /u01/app/oracle/oradata/dupcdb/pdbseed/pdbseed_temp01.dbf in control file

renamed tempfile 3 to /u01/app/oracle/oradata/dupcdb/prmpdb01/temp01.dbf in control file

renamed tempfile 5 to /u01/app/oracle/oradata/dupcdb/prmpdb03/temp01.dbf in control file

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/dupcdb/sysaux01.dbf RECID=1 STAMP=844855604

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/dupcdb/undotbs01.dbf RECID=2 STAMP=844855604

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/dupcdb/pdbseed/sysaux01.dbf RECID=3 STAMP=844855605

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/dupcdb/prmpdb01/sysaux01.dbf RECID=4 STAMP=844855605

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/dupcdb/prmpdb01/prmpdb01_users01.dbf RECID=5 STAMP=844855606

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/dupcdb/prmpdb03/sysaux01.dbf RECID=6 STAMP=844855606

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/dupcdb/prmpdb03/prmpdb03_users01.dbf RECID=7 STAMP=844855606

datafile 3 switched to datafile copy

input datafile copy RECID=1 STAMP=844855604 file name=/u01/app/oracle/oradata/dupcdb/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=2 STAMP=844855604 file name=/u01/app/oracle/oradata/dupcdb/undotbs01.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=3 STAMP=844855605 file name=/u01/app/oracle/oradata/dupcdb/pdbseed/sysaux01.dbf

datafile 9 switched to datafile copy

input datafile copy RECID=4 STAMP=844855605 file name=/u01/app/oracle/oradata/dupcdb/prmpdb01/sysaux01.dbf

datafile 10 switched to datafile copy

input datafile copy RECID=5 STAMP=844855606 file name=/u01/app/oracle/oradata/dupcdb/prmpdb01/prmpdb01_users01.dbf

datafile 32 switched to datafile copy

input datafile copy RECID=6 STAMP=844855606 file name=/u01/app/oracle/oradata/dupcdb/prmpdb03/sysaux01.dbf

datafile 33 switched to datafile copy

input datafile copy RECID=7 STAMP=844855606 file name=/u01/app/oracle/oradata/dupcdb/prmpdb03/prmpdb03_users01.dbf

contents of Memory Script:

{

   Alter clone database open resetlogs;

}

executing Memory Script

database opened

Executing: drop pluggable database "PRMPDB02"

contents of Memory Script:

{

   sql clone "alter pluggable database all open";

}

executing Memory Script

sql statement: alter pluggable database all open

Dropping offline and skipped tablespaces

Executing: alter database default tablespace system

Executing: drop tablespace "USERS" including contents cascade constraints

Finished Duplicate Db at 14-APR-14

Recovery Manager complete. 

Nos podemos conferir o duplicado PDB no duplicado banco de dados:

[oracle@oel62-ora12c-dup ~]$ export ORACLE_SID=dupcdb

[oracle@oel62-ora12c-dup ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Mon Apr 14 10:22:26 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name, open_mode from v$pdbs;

NAME                           OPEN_MODE

------------------------------ ----------

PDB$SEED                       READ ONLY

PRMPDB01                       READ WRITE

PRMPDB03                       READ WRITE

Esperamos que este artigo tenha sido útil para você. Convidamos a ler a próxima parte desta série de artigos:

Caso 7: Duplicando PDBs - Duplicando database ativo com método Pull-Based de dois Pluggable Databases com skip de um PDB

---

Joel Pérez é um DBA Especialista (Oracle ACE Director, OCM Cloud Admin. & OCM11g ). Com mais de 14 anos de experiência do mundo Oracle Technology, especializado em arquitetura e implementação de soluções como: Cloud, Alta disponibilidade, Disaster/Recovery, Upgrades, replicação e todos as áreas relacionadas com bancos de dados Oracle. Consultor internacional com deveres, conferências e atividades em mais de 50 países e inúmeros clientes em todo o mundo. Palestrante regular nos eventos Oracle em todo o mundo como: OTN LAD, OTN MENA, OTN APAC e muito mais. Joel sempre foi conhecido por ser pioneiro em tecnologia Oracle desde os primeiros dias de sua carreira sendo o primeiro latino-americano premiado como "OTN Expert" no ano de 2003 pela Oracle Corporation, um dos primeiros "ACE Oracle" no Oracle ACE Program no ano de 2004, um dos primeiros OCP Database Cloud Administrator em todo o mundo no ano de 2013 e como um das maiores realizações profissionais em sua carreira, recentemente ele foi homenageado como o primeiro "OCM Database Cloud Administrator" do mundo.

Mahir M. Quluzade é um DBA Sênior com mais de 10 anos de experiência em banco de dados Oracle com foco principal na alta disponibilidade e soluções de recuperação de desastres (RAC, Data Guard, RMAN, ...). Mahir está atualmente trabalhando no Banco Central da República do Azerbaijão. Ele é um DBA OCP. Mahir é membro fundador do Azerbaijão a Oracle User Group (AZEROUG); também é um blogger. Siga Mahir em seu blog.

Flávio Soares é um Oracle DBA Sênior, Exadata DMA, Troubleshooter e Consultor Oracle, certificado em OCP/OCE RAC. Especialista em Exadata, alta disponibilidade e replicação de dados com soluções Oracle. Flávio disponibiliza frequentes informações para a comunidade Oracle através do seu blog.

Este artigo foi revisto pela equipe de produtos Oracle e está em conformidade com as normas e práticas para o uso de produtos Oracle.