1.Only one table failed to compare:
<
ID Tablename Since Repair
-------- ----------------------------------------------------------------- ------------------ ------
1045034 "WHYBSJ"."YZ_JSJL" 28-Mar-12 11:47:52 Off
Source table : "WHYBSJ"."YZ_JSJL"
Source node :
Target table : "WHYBSJ"."YZ_JSJL"
Target route : whsbjcfx:q1@whybtb
Where clause :
Select hint :
Status : Error
Error connect to whsbjcfx:q1 port 2200.
Check that sp_cop on the target is running.
>
2.It lost lots of data, but no out of sync report. In target, compare client timeout after 1860 seconds.
<
Info 2012-03-29 10:05:11.636493 1950314 1 Compare client launched, pid = 1950314 [sp_declt]
Error 2012-03-29 10:19:58.956203 1495940 1 Compare client: Error timed out occurred after 1860 seconds (sp_declt_wait_for_lockfile,L1373) [sp_declt] [module deq]
Notice 2012-03-29 10:19:58.965801 1495940 1 Compare client: Opened DataEquator session log file /splex/vardir2200/log/whybtb_declt-WHYBSJ-YZ_JSJL-620108-1495940.log [sp_declt] [module deq]
Info 2012-03-29 10:20:02.297196 1250284 1 Compare client exited normally, pid = 1495940 [sp_declt]
Error 2012-03-29 10:36:18.602777 1950314 1 Compare client: Error timed out occurred after 1860 seconds (sp_declt_wait_for_lockfile,L1373) [sp_declt] [module deq]
Notice 2012-03-29 10:36:18.611715 1950314 1 Compare client: Opened DataEquator session log file /splex/vardir2200/log/whybtb_declt-WHYBSJ-YZ_JSJL-849582-1950314.log [sp_declt] [module deq]
Info 2012-03-29 10:36:21.071342 1250284 1 Compare client exited normally, pid = 1950314 [sp_declt]
>
Compare marker lost, since the table is skipped by read param.
set param SP_ORD_SKIP_OBJECT <table_id>
1.Source
sql>select object_id, owner from dba_objects where owner='SPLEX' and object_name='SHAREPLEX_DATAEQUATOR';
sp_ctrl>set param SP_ORD_DEBUG_OBJECT <object_id> --for SHAREPLEX_DATAEQUATOR
sp_ctrl>set param SP_OCT_GEN_DEBUG_OBJID <object_id> --for SHAREPLEX_DATAEQUATOR
sp_ctrl>show read internal
sp_ctrl>show capture detail
sp_ctrl>qstatus
Target
sp_ctrl>set param sp_opo_debug_flag 0x00010000
sp_ctrl>show post detail
sp_ctrl>qstatus
2.compare again
sp_ctrl>reset param SP_ORD_DEBUG_OBJECT
sp_ctrl>reset param SP_OCT_GEN_DEBUG_OBJID
sp_ctrl>reset param sp_opo_debug_flag
3.Check source & target log, confirm DEQ MARKER exist or not
source side:
compare server log
event_log, *ocap*.log, *ord*.log
target side:
compare client log,
event_log
*opo*.log
reset param SP_ORD_SKIP_OBJECT
SP_OPO_DISABLE_OBJECT_NUM may also affect compare.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center