oracle 容器数据库的开关、切换

PostgreSQL_0

已于 2022-11-26 18:05:07 修改

阅读量669

点赞数

分类专栏： Oracle 文章标签：数据库 oracle sql

于 2022-11-26 18:01:22 首次发布

本文链接：https://blog.csdn.net/weixin_44089900/article/details/128054836

版权

Oracle 专栏收录该内容

43 篇文章 3 订阅

订阅专栏

查看是否是容器数据库

SQL> select name,cdb from v$database;

NAME      CDB
--------- ---
PROD      YES

查看pdb信息

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 PDB1                           MOUNTED
         4 PDB2                           MOUNTED
         5 PDB3                           MOUNTED

开关PDB库

--全部开关
alter pluggable database all open; 
alter pluggable database all close;
--某一个开关
alter pluggable database pdb3 open;
alter pluggable database pdb3 close;

--例子
SQL> alter pluggable database pdb3 close;
Pluggable database altered.

SQL> show pdbs;
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO
         5 PDB3                           MOUNTED

CDB/PDB切换

--CDB切到PDB
SQL> alter session set container = PDB1;
Session altered.

SQL> show pdbs;
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 PDB1                           READ WRITE NO


--PDB切到CDB
SQL> conn / as sysdba
Connected.

SQL> show pdbs;
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO
         5 PDB3                           MOUNTED