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.
Only a SharePlex Administrator can activate a configuration. Additional users should be assigned to monitor SharePlex and perform basic operational procedures. For more information about SharePlex user groups and authorization levels, 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. | Create configuration files
Configure partitioned replication |
Prepare the database to support replication. |
|
Plan and configure SharePlex to support your replication strategy | |
Start the source and target databases. |
Database documentation |
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. |
Database documentation |
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.
During activation, SharePlex gets the information it needs to identify and understand the objects that are configured for replication and build routing maps. For more information, see What is activation?.
The length of time that activation takes varies, depending on the size, number and structure of the configured objects.
No. The definition of objects cannot be changed during activation.
No. You can create as many configurations for the same source data, but only one of those can be active at the same time.
Yes. See How to activate multiple configuration files.
Yes. This is highly recommended. Use the verify config command. See Requirements for activating a configuration.
No. Activation is meant to be an uninterrupted procedure that initiates replication while maintaining the same series of transactional events as those appearing in the redo log. You can use the abort config command to terminate an activation, but you may then need to clean out the queues and resynchronize the source and target data again. Ideally, you should have a tested configuration file ready to be activated and be prepared to issue commands to the database and to SharePlex.
Yes. The Oracle database must be mounted and open, however.
Yes. The number of threads is controlled globally by the SP_OCF_THREAD_COUNT parameter, which must be set before you issue the activate config command. You can override this value for a particular activation by using the threads option when you issue the activate config command.
You can activate one configuration per datasource on a system. For example, if there are ConfigA, ConfigB and ConfigC for the same datasource, you can activate only one of them at a time. Activating another configuration for the same datasource automatically deactivates the first one.
However, if ConfigA replicates data from one datasource, while ConfigB replicates data from a different datasource, you can activate both of those configurations at the same time. Replication for those configurations can operate concurrently.
To activate multiple configuration files
The activation process retains control of the sp_ctrl interface until the activation is finished. Because an activation can take a significant amount of time, you can activate different configurations in different sessions of sp_ctrl. Activate the first configuration, then open another session of sp_ctrl to activate the second one. Open as many sessions of sp_ctrl as you have configurations to activate.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy