Drop Pdb

来源：互联网发布：初始化编程单元时出错编辑：程序博客网时间：2024/06/05 03:22

参考文档

https://docs.oracle.com/database/122/ADMIN/creating-and-removing-pdbs-with-sql-plus.htm#ADMIN13658

-- 之前练习clone pdb，创建了很多pdb，删除一些。

-- 注意事项

1 PDB 必须为mounted状态，或者unplugged状态

2 默认是keep datafiles，如果使用了参数keep datafiles.则pdb状态必须为unplugged。

-----

-- 查看各个pdb的状态，并drop

SYS@mynewdb>show con_nameCON_NAME------------------------------CDB$ROOTSYS@mynewdb>show pdbs    CON_ID CON_NAME  OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED  READ ONLY  NO 3 PDBS   MOUNTED 4 ORCL12CPDBNEW  MOUNTED 5 PDB2   MOUNTED 6 PDB_RELOCATE   READ WRITE YES 7 PDB4   MOUNTED 8 PDB3   MOUNTEDSYS@mynewdb>

-- drop pdb2 ，使用keep参数。则必须将pdb状态为unplugged。

drop pluggable database PDB2 keep datafile;SYS@mynewdb>drop pluggable database PDB2 keep datafiles;drop pluggable database PDB2 keep datafiles*ERROR at line 1:ORA-65179: cannot keep datafiles for a pluggable database that is not unpluggedALTER PLUGGABLE DATABASE PDB2 UNPLUG INTO '/home/oracle/PDB2.xml';SYS@mynewdb>ALTER PLUGGABLE DATABASE PDB2 UNPLUG INTO '/home/oracle/PDB2.xml';Pluggable database altered.SYS@mynewdb>drop pluggable database PDB2 keep datafiles;Pluggable database dropped.SYS@mynewdb>

-- 这个时候，查看pdb2的数据文件。数据文件是存在的。

-- drop其他的pdb

drop pluggable database PDB3 including datafiles;SYS@mynewdb>drop pluggable database PDB3 including datafiles;Pluggable database dropped.SYS@mynewdb>drop pluggable database PDB_RELOCATE including datafiles;drop pluggable database PDB_RELOCATE including datafiles*ERROR at line 1:ORA-65025: Pluggable database PDB_RELOCATE is not closed on all instances.SYS@mynewdb>alter pluggable database PDB_RELOCATE close;Pluggable database altered.SYS@mynewdb>drop pluggable database PDB_RELOCATE including datafiles;Pluggable database dropped.SYS@mynewdb>SYS@mynewdb>drop pluggable database ORCL12CPDBNEW including datafiles;Pluggable database dropped.

-- 产看pdb的数据文件，不存在了。

-- 查看剩余的pdb

SYS@mynewdb>show pdbs    CON_ID CON_NAME  OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED  READ ONLY  NO 3 PDBS   MOUNTEDSYS@mynewdb>

end

阅读全文

0 0