SQL> conn system/oracle@kfdb
已连接。
SQL>
--验证一下
SQL> show con_name
CON_NAME
------------------------------
KFPTDB
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
instance_name string racdb2
--当前连接到racdb2实例
--下面我们登陆到服务器racdb2实例,关闭该实例,或者关闭该实例上的kfptdb pdb,如果客户端的连接自动切换到racdb1实例,就算成功
--登陆racdb2实例
[oracle@rac2 ~]$ sqlplus /nolog
SQL*Plus: Release 12.2.0.1.0 Production on Sat Jul 8 11:43:12 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
SQL> conn / as sysdba
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 KFPTDB READ WRITE NO
SQL> alter pluggable database kfptdb close immediate;
--验证racdb2 上的kfptdb已经关闭
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 KFPTDB MOUNTED
SQL>
--racdb2上的kfptdb已经关闭
--回到客户端去看当前连接:
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
instance_name string racdb1
SQL>
--可以看到已经切换到racdb1机器上去了