在cdb中启动和关闭pdb

最新推荐文章于 2025-01-01 18:20:16 发布

原创最新推荐文章于 2025-01-01 18:20:16 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

Oracle DB 12c 专栏收录该内容

62 篇文章

订阅专栏

本文记录了在 Oracle 数据库中使用 SQL*Plus 对 RAC 环境下的可插拔数据库 (PDB) 进行启动、关闭等操作的过程。展示了如何通过 SQL 命令管理不同 PDB 的状态，并提供了查询 PDB 当前状态的方法。

[root@db12cr2 ~]# su - oracle
[oracle@db12cr2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 14 12:43:39 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup pluggable database open;
SP2-1547: Can not startup Pluggable database - Consolidated Database down.
SQL> startup
ORACLE instance started.

Total System Global Area  587202560 bytes
Fixed Size		    8795424 bytes
Variable Size		  343935712 bytes
Database Buffers	  226492416 bytes
Redo Buffers		    7979008 bytes
Database mounted.
Database opened.
SQL>  startup pluggable database highgo2 open;
Pluggable Database opened.
SQL> startup pluggable database highgo3;
Pluggable Database opened.
SQL> 
SQL> alter pluggable database highgo2 close immediate;
---->>>上述命令是单实例级别的命令,rac的话,需要在其他节点也执行此命令.

Pluggable database altered.

SQL> set lines 300
SQL> SELECT NAME, OPEN_MODE FROM V$PDBS WHERE CON_ID > 2;

NAME																 OPEN_MODE
-------------------------------------------------------------------------------------------------------------------------------- ----------
HIGHGO1 															 READ WRITE
HIGHGO2 															 MOUNTED
HIGHGO3 															 READ WRITE

SQL> show pdbs    

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 HIGHGO1			  READ WRITE NO
	 4 HIGHGO2			  MOUNTED
	 5 HIGHGO3			  READ WRITE NO
SQL>