生产环境OGG 复制进程abend。
ggserr.log 报错Warning OGG-01154 SQL error 14402 OCI error-14402 updating partition key cilumn would cause a partition change (status = 14402)。
MOS 1461706.1
Row movement is disabled by default and the update is about to cause a row to move from one partition to other and thus the error.
解决方法
The solution would be to enable ROW MOVEMENT and restart the replicat
ALTER TABLE . ENABLE ROW MOVEMENT;
总结:update 数据时从一个分区更新到另一个分区,没有开启行迁移,导致错误。开启行迁移,重启复制进程解决。