我们要保存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 |
|---|---|---|---|
|
|
|
|
The ID of the PDB |
|
|
|
|
Name of the PDB |
|
|
|
|
Name of the instance for which the state is saved |
|
|
|
|
Unique ID assigned to the PDB at creation time |
|
|
|
Globally unique immutable ID assigned to the PDB at creation time | |
|
|
|
Open state of the PDB | |
|
|
|
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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23825935/viewspace-2747139/ ，如需转载，请注明出处，否则将追究法律责任。
