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.

Share and Enjoy !

0Shares
0 0 0

Leave a Comment

Your email address will not be published. Required fields are marked *