在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
本文档主要讲述的是基于REST架构的Web Service设计；REST（Representational State Transfer）是一种轻量级的Web Service架构风格，其实现和操作明显比SOAP和XML-RPC更为简洁，可以完全通过HTTP协议实现，还可以利用缓存Cache来提高响应速 度，性能、效率和易用性上都优于SOAP协议。希望本文档会给有需要的朋友带来帮助；感兴趣的朋友可以过来看看
0
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 NOSQL> 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原文地址：oracle12c_pdb_SAVE STATE, 感谢原作者分享。
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移，垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是，许多工具可以让 Windows 保持平稳运行。
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
402
收藏
