ORACLE_OCP多租户之CDB和PDB的启停

ORACLE_OCP多租户之CDB和PDB的启停

一、关闭CDB

1. 查看实例状态

   
   [oracle@oracle12-cdb ~]$ sqlplus / as sysdba
   
   SQL*Plus: Release 12.2.0.1.0 Production on Sat Jan 9 08:11:57 2021
   
   Copyright (c) 1982, 2016, Oracle.  All rights reserved.
   
   
   Connected to:
   Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
   
   SQL>
   SQL>
   SQL> select status from v$instance;
   
   STATUS
   ------------
   OPEN
   
   SQL>
   
   

2. 目前我们的cdb库在开启状态，开始关闭CDB

   SQL> shutdown immediate;
   Database closed.
   Database dismounted.
   ORACLE instance shut down.
   SQL> exit
   Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
   

• 关闭后，在使用sqlplus / as sysdba进入，可以看到我们连接到空实例了，这就证明，我们的CDB已经关闭了。

  [oracle@oracle12-cdb ~]$ sqlplus / as sysdba
  
  SQL*Plus: Release 12.2.0.1.0 Production on Sat Jan 9 08:14:55 2021
  
  Copyright (c) 1982, 2016, Oracle.  All rights reserved.
  
  Connected to an idle instance.
  
  SQL>
  
  

二、开启CDB

SQL> startup
ORACLE instance started.

Total System Global Area  838860800 bytes
Fixed Size                  8798312 bytes
Variable Size             356519832 bytes
Database Buffers          465567744 bytes
Redo Buffers                7974912 bytes
Database mounted.
Database opened.
SQL> select status from v$instance;

STATUS
------------
OPEN

SQL>

• 开启成功

三、开启pdb

• 我们现在先去检查一下pdb的状态。(所有的命令都在sqlplus下执行)

SQL> set lines 300
SQL> col NAME for a40
SQL> select con_id, dbid, NAME, OPEN_MODE from v$pdbs;

    CON_ID       DBID NAME                                     OPEN_MODE
---------- ---------- ---------------------------------------- ----------
         2 3879826860 PDB$SEED                                 READ ONLY
         3 2869338774 PDB                                      MOUNTED

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            MOUNTED
SQL>

• 看到了吗？！我们的pdb现在是mouted（不要去关PDB$SEED）,那就是说明了，我们的CDB在启动的时候已经把PDB自动拉起到了MOUNTED状态。现在盘他。
• 开启pdb

  
  SQL> alter pluggable database pdb 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
  SQL>
  
  

  • 看到了吗，我们刚才创建的PDB现在是 READ WRITE状态，也就是说明了，OPEN成功。

四、关闭pdb

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE NO
SQL> alter pluggable database pdb close;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            MOUNTED
SQL>

• 又回到了mouted状态，关闭成功。

五、如果你要一次性的启动或关闭所有的pdb请使用下面的命令

alter pluggable database all open;
alter pluggable database all close;