Forcing the Logging of All Database Changes

Sybase recommends that you enable forced logging of all database changes to the Oracle redo log file to ensure that all data that should be replicated is logged.

  1. In the primary database, execute:
    alter database FORCE LOGGING;
  2. Verify the current setting by executing:
    select force_logging from v$database;