oracle12c_pdb_SAVESTATE
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了oracle12c_pdb_SAVESTATE，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含4928字，纯文字阅读大概需要8分钟。
内容图文
在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
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 NO
SQL> 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, 感谢原作者分享。
内容总结
以上是互联网集市为您收集整理的oracle12c_pdb_SAVESTATE全部内容，希望文章能够帮你解决oracle12c_pdb_SAVESTATE所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。