Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-10887: An Oracle Active Data Guard license is required to open a pluggable

Marek LällNov 6 2019 — edited Nov 6 2019

Hi,

Problem:

As i did not find any useful references about when ORA-10887 is raised or how to enter "Active Data Guard license" to make that error disappear ...

Symptoms:

1) Messages in alert.log during physical standby database startup or during switchover:

ORA-10887: An Oracle Active Data Guard license is required to open a pluggable database while standby recovery is applying changes.

ORA-10887 signalled during: ALTER PLUGGABLE DATABASE ALL OPEN...

2) Message while trying to open pluggable database manually on physical standby database:

SQL> alter pluggable database XXX open read only;

alter pluggable database XXX open read only

*

ERROR at line 1:

ORA-10887: An Oracle Active Data Guard license is required to open a pluggable

database while standby recovery is applying changes.

Configuration bits:

sql> select OPEN_MODE, DATABASE_ROLE from v$database;

OPEN_MODE              DATABASE_ROLE

READ ONLY WITH APPLY   PHYSICAL STANDBY

sql> select VERSION_FULL, STATUS, EDITION from v$instance;

VERSION_FULL   STATUS   EDITION

19.5.0.0.0     OPEN     EE

Regards,

Marek Läll

Comments
Post Details
Added on Nov 6 2019
3 comments
676 views