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
command: startup
Pluggable Database (PDB):
Pluggable databases can be started and stopped using SQL*Plus commands or the ALTER PLUGGABLE DATABASE command.
step 1:
view all pluggable database name and modes with the command
select name, open_mode from v$pdbs;
step 2:
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
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba