CDC Setup Guide

Step 1: Enable supplemental logging

-- Enable at database level (DBA privilege required)
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

-- Enable ALL COLUMNS logging per table
ALTER TABLE HR.EMPLOYEES    ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
ALTER TABLE HR.DEPARTMENTS  ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
ALTER TABLE SALES.ORDERS    ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

-- Verify
SELECT LOG_MODE, SUPPLEMENTAL_LOG_DATA_MIN,
       SUPPLEMENTAL_LOG_DATA_ALL
FROM   V$DATABASE;

Step 2: Grant required privileges

-- Grant LogMiner privileges to your migration user
GRANT SELECT ON V_$DATABASE        TO migret_user;
GRANT SELECT ON V_$LOGMNR_CONTENTS TO migret_user;
GRANT SELECT ON V_$LOGFILE         TO migret_user;
GRANT EXECUTE ON DBMS_LOGMNR       TO migret_user;
GRANT EXECUTE ON DBMS_LOGMNR_D     TO migret_user;

Step 3: Record the start SCN

Run this before starting the bulk migration. The SCN is your CDC resume point.

SELECT CURRENT_SCN, TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS') AS captured_at
FROM   V$DATABASE;
-- Example output: 4829103  |  2026-04-20 08:15:33
-- Save 4829103 — use it as start_scn in CDC config

Step 4: Configure in DBMigrateAIPro

In the CDC panel, enter the SCN captured in Step 3. Select the tables to stream.

Enable binary logging (my.cnf)

[mysqld]
log_bin         = /var/log/mysql/mysql-bin.log
binlog_format   = ROW
binlog_row_image = FULL
server_id       = 1        # must be unique across replicas
expire_logs_days = 7       # keep 7 days of binlogs

Grant replication privilege

GRANT REPLICATION SLAVE ON *.*  TO 'migret_user'@'%';
GRANT SELECT ON your_db.*       TO 'migret_user'@'%';
FLUSH PRIVILEGES;