19c pdb如何保存启动状态

来源：这里教程网时间：2026-03-03 16:19:12 作者：

我们要保存pdb状态，首先要了解视图DBA_PDB_SAVED_STATES显示了当前CDB中保存的pdb状态信息。

This view is a data link, so the data is also available within the PDB.

Column	Datatype	NULL	Description
`CON_ID`	`NUMBER`	`NOT NULL`	The ID of the PDB
`CON_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the PDB
`INSTANCE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the instance for which the state is saved
`CON_UID`	`NUMBER`	`NOT NULL`	Unique ID assigned to the PDB at creation time
`GUID`	`RAW(16)`		Globally unique immutable ID assigned to the PDB at creation time
`STATE`	`VARCHAR2(14)`		Open state of the PDB
`RESTRICTED`	`VARCHAR2(3)`		Restricted mode of the PDB

默认情况，启停CDB，观察pdb状态

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

SQL> alter pluggable database all open;
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                           READ WRITE NO

SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started.Total System Global Area 2348810240 bytes Fixed Size 8795376 bytes Variable Size 855640848 bytes Database Buffers 1476395008 bytes Redo Buffers 7979008 bytes Database mounted. Database opened.

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

那如果我们想让pdb3在cdb启动后就是open状态，需要如何设置？首先查看DBA_PDB_SAVED_STATES

SQL>  select * from dba_pdb_saved_states;
no rows selected

单独打开pdb3

SQL> alter pluggable database pdb3 open;
Pluggable database altered.

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

接着保存pdb3启动状态

SQL> alter pluggable database pdb3 save state;
Pluggable database altered.

SQL> select * from dba_pdb_saved_states;
    CON_ID----------CON_NAME--------------------------------------------------------------------------------INSTANCE_NAME--------------------------------------------------------------------------------   CON_UID GUID                             STATE          RES---------- -------------------------------- -------------- ---         5PDB3orcl11117920907 921B7939BC8C217CE053DDF0A8C04389 OPEN           NO

重启cdb验证：SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started.Total System Global Area 2348810240 bytes Fixed Size 8795376 bytes Variable Size 855640848 bytes Database Buffers 1476395008 bytes Redo Buffers 7979008 bytes Database mounted. Database opened.

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

参考文档： https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DBA_PDB_SAVED_STATES.html https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/ALTER-PLUGGABLE-DATABASE.html#GUID-A29491AD-8F0F-4E52-9D94-57FC3FF8FBC7