• ORACLE在系统级别修改PDB

    可以使用ALTER SYSTEM命令动态修改PDB，如果当前容器是PDB，那么可以执行以下命令。

    1. ALTER SYSTEM FLUSH { SHARED_POOL | BUFFER_CACHE | FLASH_CACHE };
    2.  
    3. ALTER SYSTEM {ENABLE | DISABLE} RESTRICTED SESSION;
    4.  
    5. ALTER SYSTEM SET USE_STORED_OUTLINES;
    6.  
    7. ALTER SYSTEM {SUSPEND | RESUME};
    8.  
    9. ALTER SYSTEM CHECKPOINT;
    10.  
    11. ALTER SYSTEM CHECK DATAFILES;
    12.  
    13. ALTER SYSTEM REGISTER;
    14.  
    15. ALTER SYSTEM {KILL | DISCONNECT} SESSION;
    16.  
    17. ALTER SYSTEM SET 初始化参数

     对于修改的初始化参数，若表v$system_parameter中的字段ISPDB_MODIFIABLE='TRUE'，说明在PDB级别可以修改，并不会影响CDB的参数值。

    1. SQL> desc v$system_parameter;
    2.  Name                                      Null?    Type
    3.  ----------------------------------------- -------- ----------------------------
    4.  NUM                                                NUMBER
    5.  NAME                                               VARCHAR2(80)
    6.  TYPE                                               NUMBER
    7.  VALUE                                              VARCHAR2(4000)
    8.  DISPLAY_VALUE                                      VARCHAR2(4000)
    9.  DEFAULT_VALUE                                      VARCHAR2(255)
    10.  ISDEFAULT                                          VARCHAR2(9)
    11.  ISSES_MODIFIABLE                                   VARCHAR2(5)
    12.  ISSYS_MODIFIABLE                                   VARCHAR2(9)
    13.  ISPDB_MODIFIABLE                                   VARCHAR2(5)
    14.  ISINSTANCE_MODIFIABLE                              VARCHAR2(5)
    15.  ISMODIFIED                                         VARCHAR2(8)
    16.  ISADJUSTED                                         VARCHAR2(5)
    17.  ISDEPRECATED                                       VARCHAR2(5)
    18.  ISBASIC                                            VARCHAR2(5)
    19.  DESCRIPTION                                        VARCHAR2(255)
    20.  UPDATE_COMMENT                                     VARCHAR2(255)
    21.  HASH                                               NUMBER
    22.  CON_ID                                             NUMBER
    23.  
    24. SQL> select count(*) from v$system_parameter where ISPDB_MODIFIABLE='TRUE';
    25.  
    26.   COUNT(*)
    27. ----------
    28.        222
    29.  
    30. SQL> show user;
    31. USER is "SYS"
    32. SQL>

    在数据库级别修改PDB

    在数据库基本修改PDB，主要是使用ALTER PLUGGABLE DATABASE 命令。

    1. [oracle@oracle-db-19c ~]$ sqlplus / as sysdba
    2.  
    3. SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 30 21:13:10 2022
    4. Version 19.3.0.0.0
    5.  
    6. Copyright (c) 1982, 2019, Oracle.  All rights reserved.
    7.  
    8.  
    9. Connected to:
    10. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    11. Version 19.3.0.0.0
    12.  
    13. SQL> show con_name;
    14.  
    15. CON_NAME
    16. ------------------------------
    17. CDB$ROOT
    18. SQL> show pdbs;
    19.  
    20.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    21. ---------- ------------------------------ ---------- ----------
    22.          2 PDB$SEED                       READ ONLY  NO
    23.          3 PDB1                           READ WRITE NO
    24.          4 PDB2                           MOUNTED
    25.          5 CNDBAPDB                       MOUNTED
    26.          6 CNDBAPDB3                      MOUNTED
    27.          7 CNDBAPDB2                      MOUNTED
    28.          8 CNDBAPDB4_FRESH                MOUNTED
    29. SQL> alter pluggable database cndbapdb2 open;
    30.  
    31. Pluggable database altered.
    32.  
    33. SQL> 
    34. SQL> show pdbs;
    35.  
    36.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    37. ---------- ------------------------------ ---------- ----------
    38.          2 PDB$SEED                       READ ONLY  NO
    39.          3 PDB1                           READ WRITE NO
    40.          4 PDB2                           MOUNTED
    41.          5 CNDBAPDB                       MOUNTED
    42.          6 CNDBAPDB3                      MOUNTED
    43.          7 CNDBAPDB2                      READ WRITE NO
    44.          8 CNDBAPDB4_FRESH                MOUNTED
    45. SQL> alter pluggable database cndbapdb2 close immediate;
    46.  
    47. Pluggable database altered.
    48.  
    49. SQL> alter pluggable database cndbapdb2 open read only;
    50.  
    51. Pluggable database altered.
    52.  
    53. SQL>

    在线查看数据库文件，代码如下：

    1. SQL> show user;
    2. USER is "SYS"
    3. SQL> show con_name;
    4.  
    5. CON_NAME
    6. ------------------------------
    7. CDB$ROOT
    8. SQL> alter session set container=CNDBAPDB2
    9.   2  ;
    10.  
    11. Session altered.
    12.  
    13. SQL> alter session set container=CNDBAPDB2;
    14.  
    15. Session altered.
    16.  
    17. SQL> alter pluggable database datafile '/u02/oradata/CDB1/cndbapdb2/cndba01.dbf' online;
    18.  
    19. Pluggable database altered.
    20.  
    21. SQL> show pdbs;
    22.  
    23.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    24. ---------- ------------------------------ ---------- ----------
    25.          7 CNDBAPDB2                      READ WRITE NO
    26. SQL> select name from v$datafile;
    27.  
    28. NAME
    29. --------------------------------------------------------------------------------
    30. /u02/oradata/CDB1/cndbapdb2/system01.dbf
    31. /u02/oradata/CDB1/cndbapdb2/sysaux01.dbf
    32. /u02/oradata/CDB1/cndbapdb2/undotbs01.dbf
    33. /u02/oradata/CDB1/cndbapdb2/cndba01.dbf
    34.  
    35. SQL>

    修改默认表空间，代码如下：

    1. ALTER PLUGGABLE DATABASE DEFAULT TABLESPACE cndba_tbs;
    2.  
    3. ALTER PLUGGABLE DATABASE DEFAULT TEMPORARY TABLESPACE cndba_temp;

    设置PDB的存储大小，代码如下：

    1. ALTER PLUGGABLE DATABASE STORAGE (MAXSIZE 20G);
    2.  
    3. ALTER PLUGGABLE DATABASE STORAGE (MAXSIZE UNLIMITED);
    4.  
    5. ALTER PLUGGABLE DATABASE STORAGE UNLIMITED;
    6.

    设置强制记录日志，代码如下：

    1. ALTER PLUGGABLE DATABASE NOLOGGING;
    2.  
    3. ALTER PLUGGABLE DATABASE ENABLE FORCE LOGGING;
    4.

    启动/关闭PDB

    打开模式：

    • OPEN READ WRITE

    读写模式，允许用户进行读写操作

    • OPEN READ ONLY

    只读模式，只允许用户读取数据，无法写数据

    • OPEN MIGRATE

    当前模式，可以执行升级脚本操作（ALTER DATABASE OPEN UPGRADE）

    • MOUNT

    不允许进行任何修改操作，只允许数据库管理员访问，无法读取/修改数据文件。此时内存中关于PDB的信息会被移除，可以进行冷备份。

    打开PDB

    OPEN READ WRITE

    1. SQL> show user;
    2. USER is "SYS"
    3. SQL> show con_name;
    4.  
    5. CON_NAME
    6. ------------------------------
    7. CDB$ROOT
    8. SQL> show pdbs;
    9.  
    10.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    11. ---------- ------------------------------ ---------- ----------
    12.          2 PDB$SEED                       READ ONLY  NO
    13.          3 PDB1                           READ WRITE NO
    14.          4 PDB2                           MOUNTED
    15.          5 CNDBAPDB                       MOUNTED
    16.          6 CNDBAPDB3                      MOUNTED
    17.          7 CNDBAPDB2                      MOUNTED
    18.          8 CNDBAPDB4_FRESH                MOUNTED
    19. SQL> STARTUP PLUGGABLE DATABASE CNDBAPDB2 OPEN READ WRITE;
    20. Pluggable Database opened.
    21. SQL> show pdbs;
    22.  
    23.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    24. ---------- ------------------------------ ---------- ----------
    25.          2 PDB$SEED                       READ ONLY  NO
    26.          3 PDB1                           READ WRITE NO
    27.          4 PDB2                           MOUNTED
    28.          5 CNDBAPDB                       MOUNTED
    29.          6 CNDBAPDB3                      MOUNTED
    30.          7 CNDBAPDB2                      READ WRITE NO
    31.          8 CNDBAPDB4_FRESH                MOUNTED
    32. SQL> alter pluggable database cndbapdb2 close immediate;
    33.  
    34. Pluggable database altered.
    35.  
    36. SQL> show pdbs;
    37.  
    38.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    39. ---------- ------------------------------ ---------- ----------
    40.          2 PDB$SEED                       READ ONLY  NO
    41.          3 PDB1                           READ WRITE NO
    42.          4 PDB2                           MOUNTED
    43.          5 CNDBAPDB                       MOUNTED
    44.          6 CNDBAPDB3                      MOUNTED
    45.          7 CNDBAPDB2                      MOUNTED
    46.          8 CNDBAPDB4_FRESH                MOUNTED
    47. SQL> alter pluggable database cndbapdb2 open read write;
    48.  
    49. Pluggable database altered.
    50.  
    51. SQL> show pdbs;
    52.  
    53.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    54. ---------- ------------------------------ ---------- ----------
    55.          2 PDB$SEED                       READ ONLY  NO
    56.          3 PDB1                           READ WRITE NO
    57.          4 PDB2                           MOUNTED
    58.          5 CNDBAPDB                       MOUNTED
    59.          6 CNDBAPDB3                      MOUNTED
    60.          7 CNDBAPDB2                      READ WRITE NO
    61.          8 CNDBAPDB4_FRESH                MOUNTED
    62. SQL> alter pluggable database cndbapdb2 close immediate;
    63.  
    64. Pluggable database altered.
    65.  
    66. SQL> show pdbs;
    67.  
    68.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    69. ---------- ------------------------------ ---------- ----------
    70.          2 PDB$SEED                       READ ONLY  NO
    71.          3 PDB1                           READ WRITE NO
    72.          4 PDB2                           MOUNTED
    73.          5 CNDBAPDB                       MOUNTED
    74.          6 CNDBAPDB3                      MOUNTED
    75.          7 CNDBAPDB2                      MOUNTED
    76.          8 CNDBAPDB4_FRESH                MOUNTED
    77. SQL> alter pluggable database cndbapdb2 open;
    78.  
    79. Pluggable database altered.
    80.  
    81. SQL> show pdbs;
    82.  
    83.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    84. ---------- ------------------------------ ---------- ----------
    85.          2 PDB$SEED                       READ ONLY  NO
    86.          3 PDB1                           READ WRITE NO
    87.          4 PDB2                           MOUNTED
    88.          5 CNDBAPDB                       MOUNTED
    89.          6 CNDBAPDB3                      MOUNTED
    90.          7 CNDBAPDB2                      READ WRITE NO
    91.          8 CNDBAPDB4_FRESH                MOUNTED
    92. SQL> alter pluggable database cndbapdb2 close immediate;
    93.  
    94. Pluggable database altered.
    95.  
    96. SQL> show pdbs;
    97.  
    98.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    99. ---------- ------------------------------ ---------- ----------
    100.          2 PDB$SEED                       READ ONLY  NO
    101.          3 PDB1                           READ WRITE NO
    102.          4 PDB2                           MOUNTED
    103.          5 CNDBAPDB                       MOUNTED
    104.          6 CNDBAPDB3                      MOUNTED
    105.          7 CNDBAPDB2                      MOUNTED
    106.          8 CNDBAPDB4_FRESH                MOUNTED
    107. SQL>

    OPEN READ ONLY

    1. SQL> 
    2. SQL> alter pluggable database cndbapdb2 open READ ONLY;
    3.  
    4. Pluggable database altered.
    5.  
    6. SQL> show pdbs;
    7.  
    8.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    9. ---------- ------------------------------ ---------- ----------
    10.          2 PDB$SEED                       READ ONLY  NO
    11.          3 PDB1                           READ WRITE NO
    12.          4 PDB2                           MOUNTED
    13.          5 CNDBAPDB                       MOUNTED
    14.          6 CNDBAPDB3                      MOUNTED
    15.          7 CNDBAPDB2                      READ ONLY  NO
    16.          8 CNDBAPDB4_FRESH                MOUNTED
    17. SQL> alter pluggable database cndbapdb2 close immediate;
    18.  
    19. Pluggable database altered.
    20.  
    21. SQL> show pdbs;
    22.  
    23.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    24. ---------- ------------------------------ ---------- ----------
    25.          2 PDB$SEED                       READ ONLY  NO
    26.          3 PDB1                           READ WRITE NO
    27.          4 PDB2                           MOUNTED
    28.          5 CNDBAPDB                       MOUNTED
    29.          6 CNDBAPDB3                      MOUNTED
    30.          7 CNDBAPDB2                      MOUNTED
    31.          8 CNDBAPDB4_FRESH                MOUNTED
    32. SQL> STARTUP PLUGGABLE DATABASE CNDBAPDB2 OPEN READ ONLY;
    33. Pluggable Database opened.
    34. SQL> show pdbs;
    35.  
    36.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    37. ---------- ------------------------------ ---------- ----------
    38.          2 PDB$SEED                       READ ONLY  NO
    39.          3 PDB1                           READ WRITE NO
    40.          4 PDB2                           MOUNTED
    41.          5 CNDBAPDB                       MOUNTED
    42.          6 CNDBAPDB3                      MOUNTED
    43.          7 CNDBAPDB2                      READ ONLY  NO
    44.          8 CNDBAPDB4_FRESH                MOUNTED
    45. SQL> alter pluggable database cndbapdb2 close immediate;
    46.  
    47. Pluggable database altered.
    48.  
    49. SQL> show pdbs;
    50.  
    51.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    52. ---------- ------------------------------ ---------- ----------
    53.          2 PDB$SEED                       READ ONLY  NO
    54.          3 PDB1                           READ WRITE NO
    55.          4 PDB2                           MOUNTED
    56.          5 CNDBAPDB                       MOUNTED
    57.          6 CNDBAPDB3                      MOUNTED
    58.          7 CNDBAPDB2                      MOUNTED
    59.          8 CNDBAPDB4_FRESH                MOUNTED
    60. SQL>

    OPEN MIGRATE(以升级脚本的模式打开)

    1. [oracle@oracle-db-19c ~]$ sqlplus / as sysdba
    2.  
    3. SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 30 21:49:44 2022
    4. Version 19.3.0.0.0
    5.  
    6. Copyright (c) 1982, 2019, Oracle.  All rights reserved.
    7.  
    8.  
    9. Connected to:
    10. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    11. Version 19.3.0.0.0
    12.  
    13. SQL> show pdbs;
    14.  
    15.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    16. ---------- ------------------------------ ---------- ----------
    17.          2 PDB$SEED                       READ ONLY  NO
    18.          3 PDB1                           READ WRITE NO
    19.          4 PDB2                           MOUNTED
    20.          5 CNDBAPDB                       MOUNTED
    21.          6 CNDBAPDB3                      MOUNTED
    22.          7 CNDBAPDB2                      MOUNTED
    23.          8 CNDBAPDB4_FRESH                MOUNTED
    24. SQL> 
    25. SQL> 
    26. SQL> ALTER PLUGGABLE DATABASE cndbapdb OPEN UPGRADE;
    27.  
    28. Pluggable database altered.
    29.  
    30. SQL> show pdbs;
    31.  
    32.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    33. ---------- ------------------------------ ---------- ----------
    34.          2 PDB$SEED                       READ ONLY  NO
    35.          3 PDB1                           READ WRITE NO
    36.          4 PDB2                           MOUNTED
    37.          5 CNDBAPDB                       MIGRATE    YES
    38.          6 CNDBAPDB3                      MOUNTED
    39.          7 CNDBAPDB2                      MOUNTED
    40.          8 CNDBAPDB4_FRESH                MOUNTED
    41. SQL> 
    42. SQL> alter pluggable database cndbapdb close immediate;
    43.  
    44. Pluggable database altered.
    45.  
    46. SQL> show pdbs;
    47.  
    48.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    49. ---------- ------------------------------ ---------- ----------
    50.          2 PDB$SEED                       READ ONLY  NO
    51.          3 PDB1                           READ WRITE NO
    52.          4 PDB2                           MOUNTED
    53.          5 CNDBAPDB                       MOUNTED
    54.          6 CNDBAPDB3                      MOUNTED
    55.          7 CNDBAPDB2                      MOUNTED
    56.          8 CNDBAPDB4_FRESH                MOUNTED
    57. SQL>

    同时打开/关闭多个PDB

    1. SQL> show pdbs;
    2.  
    3.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    4. ---------- ------------------------------ ---------- ----------
    5.          2 PDB$SEED                       READ ONLY  NO
    6.          3 PDB1                           READ WRITE NO
    7.          4 PDB2                           MOUNTED
    8.          5 CNDBAPDB                       MOUNTED
    9.          6 CNDBAPDB3                      MOUNTED
    10.          7 CNDBAPDB2                      MOUNTED
    11.          8 CNDBAPDB4_FRESH                MOUNTED
    12. SQL> STARTUP PLUGGABLE DATABASE CNDBAPDB2,CNDBAPDB3,CNDBAPDB OPEN READ WRITE;
    13. Pluggable Database opened.
    14. SQL> show pdbs;
    15.  
    16.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    17. ---------- ------------------------------ ---------- ----------
    18.          2 PDB$SEED                       READ ONLY  NO
    19.          3 PDB1                           READ WRITE NO
    20.          4 PDB2                           MOUNTED
    21.          5 CNDBAPDB                       READ WRITE NO
    22.          6 CNDBAPDB3                      READ WRITE NO
    23.          7 CNDBAPDB2                      READ WRITE NO
    24.          8 CNDBAPDB4_FRESH                MOUNTED
    25. SQL> alter pluggable database CNDBAPDB2,CNDBAPDB3,CNDBAPDB close immediate;
    26.  
    27. Pluggable database altered.
    28.  
    29. SQL> show pdbs;
    30.  
    31.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    32. ---------- ------------------------------ ---------- ----------
    33.          2 PDB$SEED                       READ ONLY  NO
    34.          3 PDB1                           READ WRITE NO
    35.          4 PDB2                           MOUNTED
    36.          5 CNDBAPDB                       MOUNTED
    37.          6 CNDBAPDB3                      MOUNTED
    38.          7 CNDBAPDB2                      MOUNTED
    39.          8 CNDBAPDB4_FRESH                MOUNTED
    40. SQL> alter pluggable database CNDBAPDB2,CNDBAPDB3,CNDBAPDB OPEN READ WRITE;
    41.  
    42. Pluggable database altered.
    43.  
    44. SQL> show pdbs;
    45.  
    46.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    47. ---------- ------------------------------ ---------- ----------
    48.          2 PDB$SEED                       READ ONLY  NO
    49.          3 PDB1                           READ WRITE NO
    50.          4 PDB2                           MOUNTED
    51.          5 CNDBAPDB                       READ WRITE NO
    52.          6 CNDBAPDB3                      READ WRITE NO
    53.          7 CNDBAPDB2                      READ WRITE NO
    54.          8 CNDBAPDB4_FRESH                MOUNTED
    55. SQL> alter pluggable database CNDBAPDB2,CNDBAPDB3,CNDBAPDB close immediate;
    56.  
    57. Pluggable database altered.
    58.  
    59. SQL> show pdbs;
    60.  
    61.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    62. ---------- ------------------------------ ---------- ----------
    63.          2 PDB$SEED                       READ ONLY  NO
    64.          3 PDB1                           READ WRITE NO
    65.          4 PDB2                           MOUNTED
    66.          5 CNDBAPDB                       MOUNTED
    67.          6 CNDBAPDB3                      MOUNTED
    68.          7 CNDBAPDB2                      MOUNTED
    69.          8 CNDBAPDB4_FRESH                MOUNTED
    70. SQL>

    打开所有的PDB和关闭所有的PDB

    1. SQL> show pdbs;
    2.  
    3.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    4. ---------- ------------------------------ ---------- ----------
    5.          2 PDB$SEED                       READ ONLY  NO
    6.          3 PDB1                           READ WRITE NO
    7.          4 PDB2                           MOUNTED
    8.          5 CNDBAPDB                       MOUNTED
    9.          6 CNDBAPDB3                      MOUNTED
    10.          7 CNDBAPDB2                      MOUNTED
    11.          8 CNDBAPDB4_FRESH                MOUNTED
    12. SQL> 
    13. SQL> 
    14. SQL> ALTER PLUGGABLE DATABASE ALL OPEN READ WRITE;
    15.  
    16. Pluggable database altered.
    17.  
    18. SQL> show pdbs;
    19.  
    20.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    21. ---------- ------------------------------ ---------- ----------
    22.          2 PDB$SEED                       READ ONLY  NO
    23.          3 PDB1                           READ WRITE NO
    24.          4 PDB2                           READ WRITE NO
    25.          5 CNDBAPDB                       READ WRITE NO
    26.          6 CNDBAPDB3                      READ WRITE NO
    27.          7 CNDBAPDB2                      READ WRITE NO
    28.          8 CNDBAPDB4_FRESH                MOUNTED
    29. SQL> ALTER PLUGGABLE DATABASE ALL CLOSE IMMEDIATE;
    30.  
    31. Pluggable database altered.
    32.  
    33. SQL> show pdbs;
    34.  
    35.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    36. ---------- ------------------------------ ---------- ----------
    37.          2 PDB$SEED                       READ ONLY  NO
    38.          3 PDB1                           MOUNTED
    39.          4 PDB2                           MOUNTED
    40.          5 CNDBAPDB                       MOUNTED
    41.          6 CNDBAPDB3                      MOUNTED
    42.          7 CNDBAPDB2                      MOUNTED
    43.          8 CNDBAPDB4_FRESH                MOUNTED
    44. SQL>

    除了CNDBAPDB4_FRESH（只能只读模式打开）外，打开其他PDB，

    1. SQL> show pdbs;
    2.  
    3.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    4. ---------- ------------------------------ ---------- ----------
    5.          2 PDB$SEED                       READ ONLY  NO
    6.          3 PDB1                           MOUNTED
    7.          4 PDB2                           MOUNTED
    8.          5 CNDBAPDB                       MOUNTED
    9.          6 CNDBAPDB3                      MOUNTED
    10.          7 CNDBAPDB2                      MOUNTED
    11.          8 CNDBAPDB4_FRESH                MOUNTED
    12. SQL> 
    13. SQL> ALTER PLUGGABLE DATABASE ALL EXCEPT CNDBAPDB4_FRESH OPEN READ WRITE;
    14.  
    15. Pluggable database altered.
    16.  
    17. SQL> show pdbs;
    18.  
    19.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    20. ---------- ------------------------------ ---------- ----------
    21.          2 PDB$SEED                       READ ONLY  NO
    22.          3 PDB1                           READ WRITE NO
    23.          4 PDB2                           READ WRITE NO
    24.          5 CNDBAPDB                       READ WRITE NO
    25.          6 CNDBAPDB3                      READ WRITE NO
    26.          7 CNDBAPDB2                      READ WRITE NO
    27.          8 CNDBAPDB4_FRESH                MOUNTED
    28. SQL>

    保存当前PDB的打开状态

    1. ## 保存一个PDB的打开状态
    2. ALTER PLUGGABLE DATABASE CNDBAPDB SAVE STATE;
    3.  
    4. ## 保存所有PDB的打开状态
    5. ALTER PLUGGABLE DATABASE ALL SAVE STATE;
    6.  
    7. ## 保存多个PDB的打开状态。
    8. ALTER PLUGGABLE DATABASE CNDBAPDB,CNDBAPDB2 SAVE STATE;
    9.  
    10. ## 除了CNDBAPDB4_FRESH外，打开其他PDB状态，
    11.  
    12. ALTER PLUGGABLE DATABASE ALL EXCEPT CNDBAPDB4_FRESH SAVE STATE;

    关闭PDB

    1. alter pluggable database cndbapdb close immediate;
    2.  
    3. SHUTDOWN IMMEDIATE;

  • 相关阅读:
    python篇---python 用opencv读取rtsp视频流（二）
    OSINT技术情报精选·2024年6月第2周
    CentOS即将停服，国产化系统替代参考
    软考高项-计算题（3）
    【Python脚本进阶】1.1、基础环境
    【Codeforces Round #813 (Div. 2)(A~C)】
    【Node.js】zlib 模块
    【智能家居】5、主流程设计以及外设框架编写与测试
    天才制造者：独行侠、科技巨头和AI｜深度学习崛起十年
    基于JAVA乐购游戏商城系统计算机毕业设计源码+数据库+lw文档+系统+部署
  • 原文地址：https://blog.csdn.net/u011868279/article/details/128122386