这里简单介绍了拔出PDB,删除PDB,插入PDB的操作方法:
1、unplug PDB
查看PDB信息:
SQL> select name,open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
PDB_1 READ WRITE
PDB_2 READ WRITE
PDB_3 READ WRITE
PDB_4 READ WRITE
SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT
拔出PDB_4(必须连接到CDB$ROOT):
首先关闭PDB_4
SQL> alter pluggable database pdb_4 close immediate;
Pluggable database altered.
然后就可以unplug
SQL> alter pluggable database pdb_4 unplug into '/home/oracle/unplugged_pdbs/pdb_4.xml'