CDC - Oracle Setup Documentation

    CONNECT sys/<password> AS SYSDBA

    GRANT CREATE SESSION TO <username>;
    GRANT EXECUTE_CATALOG_ROLE TO <username>;
    GRANT SELECT ON V_$DATABASE TO <username>;
    GRANT FLASHBACK ANY TABLE TO <username>;
    GRANT SELECT ANY TABLE TO <username>;
    GRANT EXECUTE_CATALOG_ROLE TO <username>;
    GRANT SELECT ANY TRANSACTION TO <username>;
    GRANT LOGMINING TO <username>;
    GRANT CREATE SESSION TO <username>;
    GRANT EXECUTE_CATALOG_ROLE TO <username>;
    GRANT SELECT ON V_$DATABASE TO <username>;
    GRANT FLASHBACK ANY TABLE TO <username>;
    GRANT SELECT ANY TABLE TO <username>;
    GRANT EXECUTE_CATALOG_ROLE TO <username>;
    GRANT SELECT ANY TRANSACTION TO <username>;
    GRANT LOGMINING TO <username>;
    GRANT CREATE TABLE TO <username>;
    GRANT LOCK ANY TABLE TO <username>;
    GRANT CREATE SEQUENCE TO <username>;
    GRANT EXECUTE ON DBMS_LOGMNR TO <username>;
    GRANT EXECUTE ON DBMS_LOGMNR_D TO <username>;
    GRANT SELECT ON V_$LOG TO <username>;
    GRANT SELECT ON V_$LOG_HISTORY TO <username>;
    GRANT SELECT ON V_$LOGMNR_LOGS TO <username>;
    GRANT SELECT ON V_$LOGMNR_CONTENTS TO <username>;
    GRANT SELECT ON V_$LOGMNR_PARAMETERS TO <username>;
    GRANT SELECT ON V_$LOGFILE TO <username>;
    GRANT SELECT ON V_$ARCHIVED_LOG TO <username>;
    GRANT SELECT ON V_$ARCHIVE_DEST_STATUS TO <username>;
    GRANT SELECT ON V_$TRANSACTION TO <username>;
    GRANT SELECT ON V_$MYSTAT TO <username>;
    GRANT SELECT ON V_$STATNAME TO <username>;

    EXIT;

    CONNECT sys/<password> AS SYSDBA

    ALTER SYSTEM SET db_recovery_file_dest_size = 10G;
    ALTER SYSTEM SET db_recovery_file_dest = '/opt/oracle/oradata/recovery_area' scope=spfile;
    SHUTDOWN IMMEDIATE;
    STARTUP MOUNT;
    ALTER DATABASE ARCHIVELOG;
    ALTER DATABASE OPEN;

    -- Should now "Database log mode: Archive Mode"
    ARCHIVE LOG LIST

    EXIT;

   ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

   ALTER TABLE <schema>.<table> ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;