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
CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBTEST READ WRITE NO
4 CLONEPDB READ WRITE NOSQL> show con_name
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> col open_mode format A20
SQL> set line 100
SQL> select con_id,name,guid,open_mode from v$containers;
CON_ID NAME GUID OPEN_MODE########## 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;
CON_ID NAME########## 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
CON_ID NAME########## 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，如需转载请自行联系原作者
