01可插拔数据库创建，拔出，插回（详细版）

创建可插拔数据库
select name,open_mode from v$database;

select * from cdb_pdbs;









select * from cdb_pdbs;


拔出可插拔数据库






select * from cdb_pdbs;


插入可插拔数据库








select * from cdb_pdbs;


删除可插拔数据库






select * from cdb_pdbs;


select * from cdb_pdbs;

select * from cdb_pdbs;

CREATE PLUGGABLE DATABASE pdb2 ADMIN USER pdb_adm IDENTIFIED BY aabb123
FILE_NAME_CONVERT=(’/u01/app/oracle/oradata/cdb1/pdbseed/’,’/u01/app/oracle/oradata/cdb1/pdb2/’);



cd /u01/app/oracle/oradata/cdb1/


ALTER SESSION SET PDB_FILE_NAME_CONVERT=
‘/u01/app/oracle/oradata/cdb1/pdbseed/’,’/u01/app/oracle/oradata/cdb1/pdb3/’;
CREATE PLUGGABLE DATABASE pdb3 ADMIN USER pdb_adm IDENTIFIED BY aabb123;


select * from v$pdbs

ALTER PLUGGABLE DATABASE pdb2 OPEN READ WRITE;
ALTER PLUGGABLE DATABASE pdb3 OPEN READ WRITE;



手动克隆可插拔数据库
ALTER PLUGGABLE DATABASE pdb3 CLOSE;


ALTER PLUGGABLE DATABASE pdb3 OPEN READ ONLY;


CREATE PLUGGABLE DATABASE pdb4 FROM pdb3
FILE_NAME_CONVERT=(’/u01/app/oracle/oradata/cdb1/pdb3/’,
‘/u01/app/oracle/oradata/cdb1/pdb4/’);


ALTER PLUGGABLE DATABASE pdb4 OPEN READ WRITE;

ALTER PLUGGABLE DATABASE pdb3 CLOSE;
ALTER PLUGGABLE DATABASE pdb3 OPEN READ WRITE;

手动拔出可插拔数据库
ALTER PLUGGABLE DATABASE pdb2 CLOSE;
ALTER PLUGGABLE DATABASE pdb2 UNPLUG INTO ‘/u01/app/oracle/oradata/cdb1/pdb2/pdb2.xml’;



DROP PLUGGABLE DATABASE pdb2 KEEP DATAFILES;


手动插入可插拔数据库
SET SERVEROUTPUT ON
DECLARE
l_result BOOLEAN;
BEGIN
l_result := DBMS_PDB.check_plug_compatibility(
pdb_descr_file => ‘/u01/app/oracle/oradata/cdb1/pdb2/pdb2.xml’,
pdb_name => ‘pdb2’);

IF l_result THEN
DBMS_OUTPUT.PUT_LINE(‘compatible’);
ELSE
DBMS_OUTPUT.PUT_LINE(‘incompatible’);
END IF;
END;
/

CREATE PLUGGABLE DATABASE pdb5 USING ‘/u01/app/oracle/oradata/cdb1/pdb2/pdb2.xml’
FILE_NAME_CONVERT=(’/u01/app/oracle/oradata/cdb1/pdb2/’,
‘/u01/app/oracle/oradata/cdb1/pdb5/’);


select * from v$pdbs

ALTER PLUGGABLE DATABASE pdb5 OPEN READ WRITE;


删除PDB
ALTER PLUGGABLE DATABASE pdb5 CLOSE;


DROP PLUGGABLE DATABASE pdb5 INCLUDING DATAFILES;