Configuring Warm Standby Database for SQL Replication

By default, warm standby applications do not replicate the DML commands that support SQL statement replication. You need to perform extra configuration to use SQL replication.

Perform one of these to use SQL replication:

Create table replication definitions using replicate SQLDML and send standby clauses.
Set the WS_SQLDML_REPLICATION parameter to on. The default value is UDIS. However, WS_SQLDML_REPLICATION has a lower precedence than the table replication definition for SQL replication. If your table replication definition contains a send standby clause for a table, the clause determines whether or not to replicate the DML statements, regardless of the WS_SQLDML_REPLICATION parameter setting.