Starting a Replicate
About this task
When
you define a replicate, the replicate does not begin until you explicitly
change its state to active. When a replicate is active, Enterprise Replication captures
data from the logical log and transmits it to the active participants.
At least two participants must be active for data replication to occur.
Important: You cannot start replicates that
have no participants.
To change the replicate state
to active, use the cdr start replicate command. For example,
to start the replicate sales_data on the servers server1 and server23,
enter:
sales_data server1 server23This command causes server1 and server23 to start sending data for the sales_data replicate.
If you omit the server names, this command starts the replicate on all servers that are included in that replicate.
When you start a replicate, you can choose to perform an initial data synchronization, as described in Initially Synchronizing Data Among Database Servers.
Warning: Run the cdr start replicate command
on an idle system (no transactions are occurring) or use the BEGIN
WORK WITHOUT REPLICATION statement until after you successfully start
the replicate.
When replication is active on an instance, you may need to double the amount of lock resources, to accommodate transactions on replicated tables.
If a replicate belongs to an exclusive replicate set, you must start the replicate set to which the replicate belongs. For more information, see Starting a Replicate.
For more information, see cdr start replicate.