oracle 12c 建立、開關、刪除____oracle

pdb測試：建立、開關、刪除

-----------------------

ORACLE12C中提出來CDB和PDB的概念
他們可以分別理解為容器和外掛程式(PDB插入在CDB中)
CDB的管理和傳統資料庫區別不大

--確認當前cdb
SQL> select name,cdb from v$database;

NAME      CDB
--------- ---
ZARADB    YES

--查詢當前pdb基本資料
col pdb_name for a30
select pdb_id,pdb_name,dbid,status,creation_scn from dba_pdbs;
select con_id,dbid,NAME,OPEN_MODE from v$pdbs;

    PDB_ID PDB_NAME                             DBID STATUS        CREATION_SCN
---------- ------------------------------ ---------- ------------- ------------
         3 PDB1                           3337485269 NORMAL             1909544
         2 PDB$SEED                       4072348290 NORMAL             1720741

SQL> 
    CON_ID       DBID NAME                           OPEN_MODE
---------- ---------- ------------------------------ ----------
         2 4072348290 PDB$SEED                       READ ONLY
         3 3337485269 PDB1                           READ WRITE

--建立pdb
--1直接建立
CREATE PLUGGABLE DATABASE pdb2
ADMIN USER pdb2dba IDENTIFIED BY anbaisheng
STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M)
DEFAULT TABLESPACE tbs_pdb2 DATAFILE '/opt/oracle/oradata/ZARADB/datafile/pdb2_001.dbf' SIZE 25M AUTOEXTEND ON;

--2以現有pdb為模板建立
--現有pdb必須在read only模式下才能被建立，否則報錯
--以pdb1為模板建立pdb2

drop pluggable database pdb2 including datafiles;
alter pluggable database pdb1 close;
alter pluggable database pdb1 open read only;

create pluggable database pdb2 
from pdb1 
file_name_convert =('/opt/oracle/oradata/ZARADB/E98BEB85B1A80C56E0439A02A8C05841/datafile/','/opt/oracle/oradata/ZARADB/datafile/pdb2');

--開啟關閉pdb
alter pluggable database pdb2 close;
alter pluggable database all close;
alter pluggable database pdb2 close immediate;

alter pluggable database pdb2 open;
alter pluggable database all open;

--刪除pdb
--與刪除資料表空間類似，可以串聯刪除資料檔案
drop pluggable database pdb2;
drop pluggable database pdb2 including datafiles;

--unplug
--unplug後pdb只能mount不能open
alter pluggable database pdb2 unplug into '/tmp/pdb2.xml';

--unplug後刪除pdb，再使用xml檔案加回pdb
drop pluggable database pdb2;
create pluggable database pdb2 using '/tmp/pdb2.xml' nocopy;