Database Software

Version:12.1.0.2 OS:

RHEL 6.1

Hi Gurus, I'm not able to open pdb in read-only mode on standby getting below error.

SQL> alter database recover managed standby database disconnect from session using current logfile;

Database altered.

SQL> select process,status,thread#,sequence#,blocks from gv$managed_standby where process like '%MRP%';

PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCKS

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

MRP0      WAIT_FOR_LOG          2         45          0

SQL> alter pluggable database TST11GPDB open read only;

alter pluggable database TST11GPDB open read only

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-16000: database or pluggable database open for read-only access

SQL> select name,open_mode,recovery_status from v$pdbs;

NAME                           OPEN_MODE  RECOVERY

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

PDB$SEED                       READ ONLY  ENABLED

TST11GPDB                      MOUNTED    ENABLED

Any suggestion would be helpful as always.

Thanks