Log in to the Mirror Replication Agent instance with the administrator login.
Use the pdb_setrepseq command to confirm that the sequence is marked in the primary database:
pdb_setrepseq pdb_seq
Here, pdb_seq is the name of the sequence that you want to unmark.
Consider the following:
If the pdb_setrepseq command returns information that the specified sequence is marked, continue this procedure to unmark the sequence.
If the pdb_setrepseq command does not return information that the specified sequence is marked, you do not need to continue this procedure.
Use the pdb_setrepseq command to disable replication of the sequence:
pdb_setrepseq pdb_seq, disable
Here, pdb_proc is the name of the sequence that you want to unmark.
Use the pdb_setrepseq command to remove the replication marking from the sequence:
pdb_setrepseq pdb_seq, unmark
Here, pdb_seq is the name of the sequence that you want to unmark.
If you need to force the unmark, you can use the following command:
pdb_setrepseq pdb_seq, unmark, force
Use the pdb_setrepseq command to confirm that the sequence is no longer marked for replication:
pdb_setrepseq pdb_seq
Here, pdb_seq is the name of the sequence in the primary database that you unmarked.