12c中保持 启动CDB后PDB的状态

----保持某些pdb起库时就打开状态
SQL> startup
ORACLE instance started.
Total System Global Area 1090519040 bytes
Fixed Size    2923440 bytes
Variable Size  704644176 bytes
Database Buffers  369098752 bytes
Redo Buffers   13852672 bytes
Database mounted.

Database opened.

SQL> select NAME,CON_ID,OPEN_MODE   from v$pdbs;
NAME CON_ID OPEN_MODE
---------------------------------------------------------------------------------------------------- ---------- ----------
PDB$SEED      2 READ ONLY
PDBORCL      3 READ WRITE
PDB4      4 MOUNTED
PDB5      5 MOUNTED
PDB6      6 MOUNTED
QL> alter pluggable database pdb4 open;
Pluggable database altered.

SQL> select NAME,CON_ID,OPEN_MODE   from v$pdbs;
NAME CON_ID OPEN_MODE
---------------------------------------------------------------------------------------------------- ---------- ----------
PDB$SEED      2 READ ONLY
PDBORCL      3 READ WRITE
PDB4      4 READ WRITE
PDB5      5 MOUNTED
PDB6      6 MOUNTED

--保持CDB重启后PDB的状态

alter pluggable database all save state;
shut immediate;
startup
SQL> select name,OPEN_MODE from v$pdbs;
NAME     OPEN_MODE
---------------------------------------------------------------------------------------------------- ----------
PDB$SEED     READ ONLY
PDBORCL     READ WRITE
PDB4     READ WRITE
PDB5     MOUNTED
PDB6     MOUNTED