Opening and Closing PDBs

Startup/Shutdown the PDB:
In multitenant architecture open and closing of the databases having some command of startup and shutdown but with different results. As we have 1 main container (CDB) containing many PDBs, so one have to be very careful while performing startup/shutdown operations in production enviroment. Issuing the shutdown immediate command at CDB level will shutdown all PDBs (any number with in container) including the CDB. But at PDB level it issuing shutdown command will close that specific database.

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL>

It will shutdown all the PDBs as it is main instance. so will need to start again:

Now starting and shutting down the Portable database:

Issuing Shutdown command in that specific PDB:

Check the status of PDB after issuing the shutdown command:

Opening the Database / Starting up the PDB:

Check the status, it is read and write mode:

Shutting down the PDBs at CDB level, we can close and open the PDB at CDB level as well:

Shows us the status that specific PDB has been closed:

Starting up the PDB  at CDB level:

From all the above, it is clear that it comes an easy at PDB level when you are only concern with specific PDB, you can start/stop PDBs individualy but single command. But issuing a command at CDB level, DBA should have to be careful.