2028: invalid enable marker in log

Symptoms

These error messages are displayed in the LTM error log:

E. 96/09/11 16:40:09. ERROR #2028 logscan thread(ost_ra.pub) - /ltmscan. c(2616) Message from server: Message: 9141, State 1, Severity 16 -- ‘The stored proc. ‘rs_marker’ associated with the EXECBEGIN log record in database ‘pub’, XA CT ID Rid pageid = 0x1cb; row num = 0x2, RID Rid pageid = 0x1cb; row num = 0x3, was dropped after the log record was written.  The EXECBEGIN log record is not replicated.’.

Explanation

If you reinstall the active database while replication to a warm standby is in progress, an invalid enable marker may be left in the log. During the reinstallation, system-defined stored procedures (such as rs_marker and rs_update_lastcommit) are re-created and overwrite the stored procedures created during the initial installation. As a result, the rs_marker value changes and the standby database waits for a marker that never arrives.

Solution

Drop the active and standby connections and reinstall the databases.