克隆PDB

1.使用SQL DEVELOPER

再修改状态启动两个数据库

2.使用命令克隆

C:\Users\Administrator>sqlplus sys/xxxxxx@newtest as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 14 13:47:47 2017

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

Connected to:

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

SQL> show pdbs

SQL> show con_name

CDB$ROOT

SQL> alter pluggable database pdbtest close immediate

2 ;

插接式数据库已变更。

SQL> alter pluggable database pdbtest open read only;

SQL> create pluggable database clonepdb2 from pdbtest;

create pluggable database clonepdb2 from pdbtest *

第 1 行出现错误:

ORA-65016: 必须指定 FILE_NAME_CONVERT

SQL> create pluggable database clonepdb2 from pdbtest

2 file_name_convert=

3 ('C:\app\Administrator\virtual\oradata\newtest\pdbtest','C:\app\Administrator\virtual\oradata\newtest\clonepdb2');

插接式数据库已创建。

SQL> alter pluggable database pdbtest close; 

SQL> alter pluggable database pdbtest open read write;

SQL> col con_id format A40

SQL> col open_mode format A20

SQL> col guid format A40

SQL> set line 100

SQL> select con_id,name,guid,open_mode from v$containers;

########## CDB$ROOT 728E7604E58A4D8D8F564226F3889876 READ WRITE

########## PDB$SEED 32CAC9A05E614355926257BE671D9AFC READ ONLY

########## PDBTEST 24549D14BBEB417BAB312BF19BC5259E READ WRITE

########## CLONEPDB D4B2FCAAC2B944CC8AF5864EC7CB853C READ WRITE

########## CLONEPDB2 9D7AE072804E47A297CBBC341D7F650E READ WRITE

SQL> select con_id,name from v$datafile;

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\SYSTEM01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\PDBSEED\SYSTEM01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\SYSAUX01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\PDBSEED\SYSAUX01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\UNDOTBS01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\PDBSEED\UNDOTBS01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\USERS01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\PDBTEST\SYSTEM01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\PDBTEST\SYSAUX01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\PDBTEST\UNDOTBS01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\PDBTEST\USERS01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\CLONEPDB\SYSTEM01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\CLONEPDB\SYSAUX01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\CLONEPDB\UNDOTBS01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\CLONEPDB\USERS01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\CLONEPDB2\SYSTEM01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\CLONEPDB2\SYSAUX01.DBF

########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\CLONEPDB2\UNDOTBS01.DBF ########## C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\NEWTEST\CLONEPDB2\USERS01.DBF

     本文转自whshurk 51CTO博客，原文链接：http://blog.51cto.com/shurk/2050534，如需转载请自行联系原作者