Container Database (CDB):
Startup and Shutdown in container Database is same like normal instances only.The sql*plus startup and shutdown commands are available when CDB connected as a privileged user.
While normally dbwr database with the command of startup nomount
command: startup nomount
command: shutdown immediate
command: startup force
Pluggable Database (PDB):
Pluggable databases can be started and stopped using SQL*Plus commands or the ALTER PLUGGABLE DATABASE command.
view all pluggable database name and modes with the command
select name, open_mode from v$pdbs;
now we closing all pluggable database with the command
alter pluggable database all close immediate;
alter pluggable database all open; [setting up all PDB open mode]
Trying to close except particular PDB6 with the command
alter pluggable database all except pdb6 close immediate;
Startup with open read write mode with SQL*PLUS command
startup open read write
To set particular PDB5 open with the command
alter pluggable database pdb5 open;
Catch Me On:- Hariprasath Rajaram
FB Page: https://www.facebook.com/dbahariprasath/?