点击(此处)折叠或打开
-
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即可。