oracle pdb自启动ALTER pluggable DATABASE ALL save state

最新推荐文章于 2022-02-28 08:34:07 发布

原创最新推荐文章于 2022-02-28 08:34:07 发布 · 3.8k 阅读

4 ·

CC 4.0 BY-SA版权

版权源自：dahouzi.cn

oracle 专栏收录该内容

9 篇文章

订阅专栏

本文介绍在Oracle12.2版本中如何通过两种方式设置可插拔数据库(PDB)的自动启动：一是使用触发器，二是利用状态保存特性。这两种方法能够帮助管理员简化数据库管理流程。

oracle12.1只能使用触发器
oracle12.2可用ALTER pluggable DATABASE ALL save state;
高版本建议优先使用第二种模式

触发器模式

CREATE TRIGGER open_all_pdbs
   AFTER STARTUP ON DATABASE
BEGIN
   EXECUTE IMMEDIATE 'alter pluggable database all open';
END open_all_pdbs;
/

状态保存模式

#12.2以上版本在pdb open状态下打以下命令执行
ALTER pluggable DATABASE ALL save state;–自动启动PDB
ALTER pluggable DATABASE ALL discard state;–取消自动启动PDB

参考如下：

SQL> startup
ORACLE instance started.

Total System Global Area 3741318376 bytes
Fixed Size                  9141480 bytes
Variable Size             754974720 bytes
Database Buffers         2969567232 bytes
Redo Buffers                7634944 bytes
Database mounted.
Database opened.
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           MOUNTED（默认状态）
SQL> alter session set container=pdb1;--切换到

Session altered.

SQL> alter database open;--开启pdb1 open状态

Database altered.

SQL> alter session set container=cdb$root;--切换到cdb才能执行

Session 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 3741318376 bytes
Fixed Size                  9141480 bytes
Variable Size             754974720 bytes
Database Buffers         2969567232 bytes
Redo Buffers                7634944 bytes
Database mounted.
Database opened.
SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ（修改后状态） WRITE NO