On 29 Jul 2009, at 14:27, Rajakumar Velu wrote:
> 9. Applied all resent logs at DB4
> 10. Restarted the instance at DB4
> 11. Started sync
> 12. Tested with different queries whether all data in a specific Table
> in DB4 & DB5 are same or not : Test Failed
> after all we had additional records on the DB4 which is not available
> on the DB5, we don't know how it's coming.
Out of all those it seems likely that it's step 9 that's introducing
data that's not on db5. You should generate some kind of diff so that
you can apply the differences back to db5. Alternatively, look at
maatkit which can resync out of sync tables through a replicated link.
Attachment: [application/pkcs7-signature] smime.p7s