In the Mirror Activator system, the Mirror Replication Agent must control the secondary truncation point in the primary database. This requires you to stop and disable the Replication Agent thread in the primary database when you convert an existing warm standby application to a Mirror Activator system.
WARNING! You must use the preserve secondary truncpt option when you execute sp_config_rep_agent to disable the Replication Agent thread. If you do not preserve the secondary truncation point in the primary database, you must rematerialize the standby database before you resume replication to prevent data loss.
Stopping and disabling the Replication Agent thread
Log in to the primary database with a system administrator user role.
Stop the Replication Agent thread in the primary database:
use pdb sp_stop_rep_agent pdb
where pdb is the name of the primary database.
Disable the Replication Agent thread in the primary database:
sp_config_rep_agent pdb, ’disable’, ’preserve secondary truncpt’
where pdb is the name of the primary database.
Disabling the ASE Replication Agent thread allows the Mirror Replication Agent to reserve the logscan context in the primary database.
