12cR1 PDB只读与读写转换

PDB只读与读写转换

1、pdb 到mount状态SQL> alter pluggable database pdb11 close immediate;Pluggable database altered.2、查看pdbSQL> show pdbs;    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         2 PDB$SEED                       READ ONLY  NO         3 PDB11                          MOUNTEDSQL> 3、pdb只读SQL> SQL> alter pluggable database pdb11 open read only;Pluggable database altered.SQL> show pdbs;    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         2 PDB$SEED                       READ ONLY  NO         3 PDB11                          READ ONLY  NOSQL> alter pluggable database pdb11 close immediate;Pluggable database altered.4、pdb读写SQL> alter pluggable database pdb11 open read write;Pluggable database altered.SQL> show pdbs;    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         2 PDB$SEED                       READ ONLY  NO         3 PDB11                          READ WRITE NOSQL>