Disabling replication for DDL

StepsDisabling replication for DDL in the primary database

  1. Log in to the Mirror Replication Agent administration port.

  2. Use the pdb_setrepddl command without an argument to determine if replication is already disabled for DDL in the primary database:

    pdb_setrepddl
    

    If the pdb_setrepddl command returns information that replication is disabled, you do not need to continue this procedure.

    If the pdb_setrepddl command returns information that replication is enabled for DDL, continue this procedure to disable replication for DDL.

  3. Use the pdb_setrepddl command to disable replication for DDL:

    pdb_setrepddl disable
    

    After replication is disabled for the DDL, you can resume replicating your primary database.

    See the Mirror Replication Agent Primary Database Guide for details specific to your primary database.