逻辑复制延时是让数据库复制运维中十分头痛的问题。有个朋友问老白,他发现LOGMINER出来的UPDATE语句与生产端的原语句差别比较大,比如下面的语句,原语句是:
UPDATE F_XXX_BACKUP SET TALLY_REMARK = 'WIAO' WHERE ACCT_ID = :B1 |
update "XXPAY"."F_XXX_BACKUP" set"TALLY_REMARK" = 'WIAO' where "BACKUP_ID" = '000000154720'and "TALLY_REMARK" = 'WIAO' and ROWID = 'AAAL8YAAKAAA9y2AAe'; |