Resync target database with cold backup from source.
Shareplex for Oracle all versions: When most of the tables go out of sync and if database is not running in archive log mode, you can resync the target database by using coldbackup of source.
Re sync the target database with source by using coldbackup of Source database.
1) sp_cop should be running on source and target 2) Quiet the source database (ie: svrmgrl>shutdown immediate svrmgrl> startup restrict). 3) Issue flush command on source (sp_ctrl> flush o.SID) 4) wait till messages have emptied from the capture queue and export queue on source sp_ctrl> qstatus 5) Once the number of messages becomes zero in capture and export queues, you can shutdown source database completely svrmgrl>shutdown 6) perform cold backup on source. 7) Now you can allow users access source database. 8) Wait till post process "stopped due to flush" on target system sp_ctrl> qstatus 9) Build your target database by using cold backup from source. 10) Disable all triggers , RI constraints and check constraints as needed in target database. 11) Start post process on target.
When messages in post queue have posted, your databases will be in sync.