Prerequisites
To setup CDC between your Oracle database and Peaka Big Table, you need:- Oracle Database (12c, 19c, 21c)
- Oracle administrative permissions (SYSDBA)
Setup Instructions
Preparing the database
Configuration needed for Oracle LogMiner Create a database user for Peaka’s exclusive use that can perform CDC operations. (Although, by default, SYSDBA users have all necessary privileges, you can create another user that has the minimum required privileges.) To provide a user with CDC permissions, grant the following privileges to the user:SYS
or SYSTEM
user accounts.
Enable supplemental logging for the tables you want to replicate
Configure Oracle Database for CDC
- Enable ARCHIVELOG mode for the database:
- Enable supplemental logging at the database level:
- Enable minimal supplemental logging for the tables you want to monitor:
Schemas excluded from capture
When the Debezium Oracle connector captures tables, it automatically excludes tables from the following schemas:appqossys
audsys
ctxsys
dvsys
dbsfwuser
dbsnmp
qsmadmin_internal
lbacsys
mdsys
ojvmsys
olapsys
orddata
ordsys
outln
sys
system
vecsys
(Oracle 23+)wmsys
xdb