DECLARE
l_result BOOLEAN;
BEGIN
l_result := DBMS_PDB.check_plug_compatibility(
pdb_descr_file => '/u02/pdb/pdb3.xml',
pdb_name       => 'pdb3');
IF l_result THEN
DBMS_OUTPUT.PUT_LINE('compatible');
ELSE
DBMS_OUTPUT.PUT_LINE('incompatible');
END IF;
END;
/
1¡¢µ±Ç°¿âµÄ¿É°Î²å²âÊÔ
21:06:51 sys@stldb> alter pluggable database prod unplug into '/u02/pdb/prod.xml'; 

Pluggable database altered. 

Elapsed: 00:00:04.88 
21:07:48 sys@stldb> drop pluggable database prod; 

Pluggable database dropped. 

Elapsed: 00:00:04.46 
21:09:35 sys@stldb> select con_id, dbid, guid, name , open_mode from v$pdbs; 

CON_ID DBID GUID NAME OPEN_MODE 
------------- ------------- -------------------------------- ------------------------------ ---------- 
2 4117202806 117BCA51FD151564E0536506A8C0D708 PDB$SEED READ ONLY 
3 3382304421 117C1A2739A394A2E0536506A8C0E86A PDB1 READ WRITE 
4 3940876746 117C20359794C040E0536506A8C0B458 PDB2 READ WRITE 
6 3885367953 118F19327FCC760FE0536506A8C05BDF PDB4 READ ONLY 

Elapsed: 00:00:00.01 
21:09:50 sys@stldb> DECLARE 
21:12:41 2 l_result BOOLEAN; 
21:12:42 3 BEGIN 
21:12:42 4 l_result := DBMS_PDB.check_plug_compatibility( 
21:12:42 5 pdb_descr_file => '/u02/pdb/prod.xml', 
21:12:42 6 pdb_name => 'prod'); 
21:12:42 7 IF l_result THEN 
21:12:42 8 DBMS_OUTPUT.PUT_LINE('compatible'); 
21:12:42 9 ELSE 
21:12:42 10 DBMS_OUTPUT.PUT_LINE('incompatible'); 
21:12:42 11 END IF; 
21:12:42 12 END; 
21:12:42 13 / 
compatible 

PL/SQL procedure successfully completed. 

Elapsed: 00:00:00.10 
21:12:43 sys@stldb> create pluggable database prod using '/u02/pdb/prod.xml' nocopy tempfile reuse;

µ±È»£¬ÎÒÃÇÔÚÕâÒ»²½»¹ÊÇ¿ÉÒÔ½øÐиÄÃûµÄ²»Ò»¶¨Ê¹ÓÃÔ­À´µÄÃû×Ö

21:14:17 sys@stldb> alter session set container=prod; 

Session altered. 

Elapsed: 00:00:00.09 
21:14:37 sys@stldb> select name from v$datafile; 

NAME 
---------------------------------------------------------------------------------------------------------------------------------- 
+DATA/STLDB/DATAFILE/undotbs1.261.874613095 
+DATA/STLDB/118073E7A685F068E0536506A8C0A25E/DATAFILE/system.294.874633201 
+DATA/STLDB/118073E7A685F068E0536506A8C0A25E/DATAFILE/sysaux.293.874633187 
+DATA/STLDB/118073E7A685F068E0536506A8C0A25E/DATAFILE/users.296.874633293 
+DATA/STLDB/118073E7A685F068E0536506A8C0A25E/DATAFILE/kiwi.339.874702947 

Elapsed: 00:00:00.08 
21:14:45 sys@stldb> select name from v$tempfile; 

NAME 
---------------------------------------------------------------------------------------------------------------------------------- 
+DATA/STLDB/118073E7A685F068E0536506A8C0A25E/TEMPFILE/temp.295.874703627

2 ¿ç¿âµÄ¿É°Î²å²âÊÔ
21:48:28 sys@stldb> alter pluggable database pdb3 close; 

Pluggable database altered. 

Elapsed: 00:00:03.97 
21:48:53 sys@stldb> alter pluggable database pdb3 unplug into '/u02/pdb/pdb3.xml'; 

Pluggable database altered. 

Elapsed: 00:00:05.15 
21:49:34 sys@stldb> quit 
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, 
Advanced Analytics and Real Application Testing options 
[21:50:07 oracle(db)@rac1 ~]$ rman target / 

Recovery Manager: Release 12.1.0.1.0 - Production on Wed Mar 18 21:50:11 2015 

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