可以创建触发器，自动启动pdb

CREATE OR REPLACE TRIGGER AFTER_STARTUP

AFTER STARTUP ON DATABASE

BEGIN

EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN instances=all';

END AFTER_STARTUP;

/

12.1.0.2之后 可以用 alter pluggable database *** save state;  

在12.1.0.2的时候可以使用参数SAVE STATE来保存pdb

SQL>  ALTER pluggable DATABASE ALL save state;

col NAME format a20

COLUMN con_name FORMAT A20

COLUMN instance_name FORMAT A20

col OPEN_TIME format a40

SELECT p.CON_ID

,p.NAME

,dbid

,p.guid

,p.OPEN_MODE

,s.STATE AUTO_START

,TOTAL_SIZE / 1024 / 1024 size_MB

,CREATION_TIME

,p.OPEN_TIME

FROM V$PDBS p

LEFT JOIN dba_pdb_saved_states s ON p.GUID = s.GUID

ORDER BY 1;

    CON_ID NAME              DBID GUID                             OPEN_MODE  AUTO_START        SIZE_MB CREATION_ OPEN_TIME

---------- ----------- ---------- -------------------------------- ---------- -------------- ---------- --------- ----------------------------------------

         2 PDB$SEED    3078524370 8AF601EEA35B1EAAE0532C0AA8C07C82 READ ONLY                        744 10-JUN-19 18-JUN-19 03.12.48.028 PM +08:00

         3 ORCLPDB1    1584010649 8AF61E4659E333A8E0532C0AA8C0A942 MOUNTED                            0 10-JUN-19

         4 ORCLPDB2     625756195 8AF62931ACAE378CE0532C0AA8C0F74A MOUNTED                            0 10-JUN-19

         5 ORCLPDB3    2174521581 8AF62F11709239FCE0532C0AA8C0D135 READ WRITE OPEN                  879 10-JUN-19 19-JUN-19 12.02.06.312 PM +08:00