When you activate a configuration, through the activate config command in sp_ctrl, SharePlex does the following:
(Oracle only) Reconciles replicated data with the copied data. SharePlex applies transactions that occurred after the copy was taken and discards transactions that occurred before the copy (and thus were applied by the copy and would be redundant if applied by replication). The reconcile process is only required for procedures that start replication while the source database is active.
Note: A SQL Server source database must be quiesced (no transaction activity allowed) while a configuration is being activated.
The activation of a configuration generally proceeds as follows.
SharePlex assigns an activation ID number to each configuration activation and its associated replication processes and queues. A configuration can be activated many times, and this ID keeps track of each one.
SharePlex builds an object cache that records the standard metadata needed to support replication: the name, size, and type of columns, NOT-NULL constraints, and whether a column is part of a key. For tables using partitioned replication, additional information is stored.
SharePlex places a configuration-change marker in the data stream. This marker directs sp_cop to generate a new set of replication processes and queues. If another configuration is active for the same datasource, the marker deactivates it, causing the removal of the old processes and queues after the data they contain is posted.
(Oracle only) SharePlex locks the tables that are listed in the configuration file so that it can obtain information about them while they are in a read-consistent state. As many tables can be locked concurrently as there are locking threads available. When SharePlex locks a table, it places an activation marker in the data stream that tells the Capture process to start (or stop) replicating that table.
Note: If an application uses NOWAIT locking on tables in the replication configuration, the NOWAIT could fail if it attempts to obtain a lock on an object that is already locked because it is being activated.
SharePlex locks the following:
Each table is locked for a very short time, just long enough to activate a table. Replication of each table begins as soon as its activation is complete. Should one or more table fail to activate, SharePlex continues with the activation of the other tables. Users can access the data in a source table when the activation lock is released.
Use sp_ctrl commands to activate, deactivate and view information about a configuration activation, as well as to reconcile ongoing changes with a copy. For more information about these commands, see the SharePlex Reference Guide.
|Activate a configuration file||
Starts the activation and retains control of the sp_ctrl command line until the activation is finished.
|View configuration statistics||
Shows statistics for active configurations. It displays the status of a configuration (active or inactive), the datasource, the date and time the configuration was activated, and the number of objects that are configured.
|Deactivate a configuration file||
deactivate config or abort config
The purposes of these commands are different, but both deactivate a configuration file.
Deactivating or aborting a configuration stops replication. If users continue making changes to the configured objects, the source and target data can go out of synchronization.
|Reconcile replicated changes with the copy||
(Valid for an Oracle source only) Coordinates the results of ongoing replication with a copy of the source data that is applied to the target system, so that changes that occurred before the copy are discarded.
|View replication status||status
Shows a summary of the status of replication to help you ensure that processes are running and to check for errors, warnings or notices.
|View queue status||
Shows statistics for the capture, post, and export queues.
Activation of a configuration is an event that requires a series of actions to be taken in a timely manner, uninterrupted. Therefore, it is important to have all of your preparations done ahead of time, leaving nothing in question. You can activate a configuration if you performed the minimal requirements outlined in this topic.
Note: These instructions apply to Oracle and SQL Server source databases, unless otherwise noted.
Only a SharePlex Administrator can activate a configuration. Additional users should be assigned to monitor SharePlex and perform basic operational procedures. For more information, see Assign SharePlex users to security groups.
Make certain you satisfy the following prerequisites before you activate a configuration.
|Requirement||Documentation to Read|
|Understand how to start and stop the sp_cop program.||Run SharePlex|
Understand how to issue SharePlex commands.
|Execute commands in sp_ctrl|
Understand the commands you will use during activation.
|Make certain your SharePlex configuration and setup are complete and any optional features are included in the configuration or setup.||Configure data replication|
Prepare the database to support replication.
See "Set up an Oracle environment for replication" in the Installation and Setup Guide for an Oracle Source
|Plan and configure SharePlex to support your replication strategy|
Start the source and target databases.
Unless your applications only generate SharePlex-supported DDL, prevent DDL operations, including TRUNCATE, during activation. Where permitted, DML changes are the only permissible changes during activation.
Before you activate a configuration in production, perform a test activation by using the verify config command. If there are syntax errors, misspellings or duplicate entries in the configuration file, the entire activation will fail.
This command will test the configuration to find and report the following conditions:
The verify config command does not verify how long the activation will take, nor will it verify the target objects or database connection (as represented by the database identifier listed in the routing map.)
For more information, see the verify config command in the SharePlex Reference Guide.