| 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 Sync Continuous Sync |
| Authentication Type | Password Authentication |
Supported Versions
- Oracle Database 11g Release 2 and above
- Oracle 12c, 18c, 19c, 21c
Variants
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