Error: LogMiner Stream Extraction Error ORA-16331: Container Is Not Open

Issue

The following error appears, where <PDB_NAME> is the name of a Pluggable Database (PDB) in your Oracle database:

LogMiner stream extraction error: ORA-16331: container "<PDB_NAME>" is not open. ORA-06512: at "SYS.DBMS_LOGMNR", line 72 ORA-06512: at line 1

Environment

• Connector: Oracle
• Capture method: LogMiner

Resolution

To resolve this issue, identify the PDBs generating redo records in the mined logs and ensure those PDBs are open.

Cause

When using LogMiner, any PDB that has generated redo records in the log files being mined must be open. This issue occurs when LogMiner encounters redo from a closed PDB, even if the PDB wasn't explicitly specified in the connection setup form.