The following errors are observed “compare force” is issued on a table that exists in the source and target database and is not a part of replication:
sp_ctrl (source_server:5438)> compare sha90.table1e force
Cannot compare "SHA90"."TABLE1E", required information is missing
Missing target host name
Missing target SID
comparing 0 of 1 objects
1 object(s) contain errors
No objects to compare; no job started.
When running a compare with “force” option, it is imperative that at the very least the target routing info be provided.
If target table name is not provided, it is assumed that it is same name as that of the source table.
The “force” option is dealing with tables not forming part of the active config. So it is required to specify the route of the target table so that compare can correctly ascertain the target table.
Here is the correct way to run compare with “force” option:
sp_ctrl (source_server:5438)> compare sha90.table1e at target_server@o.target_sid force
comparing 1 of 1 objects
compare started; job id 3
sp_ctrl (source_server:5438)> job status
Job ID : 3
PID : 13264
Host : source_server
Started : 14-JUL-17 19:16:03
Job Type : Compare
Status : Done - 1 object completed
ID Tablename Status Time Total Rows %Comp Total Time
------ ------------------------------------ ---------- ---------- ---------- ----- ----------
1 "SHA90"."TABLE1E" Out Sync N/A 2 100 0:05
