CONTINUE REPLICATING

Syntax

To resume replication from the master aggregator in the Disaster Recovery (DR) secondary cluster, use the following syntax:

CONTINUE REPLICATING <database_name>;

Remarks

• CONTINUE REPLICATING can only be used to resume replication from the primary database on the remote host that was specified when REPLICATE DATABASE was originally run.

• This command causes implicit commits. Refer to COMMIT for more information.

• If the master aggregator fails on the DR secondary cluster, you can either restart the master aggregator node successfully, or pick a child aggregator to promote to master. Then, run CONTINUE REPLICATING on the master aggregator.

• Refer to the Permission Matrix for the required permission.

Example

CONTINUE REPLICATING ExampleDatabase;
Query OK, 1 row affected (0.26 sec)