Oracle GoldenGate Error Messages

OGG-30550

The WAL retention parameter cannot be determined. Make sure that the WAL retention parameter such as 'log_min_seconds_to_retain', 'log_min_segments_to_retain' and 'log_segment_size_mb' are set appropriately to retain the log segments and avoid the data loss when extract is down.


Cause

The WAL retention parameter set at the database level cannot be determined in the database.


Action

Configure yb-tserver to have the log_min_seconds_to_retain=86400 and log_min_segments_to_retain=4, also configure log_segment_size_mb=128 or more to retain the log data in case the OGG Extract process is down.