在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 5464064 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 5464064 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 5464064 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 NOSQL> 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 5464064 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, 感谢原作者分享。
