This topic contains procedures for making backups of source and target data while replication is active.
This topic contains procedures for making backups of source and target data while replication is active.
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.
Oracle
All targets
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.
On the target system, start the Post process.
sp_ctrl> start post
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.
Oracle to all targets
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.
Shut down SharePlex. This command shuts down SharePlex.
sp_ctrl> shutdown
Perform the backup.
Verify that the SharePlex Capture, Read, and Export processes started.
sp_ctrl> status
Start Post.
sp_ctrl> start post
Verify that Post started.
sp_ctrl> status
Use the following resources from the Quest Support Portal to help you troubleshoot SharePlex.
See also, Prevent and solve replication problems.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center