1  说明

The SAVE STATE clause and DISCARD STATE clause are now available with the ALTER PLUGGABLE DATABASE SQL statement to preserve the open mode of a pluggable database (PDB) across multitenant container database (CDB) restarts.

If SAVE STATE is specified, open mode of specified PDB is preserved across CDB restart on instances specified in the INSTANCES clause. Similarly, with the DISCARD STATE clause, the open mode of specified PDB is no longer preserved.http://www.cndba.cn/Expect-le/article/2104http://www.cndba.cn/Expect-le/article/2104http://www.cndba.cn/Expect-le/article/2104

从12.1.0.2开始，支持保存当前PDB的打开状态，在重启CDB后，Oracle会自动把PDB启动到保存的状态。

SAVE STATE:保存当前状态

DISCARD STATE：忽略当前状态

2  实验

这里只介绍相关功能，对于详细的语法不做过多介绍，关于详细信息查看官方文档：http://www.cndba.cn/Expect-le/article/2104

http://docs.oracle.com/database/121/ADMIN/cdb_admin.htm#ADMIN14251

2.1   保存CNDBA_PDB_NEW当前打开状态

SQL> show pdbs;
    CON_ID CON_NAME	  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
 2 PDB$SEED	  READ ONLY  NO
 3 LEI1   MOUNTED
 4 LEI2   MOUNTED
 5 SIHONG	  MOUNTED
 7 CNDBA_PDB_NEW	  READ WRITE NO

SQL>  ALTER PLUGGABLE DATABASE CNDBA_PDB_NEW SAVE STATE;
Pluggable database altered.

http://www.cndba.cn/Expect-le/article/2104

---保存所有PDB当前的状态http://www.cndba.cn/Expect-le/article/2104

http://www.cndba.cn/Expect-le/article/2104

 ALTER PLUGGABLE DATABASE ALL SAVE STATE;

http://www.cndba.cn/Expect-le/article/2104

--排除某个PDB，保存其他PDB当前打开状态http://www.cndba.cn/Expect-le/article/2104

ALTER PLUGGABLE DATABASE ALL EXCEPT salespdb, hrpdb SAVE STATE;

2.2   重启CDB

--纯属实验，真实环境不要直接重启CDB。http://www.cndba.cn/Expect-le/article/2104

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

SQL> startup
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size	    8801008 bytes
Variable Size	 1023411472 bytes
Database Buffers	   37748736 bytes
Redo Buffers	    3780608 bytes
Database mounted.
Database opened.

SQL> show pdbs;
    CON_ID CON_NAME	  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
 2 PDB$SEED	  READ ONLY  NO
 3 LEI1   MOUNTED
 4 LEI2   MOUNTED
 5 SIHONG	  MOUNTED
 7 CNDBA_PDB_NEW READ WRITE NO --自动启动到之前保存的状态。

版权声明：本文为博主原创文章，未经博主允许不得转载。

PDB State Management Across CDB Restart