19c pdb如何保存 READ WRITE状态

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

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

SQL> show pdbs

CON_ID CON_NAME                       OPEN MODE  RESTRICTED

     2 PDB$SEED                       READ ONLY  NO
     3 WXOADB                         READ WRITE NO

SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> show pdbs

CON_ID CON_NAME                       OPEN MODE  RESTRICTED

     2 PDB$SEED                       MOUNTED
     3 WXOADB                         MOUNTED

SQL>

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

首先查看DBA_PDB_SAVED_STATES

SQL>  select * from dba_pdb_saved_states;

未选定行

接着保存wxoadb启动状态

SQL> alter pluggable database wxoadb save state;

插接式数据库已变更。

SQL>

SQL> select * from dba_pdb_saved_states;

CON_ID CON_NAME                                                                                                                                                                                                                                                                                                                                                                                         INSTANCE_NAME                                                                                                                                                                                                                                                                                                                                                                                       CON_UID GUID                             STATE                                      RESTRICTE

     3 WXOADB                                                                                                                                                                                                                                                                                                                                                                                           fruits                                                                                                                                                                                                                                                                                                                                                                                           1492445586 ADB6E57F41362F8AE0553E5456B9E6A2 OPEN                                       YES

SQL>
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。

Total System Global Area 1191178688 bytes
Fixed Size 9134528 bytes
Variable Size 738197504 bytes
Database Buffers 436207616 bytes
Redo Buffers 7639040 bytes
数据库装载完毕。
数据库已经打开。
SQL> show pdbs

CON_ID CON_NAME                       OPEN MODE  RESTRICTED

     2 PDB$SEED                       READ ONLY  NO
     3 WXOADB                         READ WRITE YES

SQL>