ORA-65341: cannot open pluggable database in read/write mode When opening a Refreshable PDB (Doc ID 2900739.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

ALTER PLUGGABLE DATABASE PDB1 REFRESH;

Pluggable database altered.

SQL> connect / as sysdba
Connected.
SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB2 READ WRITE NO
4 PDB1 MOUNTED

SQL> ALTER PLUGGABLE DATABASE PDB1 OPEN;
ALTER PLUGGABLE DATABASE REFRESH_PDB OPEN
*
ERROR at line 1:
ORA-65341: cannot open pluggable database in read/write mode

SQL> ALTER PLUGGABLE DATABASE REFRESH_PDB OPEN READ ONLY;

Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE REFRESH_PDB CLOSE;

Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE REFRESH_PDB OPEN RESETLOGS;
ALTER PLUGGABLE DATABASE REFRESH_PDB OPEN RESETLOGS
*
ERROR at line 1:
ORA-65341: cannot open pluggable database in read/write mode

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.