SharePlex 9.2.6 - Administration Guide

Apply patch to source and replicate it to the target

Supported databases

Oracle on all supported platforms

When to use this procedure

Use this procedure if all of the operations applied by a patch or upgrade are supported by SharePlex and can be replicated to the target. This includes DML changes and DDL that is supported by SharePlex. If you are not sure whether the patch or upgrade performs operations that are not supported by SharePlex, use the procedure Apply patch/upgrade to source then copy it to target.

Note: For a list of operations that SharePlex supports, see the SharePlex Release Notes.

Apply the patch/upgrade

1. Stop user access to the Oracle instances on the source and target systems.

2. On the source system, flush the data to the target system. This command stops Post and places a marker in the data stream that establishes a synchronization point between source and target data.

   sp_ctrl> flush datasource

   where: datasource is the datasource of the source instance, for example o.oraA.

3. On the source system, apply the patch or upgrade.
4. On the source system, restore user access to the source instance.
5. On the target system, if the patch or upgrade created or modified triggers, disable them or run the sp_add_trigger.sql utility script so that the triggers ignore the SharePlex user.
6. On the target system, restore user access to the target instance.

Back up Oracle data on the source or target

This topic contains procedures for making backups of source and target data while replication is active.

Contents

Perform a partial backup of the source system

To perform a partial back up of a source system (for example, to extract data or populate a data warehouse) while data is being replicated, you can perform the partial backup on the target system instead and copy the same data as you would on the source system.

This procedure does not interrupt user access to the source data and does not deactivate or reactivate the configuration file.

Supported databases

Oracle

All targets

Procedure

1. On the source system, start sp_ctrl.

2. On the source system, flush the data to the target system. This command stops the Post process and places a marker in the data stream that establishes a synchronization point between source and target data.

   sp_ctrl> flush datasource

   where: datasource is the datasource specification of the source database in the configuration file, for example o.ora1.

3. On the target system, back up the data. Note: The data now matches the source data at the flush marker.

4. On the target system, start the Post process.

   sp_ctrl> start post

Perform a full backup on the source system

To back up the entire source system, including SharePlex, you must shut down SharePlex replication while the backup is performed.

This procedure stops user access to the source data but does not deactivate or reactivate the configuration file. Replication resumes when started after the backup.

Supported databases

Oracle

All targets

Procedure

Perform these steps on the source system:

1. Stop all system activity.
2. Start sp_ctrl.

3. Flush the data to the target system. This command stops the Post process and places a marker in the data stream that establishes a synchronization point between source and target data.

   sp_ctrl> flush datasource

   where: datasource is the datasource specification of the source database in the configuration file, for example o.ora1.

4. Shut down SharePlex. This command shuts down SharePlex.

   sp_ctrl> shutdown

5. Shut down the database.

6. Perform the backup.

7. Start the database.
8. Start sp_cop (Unix and Linux) or the SharePlex service (Windows).
9. Start sp_ctrl.
10. Allow users to access the database.

11. Verify that the SharePlex Capture, Read, and Export processes started.

    sp_ctrl> status

Perform these steps on the target system:

1. Start Post.

   sp_ctrl> start post

2. Verify that Post started.

   sp_ctrl> status