When you unmark a stored procedure, Replication Agent removes the transaction log objects that were created when the stored procedure was marked. For non-RASD instances, Replication Agent must be in Admin state when you are unmarking a stored procedure.
For Oracle, DDL replication must be disabled during
the unmarking of stored procedures. See “Disabling replication for DDL”.
To unmark a stored procedure
Log in to the Replication Agent instance with the administrator login.
Use the pdb_setrepproc command to confirm that the stored procedure is marked in the primary database:
pdb_setrepproc pdb_proc
where pdb_proc is the name of the stored procedure that you want to unmark.
If the pdb_setrepproc command returns information that the specified stored procedure is marked, continue this procedure to unmark the stored procedure.
If the pdb_setrepproc command does not return information that the specified stored procedure is marked, you do not need to continue this procedure.
Use the pdb_setrepproc command to disable replication of the stored procedure:
pdb_setrepproc pdb_proc, disable
where pdb_proc is the name of the stored procedure that you want to unmark.
Use the pdb_setrepproc command to remove the replication marking from the stored procedure:
pdb_setrepproc pdb_proc, unmark
where pdb_proc is the name of the stored procedure that you want to unmark.
If you need to force the unmark, you can use the following command:
pdb_setrepproc pdb_proc, unmark, force
Use the pdb_setrepproc command to confirm that the stored procedure is no longer marked for replication:
pdb_setrepproc pdb_proc
where pdb_proc is the name of the stored procedure in the primary database that you unmarked.
You can unmark all marked stored procedures in the primary database by invoking the pdb_setrepproc command with the all keyword.
If your stored procedure is in Oracle and you disabled
DDL replication during stored procedure unmarking, remember to re-enable
DDL replication. See “Enabling replication for DDL”.
