Oracle 12c pdb自动启动

来源：互联网发布：防火墙端口4950 编辑：程序博客网时间：2024/05/22 02:13

PDB Pluggable Database是12c中扛鼎的一个新特性，但是对于CDB中的PDB，默认启动CDB时不会将所有的PDB带起来，这样我们就需要手动alter pluggable database ALL OPEN;

例如：

SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> SQL> startup ;ORACLE instance started.Total System Global Area 1419685888 bytesFixed Size                  2288344 bytesVariable Size             536872232 bytesDatabase Buffers          872415232 bytesRedo Buffers                8110080 bytesDatabase mounted.Database opened.SQL> select con_id,name,open_mode from v$pdbs;    CON_ID NAME                           OPEN_MODE---------- ------------------------------ ----------         2 PDB$SEED                       READ ONLY         3 MACC                           MOUNTED

可以通过添加Trigger的形式来客制化startup时自动将PDB OPEN:

CREATE TRIGGER open_all_pdbs   AFTER STARTUP   ON DATABASEBEGIN   EXECUTE IMMEDIATE 'alter pluggable database all open';END open_all_pdbs;/Trigger created.SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> SQL> startup;ORACLE instance started.Total System Global Area 1419685888 bytesFixed Size                  2288344 bytesVariable Size             536872232 bytesDatabase Buffers          872415232 bytesRedo Buffers                8110080 bytesDatabase mounted.Database opened.SQL> select con_id,name,open_mode from v$pdbs;    CON_ID NAME                           OPEN_MODE---------- ------------------------------ ----------         2 PDB$SEED                       READ ONLY         3 MACC                           READ WRITENOTE: dependency between database MAC and diskgroup resource ora.DATADG.dg is establishedalter pluggable database all openSun Jul 07 01:40:59 2013This instance was first to open pluggable database MACC (container=3)Opening pdb MACC (3) with no Resource Manager plan activePluggable database MACC opened read writeCompleted: alter pluggable database all openStarting background process CJQ0

使用SYS用户创建如下触发器即可：

conn / as sysdbaCREATE TRIGGER open_all_pdbs   AFTER STARTUP   ON DATABASEBEGIN   EXECUTE IMMEDIATE 'alter pluggable database all open';END open_all_pdbs;/

0 0