oracle 只读切换到读写,12cR1 PDB只读与读写转换

PDB只读与读写转换

1、pdb 到mount状态

SQL> alter pluggable database pdb11 close immediate;

Pluggable database altered.

2、查看pdb

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB11 MOUNTED

SQL>

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 NO

SQL> 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 NO

SQL>