Open refreshable pdb in read write mode

In this post, we can refresh the PDB in read write mode.

SQL> alter pluggable database p1_clone open read only;

Pluggable database altered.

SQL> alter pluggable database p1_clone close immediate;

Pluggable database altered.

SQL> alter pluggable database p1_clone open read write;
alter pluggable database p1_clone open read write
*
ERROR at line 1:
ORA-65341: cannot open pluggable database in read/write mode


SQL> alter pluggable database p1_clone refresh mode none;
alter pluggable database p1_clone refresh mode none
*
ERROR at line 1:
ORA-65118: operation affecting a pluggable database cannot be performed from
another pluggable database


SQL> alter session set container=p1_clone;

Session altered.

SQL> show con_name

CON_NAME
------------------------------
P1_CLONE
SQL> alter pluggable database refresh mode none;

Pluggable database altered.

SQL> alter pluggable database open read write;

Pluggable database altered.

SQL> 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp