在12.1.0.1的时候pdb不能跟随cdb自动open,如果实现自动打开基本靠触发器，在12.1.0.2的时候可以使用参数SAVE STATE来保存pdb在关闭前的状态 SQL SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- -----
在12.1.0.1的时候pdb不能跟随cdb自动open,如果实现自动打开基本靠触发器，在12.1.0.2的时候可以使用参数SAVE STATE来保存pdb在关闭前的状态
SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB MOUNTED 4 PDB2 MOUNTED 5 PDB3 MOUNTED 6 PDB4 MOUNTED 7 PDB5 MOUNTED SQL> shutdown immediate; DATABASE closed. DATABASE dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 838860800 bytes Fixed SIZE 2921400 bytes Variable SIZE 608177224 bytes DATABASE Buffers 222298112 bytes Redo Buffers 540 bytes DATABASE mounted. DATABASE opened. SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB MOUNTED 4 PDB2 MOUNTED 5 PDB3 MOUNTED 6 PDB4 MOUNTED 7 PDB5 MOUNTED SQL> ALTER pluggable DATABASE ALL save state 2 ; Pluggable DATABASE altered. SQL> shutdown immediate; DATABASE closed. DATABASE dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 838860800 bytes Fixed SIZE 2921400 bytes Variable SIZE 608177224 bytes DATABASE Buffers 222298112 bytes Redo Buffers 540 bytes DATABASE mounted. DATABASE opened. SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB MOUNTED 4 PDB2 MOUNTED 5 PDB3 MOUNTED 6 PDB4 MOUNTED 7 PDB5 MOUNTED
可以看出如果pdb是mount状态的时候来设置SAVE STATE,在数据库restart的时候也是mount
SQL> ALTER pluggable DATABASE ALL DISCARD STATE; Pluggable DATABASE altered. 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 PDB READ WRITE NO 4 PDB2 READ WRITE NO 5 PDB3 READ WRITE NO 6 PDB4 READ WRITE NO 7 PDB5 READ WRITE NO SQL> ALTER pluggable DATABASE ALL save state; Pluggable DATABASE altered. SQL> shutdown immediate; DATABASE closed. DATABASE dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 838860800 bytes Fixed SIZE 2921400 bytes Variable SIZE 608177224 bytes DATABASE Buffers 222298112 bytes Redo Buffers 540 bytes DATABASE mounted. DATABASE opened. SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB READ WRITE NO 4 PDB2 READ WRITE NO 5 PDB3 READ WRITE NO 6 PDB4 READ WRITE NO 7 PDB5 READ WRITE NO
SQL> ALTER pluggable DATABASE ALL DISCARD STATE; Pluggable DATABASE altered. SQL> ALTER pluggable DATABASE ALL close; Pluggable DATABASE altered. SQL> ALTER pluggable DATABASE ALL save state; Pluggable DATABASE altered. SQL> shutdown immediate; DATABASE closed. DATABASE dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 838860800 bytes Fixed SIZE 2921400 bytes Variable SIZE 608177224 bytes DATABASE Buffers 222298112 bytes Redo Buffers 540 bytes DATABASE mounted. DATABASE opened. SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB MOUNTED 4 PDB2 MOUNTED 5 PDB3 MOUNTED 6 PDB4 MOUNTED 7 PDB5 MOUNTED
原文地址：oracle12c_pdb_SAVE STATE, 感谢原作者分享。