- 28 Mar, 2020
- 0 Comments
- 34 Secs Read
Start and Stop All Pluggable Database
There is way to start and stop all pluggable database. you can also use except keyword if you want to skip or add pluggable database.
STOP all pluggable database.
SQL>ALTER PLUGGABLE DATABASE ALL CLOSE IMMEDIATE;
Pluggable database altered.
START All pluggable database
SQL> ALTER PLUGGABLE DATABASE ALL OPEN READ WRITE;
Pluggable database altered.
EXCEPT Keyword to start specific pluggable database.
SQL> ALTER PLUGGABLE DATABASE ALL EXCEPT PDBPRIM OPEN READ WRITE;
SQL> alter pluggable database all except PDB002,PDBPRIM open;
Note : However, if any of your pluggable databases are in READ ONLY mode, then the statement returns the error “ORA-65019: pluggable database PDBPRIM already open” as you can see.