12c中,必须先启动CDB,然后才能启动PDB。启动CDB后,PDB默认启动到mount状态。
启动PDB
连接到CDB,
关闭PDB,
若要关闭指定PDB,则连接到PDB,
无需再执行shutdown immediate,关闭PDB并不关闭其共享的实例。
若要关闭全部CDB和PDB,只需连接到CDB,执行shutdown immediate即可。
点击(此处)折叠或打开
- SQL> select name,open_mode from V$pdbs;
-
- NAME OPEN_MODE
- ------------------------------ ----------
- PDB$SEED READ ONLY
- PDB1 MOUNTED
连接到CDB,
点击(此处)折叠或打开
- #启动指定PDB
- alter pluggable database pdb1 open;
- #启动全部PDB
- alter pluggable database all open;
- SQL> select name,open_mode from V$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
PDB1 READ WRITE
若要关闭指定PDB,则连接到PDB,
点击(此处)折叠或打开
- sqlplus sys@pdb1 as sysdba
-
-
- SQL> alter pluggable database close;
-
- Pluggable database altered.
- #也可在CDB中关闭PDB
- SQL> alter pluggable database pdb1 close immediate;
- SQL> alter pluggable database all except pdb1 close;
- SQL> alter pluggable database all close;
-
若要关闭全部CDB和PDB,只需连接到CDB,执行shutdown immediate即可。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22621861/viewspace-2098569/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22621861/viewspace-2098569/