pdb測試：創(chuàng)建、開關(guān)、刪除

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

ORACLE12C中提出來CDB和PDB的概念

他們可以分別理解為容器和插件(PDB插入在CDB中)

CDB的管理和傳統(tǒng)數(shù)據(jù)庫區(qū)別不大

--確認當前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

--創(chuàng)建pdb

--1直接創(chuàng)建

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以現(xiàn)有pdb為模板創(chuàng)建

--現(xiàn)有pdb必須在read only模式下才能被創(chuàng)建，否則報錯

--以pdb1為模板創(chuàng)建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');

--打開關(guān)閉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

--與刪除表空間類似，可以級聯(lián)刪除數(shù)據(jù)文件

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;

總結(jié)

以上是生活随笔為你收集整理的oracle12c 删除pdb用户,oracle 12c pdb测试：创建、开关、删除的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。