在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 RESTRICT<mark style="color:transparent">本文来源gaodaimacom搞#^代%!码网@</mark>ED---------- ------------------------------ ---------- ---------- 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> startupORACLE instance started. Total System Global Area 838860800 bytesFixed SIZE 2921400 bytesVariable SIZE 608177224 bytesDATABASE Buffers 222298112 bytesRedo Buffers 5464064 bytesDATABASE 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> startupORACLE instance started. Total System Global Area 838860800 bytesFixed SIZE 2921400 bytesVariable SIZE 608177224 bytesDATABASE Buffers 222298112 bytesRedo Buffers 5464064 bytesDATABASE 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 NOSQL> ALTER pluggable DATABASE ALL save state; Pluggable DATABASE altered. SQL> shutdown immediate;DATABASE closed.DATABASE dismounted.ORACLE instance shut down. SQL> startupORACLE instance started. Total System Global Area 838860800 bytesFixed SIZE 2921400 bytesVariable SIZE 608177224 bytesDATABASE Buffers 222298112 bytesRedo Buffers 5464064 bytesDATABASE 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> startupORACLE instance started. Total System Global Area 838860800 bytesFixed SIZE 2921400 bytesVariable SIZE 608177224 bytesDATABASE Buffers 222298112 bytesRedo Buffers 5464064 bytesDATABASE 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, 感谢原作者分享。