重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 19c pdb如何保存 READ WRITE状态 [打印本页]

作者: mahan 时间: 2026-1-18 19:55
标题: 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

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)