To mark a sequence for replication
Log in to the Replication Agent instance with the administrator login.
Use the pdb_setrepseq command to determine if the sequence is already marked in the primary database:
pdb_setrepseq pdb_seq
where pdb_seq is the name of the sequence in the primary database that you want to mark for replication.
If the pdb_setrepseq command returns information that the specified sequence is marked, you do not need to continue this procedure.
If the pdb_setrepseq command returns information that the specified sequence is not marked, continue this procedure to mark the sequence for replication.
To mark a stored procedure for replication
Log in to the Replication Agent instance with the administrator login.
Use the pdb_setrepproc command to determine if the stored procedure is already marked in the primary database:
pdb_setrepproc pdb_proc
where pdb_proc is the name of the stored procedure in the primary database that you want to mark for replication.
Consider the following:
If the pdb_setrepproc command returns information that the specified stored procedure is marked, you do not need to continue this procedure.
If the pdb_setrepproc command returns information that the specified stored procedure is not marked, continue this procedure to mark the stored procedure for replication.
Use the pdb_setrepseq command to mark the sequence for replication.
The pdb_setrepseq command allows you to mark the primary stored procedure to be replicated and specify a different sequence name to use in the replicate database.
Use the following command to mark the sequence for replication when the sequence name you wish to increment at the standby site has a different name:
pdb_setrepseq pdb_seq, mark
where pdb_seq is the name of the sequence in the primary database that you want to mark for replication.
Replicating a sequence with a different name is provided
to be consistent with other marking commands, but is not a typical configuration.
Use the following command to mark the sequence for replication using a different sequence name:
pdb_setrepseq pdb_seq, rep_seq, mark
where:
pdb_seq is the name of the sequence in the primary database that you want to mark for replication.
rep_seq is the name of the sequence in the standby database that you wish to increment.
Replicating sequence values to a sequence with a different name
at the standby site assumes the standby site's sequence has the same
attributes and starting value as the primary site's sequence.
Consider the following:
If the value of the pdb_dflt_object_repl parameter is true, the sequence marked for replication with the pdb_setrepseq command is ready for replication after you invoke the pdb_setrepseq command successfully.
If the value of the pdb_dflt_object_repl parameter is true (the default value), you can skip step 4 in this procedure.
If the value of the pdb_dflt_object_repl parameter is false, you must enable replication for the sequence before replication can take place.
Use the pdb_setrepseq command to enable replication for the marked sequence:
pdb_setrepseq pdb_seq, enable
where pdb_seq is the name of the marked sequence for which you want to enable replication.
After replication is enabled for the sequence, you can begin replicating invocations of that sequence in the primary database.
