A Singer Tap for Oracle

LogMiner is one of the sync strategies. You must enable supplemental logging before turning on LogMiner in the Oracle database

 begin
 rdsadmin.rdsadmin_util.alter_supplemental_logging(
   p_action => 'ADD');
 end;

begin
    rdsadmin.rdsadmin_util.set_configuration(
        name  => 'archivelog retention hours',
        value => '24');
end;

QL> exec rdsadmin.rdsadmin_util.show_configuration; NAME:tracefile retention VALUE:10080 DESCRIPTION:tracefile expiration specifies the duration in minutes before tracefiles in bdump are automatically deleted. NAME:archivelog retention hours VALUE:24 DESCRIPTION:ArchiveLog expiration specifies the duration in hours before archive/redo log files are automatically deleted. /

Copyright © 2018 Stitch