When a sequence is marked for replication, changes to that sequence against sys.seq$ are captured and sent to Replication Server in the form of parameters passed to a procedure. The procedure (rs_update_sequence) must be installed at the standby site as part of system setup, as well as a function replication definition for that procedure. At the standby site, an implementation of rs_update_sequence will increment a same-named sequence until its value is equal to that at the primary.Scripts are provided to create the rs_update_sequence stored procedure and function replication definition. The scripts can be found in the Mirror Replication Agent installation as:
$SYBASE/MRO-12_6/scripts /oracle_create_replicate_sequence_proc.sql$SYBASE/MRO-12_6/scripts /oracle_create_rs_sequence_repdef.sql
