Skip to Main Content

Oracle Database Discussions

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!

Trying to read redo logs. Error - operation not allowed from within a pluggable database

Eugene.sAug 20 2020 — edited Aug 30 2020

Hello.

I want to try to read the redo logs. I do next operation for that in SQL Developer:

BEGIN

    dbms_logmnr.add_logfile ('/u01/app/oracle/oradata/ORCLCDB/redo01.log');

    dbms_logmnr.add_logfile ('/u01/app/oracle/oradata/ORCLCDB/redo02.log');

    dbms_logmnr.add_logfile ('/u01/app/oracle/oradata/ORCLCDB/redo03.log');

END;

/

Eventually, I get the error:

error report -

ORA-65040: operation not allowed from within a pluggable database

ORA-06512: at "SYS.DBMS_LOGMNR", line 82

ORA-06512: at line 2

65040. 00000 -  "operation not allowed from within a pluggable database"

*Cause:    An operation was attempted that can only be performed in the root container.

*Action:   Switch to the root container to perform the operation.

I can't understand, what's the problem. And what I need to do. I've connected to DB with login SYS who has a role SYSDBA.

Thanks in advance for helping.

Comments
Post Details
Added on Aug 20 2020
20 comments
21,659 views