我们要保存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状态

1

2

3

4

5

6

7

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

1 2	`SQL>` `alter` `pluggable` `database` `all` `open` `;` `Pluggable` `database` `altered.`

1

2

3

4

5

6

7

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.

1

2

3

4

5

6

7

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

1 2	`SQL>` `select` `*` `from` `dba_pdb_saved_states;` `no` `rows` `selected`

单独打开pdb3

1 2	`SQL>` `alter` `pluggable` `database` `pdb3` `open` `;` `Pluggable` `database` `altered.`

1

2

3

4

5

6

7

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启动状态

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

1

2

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.

1

2

3

4

5

6

7

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

19c pdb如何保存启动状态Database closed. Database dismounted.