How to Stop and Start a Pluggable Database - 19c

1. Shutdown a container database (CDB) and all pluggable databases (PDBs)
[code] [oracle@orcl19c admin]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Apr 25 02:29:24 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> SQL> col name format a20 SQL> col open_mode format a20 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE -------------------- -------------------- PDB$SEED READ ONLY ORCL1PDB MOUNTED PDB1 MOUNTED RCAT READ WRITE SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. [/code]
2. Startup the CDB

[code] [oracle@orcl19c admin]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Apr 25 02:35:15 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 893385440 bytes Fixed Size 9140960 bytes Variable Size 310378496 bytes Database Buffers 566231040 bytes Redo Buffers 7634944 bytes Database mounted. Database opened. SQL> SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> SQL> col name format a20 SQL> col open_mode format a20 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE -------------------- -------------------- PDB$SEED READ ONLY ORCL1PDB MOUNTED PDB1 MOUNTED RCAT MOUNTED SQL> [/code]
Note: When you start a CDB it does not automatically start the PDBs (you can see all PDBs ORCL1PDB, PDB1 and RCAT in MOUNT state)

3. Start a PDB

To start single PDB
[code] SQL> alter pluggable database ORCL1PDB open; Pluggable database altered. SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE -------------------- -------------------- PDB$SEED READ ONLY ORCL1PDB READ WRITE PDB1 MOUNTED RCAT MOUNTED [/code]
This will open pluggable database ORCL1PDB and you can see PDB1 and RCAT still in MOUNT state

To start all PDB's

[code] SQL> alter pluggable database all open; Pluggable database altered. SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE -------------------- -------------------- PDB$SEED READ ONLY ORCL1PDB READ WRITE PDB1 READ WRITE RCAT READ WRITE [/code]
4. Stop a PDB

To stop single PDB
[code] SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> SQL> alter pluggable database RCAT close immediate; Pluggable database altered. SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE -------------------- -------------------- PDB$SEED READ ONLY ORCL1PDB READ WRITE PDB1 READ WRITE RCAT MOUNTED SQL> [/code]
To stop all PDB's
[code] SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> SQL> alter pluggable database all close immediate; Pluggable database altered. SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE -------------------- -------------------- PDB$SEED READ ONLY ORCL1PDB MOUNTED PDB1 MOUNTED RCAT MOUNTED SQL> [/code]