在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 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 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