[20181018]12c Pluggable Database save state.txt

[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.