[20181018]12c Pluggable Database save state.txt

--//我最早使用版本12.1.0.1不支持这个特性,每次open cdb后,都要手工执行:
# ALTER PLUGGABLE DATABASE ALL OPEN;
--//现在使用的版本12.2.0.1支持这个特性,简单测试看看:

1.环境:
SCOTT@test01p> @ ver1
PORT_STRING                    VERSION        BANNER                                                                               CON_ID
------------------------------ -------------- -------------------------------------------------------------------------------- ----------
IBMPC/WIN_NT64-9.1.0           12.2.0.1.0     Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0

SYS@test> startup
ORACLE instance started.
Total System Global Area  805306368 bytes
Fixed Size                  8924064 bytes
Variable Size             297796704 bytes
Database Buffers          490733568 bytes
Redo Buffers                7852032 bytes
Database mounted.
Database opened.

SYS@test> show pdbs
CON_ID CON_NAME OPEN MODE  RESTRICTED
------ -------- ---------- ----------
     2 PDB$SEED READ ONLY  NO
     3 TEST01P  MOUNTED


SYS@test> alter pluggable database test01p SAVE STATE;
Pluggable database altered.

SYS@test> SELECT * FROM DBA_PDB_SAVED_STATES;
no rows selected

--//没有打开pdb,没用.
--//# ALTER PLUGGABLE DATABASE ALL OPEN;

SYS@test> show pdbs
CON_ID CON_NAME OPEN MODE  RESTRICTED
------ -------- ---------- ----------
     2 PDB$SEED READ ONLY  NO
     3 TEST01P  READ WRITE NO


2.现在可以保存当前状态,下次启动cdb时自动启动:

SYS@test> alter pluggable database test01p SAVE STATE;
Pluggable database altered.

--//如果rac环境,加入INSTANCES=ALL;例子:
--// ALTER PLUGGABLE DATABASE test03p SAVE STATE INSTANCES=ALL;

3.视图DBA_PDB_SAVED_STATES视图记录了save states:

SYS@test> SELECT * FROM DBA_PDB_SAVED_STATES;
    CON_ID CON_NAME             INSTANCE_NAME           CON_UID GUID                             STATE                RES
---------- -------------------- -------------------- ---------- -------------------------------- -------------------- ---
         3 TEST01P              test                 2923790755 C287357CE3D5470AA01668B945336F73 OPEN                 NO

--//关闭数据库,测试看看:
SYS@test> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.

SYS@test> startup
ORACLE instance started.
Total System Global Area  805306368 bytes
Fixed Size                  8924064 bytes
Variable Size             297796704 bytes
Database Buffers          490733568 bytes
Redo Buffers                7852032 bytes
Database mounted.
Database opened.

SYS@test> show pdbs
CON_ID CON_NAME OPEN MODE  RESTRICTED
------ -------- ---------- ----------
     2 PDB$SEED READ ONLY  NO
     3 TEST01P  READ WRITE NO

--//当然你可以移除:
SYS@test> SELECT * FROM DBA_PDB_SAVED_STATES;
    CON_ID CON_NAME             INSTANCE_NAME           CON_UID GUID                             STATE                RES
---------- -------------------- -------------------- ---------- -------------------------------- -------------------- ---
         3 TEST01P              test                 2923790755 C287357CE3D5470AA01668B945336F73 OPEN                 NO

SYS@test> alter pluggable database test01p discard state;
Pluggable database altered.

SYS@test> SELECT * FROM DBA_PDB_SAVED_STATES;
no rows selected

--//也可以执行如下保存全部PDBs的SAVE STATE:
--//alter pluggable database all save state;
--//After that all PDBs will stay UP when the container started.