Name Oracle Description Oracle Database is a multi-model database management system produced by Oracle Corporation Link https://www.oracle.com/database/ Type LogMiner CDC Supported Replication Initial SyncContinuous Sync Authentication Type Password Authentication Supported Versions Oracle Database 11g Release 2 and above Oracle 12c, 18c, 19c, 21c Variants AWS RDS Oracle Self Hosted Required Privileges Name Description Enforced? Reference EXECUTE ON DBMS_LOGMNR Execute LogMiner package for reading redo logs ✅ Oracle Docs EXECUTE ON DBMS_LOGMNR_D Execute LogMiner dictionary package ✅ Oracle Docs SELECT ON V_$LOG Query redo log information ✅ SELECT ON V_$LOGFILE Query redo log file locations ✅ SELECT ON V_$LOGMNR_CONTENTS Query LogMiner results ✅ SELECT ON V_$LOGMNR_LOGS Query LogMiner registered logs ✅ SELECT ON V_$ARCHIVED_LOG Query archived redo logs ✅ SELECT ON V_$DATABASE Query database information ✅ SELECT ON V_$INSTANCE Query instance information ✅ SELECT ON DBA_OBJECTS Query database objects metadata ✅ SELECT ON DBA_TABLES Query table metadata ✅ SELECT ON DBA_TAB_COLUMNS Query column metadata ✅ SELECT ON DBA_CONSTRAINTS Query constraint metadata ✅ SELECT ON DBA_CONS_COLUMNS Query constraint column metadata ✅ SELECT ON DBA_LOG_GROUPS Query supplemental log groups ✅ SELECT ON DBA_LOG_GROUP_COLUMNS Query supplemental log group columns ✅ SELECT ANY TABLE Select from source tables ✅ LOGMINING Oracle 12c+ privilege for LogMiner access ✅ Required Configurations Name Description Recommended Value Enforced? Reference ARCHIVELOG Mode Database must be in ARCHIVELOG mode to enable redo log archiving for LogMiner Enabled ✅ Oracle Docs Supplemental Logging (Database) Minimal supplemental logging at database level ALTER DATABASE ADD SUPPLEMENTAL LOG DATA ✅ Oracle Docs Supplemental Logging (Primary Key) Primary key supplemental logging for row identification ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS ✅ Supplemental Logging (Table) Table-level supplemental logging for each synced table ALTER TABLE schema.table ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS ✅ Archive Log Retention (RDS) Hours to retain archived redo logs 24 hours minimum AWS Docs Notes LogMiner reads redo logs to capture INSERT, UPDATE, DELETE operations CLOB/BLOB columns are automatically converted to strings/buffers
