Oracle 12C -- 统一启动/关闭PDBs

转载于 2015-11-01 16:02:00 发布 · 73 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/abclife/p/4928016.html

本文详细介绍了如何使用SQL命令对PL/SQL数据库实例进行打开、关闭等操作，并通过实例展示了不同状态之间的切换。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL> select name,open_mode from v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDB1                           MOUNTED
PDB2                           MOUNTED

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> select name,open_mode from v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDB1                           READ WRITE
PDB2                           READ WRITE

SQL> alter pluggable database all close;

Pluggable database altered.

SQL> select name,open_mode from v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDB1                           MOUNTED
PDB2                           MOUNTED

SQL>