12C 创建配置管理PDB

创建PDB如上篇所说，oui可以，dbca可以，当然手工也可以
另外dbca，还可以插、拔、删、配PDB，如图
[img]http://www.orasql.com/blog//uploadfiles/12c_78392.jpg[/img]
图形界面都非常简单，这里说下手工创建配置PDB的方法
1、手工创建PDB：
[code]sqlplus / as sysdba

CREATE PLUGGABLE DATABASE pdb2 ADMIN USER pdb_adm IDENTIFIED BY oracle

FILE_NAME_CONVERT=('/u01/app/oracle/oradata/cdb1/pdbseed/','/u01/app/oracle/oradata/cdb1/pdb2/');

SELECT pdb_name, status FROM dba_pdbs ORDER BY pdb_name;

SELECT name, open_mode FROM v$pdbs ORDER BY name;

ALTER PLUGGABLE DATABASE pdb2 OPEN[/code]

2、手工卸载PDB：
[code]ALTER PLUGGABLE DATABASE pdb2 CLOSE;

ALTER PLUGGABLE DATABASE pdb2 UNPLUG INTO '/u01/app/oracle/oradata/cdb1/pdb2/pdb2.xml';

SELECT name, open_mode FROM v$pdbs ORDER BY name;

DROP PLUGGABLE DATABASE pdb2 KEEP DATAFILES;

SELECT name, open_mode FROM v$pdbs ORDER BY name;[/code]
3、手工装载PDB：
[code]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;
/
compatible

PL/SQL procedure successfully completed.

SQL>

CREATE PLUGGABLE DATABASE pdb2 USING '/u01/app/oracle/oradata/cdb1/pdb2/pdb2.xml'
NOCOPY
TEMPFILE REUSE;

ALTER PLUGGABLE DATABASE pdb2 OPEN READ WRITE;

SELECT name, open_mode FROM v$pdbs ORDER BY name;[/code]

4、手工克隆PDB：
[code]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;

将源PDB还原到可读写状态
ALTER PLUGGABLE DATABASE pdb3 CLOSE;

ALTER PLUGGABLE DATABASE pdb3 OPEN READ WRITE;[/code]
5、手工删除PDB：
[code]ALTER PLUGGABLE DATABASE pdb2 CLOSE;
DROP PLUGGABLE DATABASE pdb2 KEEP DATAFILES;

ALTER PLUGGABLE DATABASE pdb3 CLOSE;
DROP PLUGGABLE DATABASE pdb3 INCLUDING DATAFILES;

ALTER PLUGGABLE DATABASE pdb4 CLOSE;
DROP PLUGGABLE DATABASE pdb4 INCLUDING DATAFILES;

SELECT name, open_mode FROM v$pdbs ORDER BY name;[/code]