OGG 的rep进程崩溃报错ORA-01732(OGG不支持复制不可更新的物化视图)

OGG 的rep进程崩溃报错ORA-01732(OGG不支持复制不可更新的物化视图)

一、问题描述

• 最近遇到的迁移项目，使用的是OGG进行迁移，在REP进程运行是发现报错ORA-01732

  
  2025-02-21 22:22:10  WARNING OGG-01004  Aborted grouped transaction on HT_XXXX.V_DK_BED_INFO, Database error 1732 (OCI Error ORA-01732: data manipulation operation not legal on this view (status = 1732), SQL <DELETE /
  *+ RESTRICT_ALL_REF_CONS */ FROM "HT_XXXX"."V_DK_BED_INFO"  WHERE "BED_BEDSN" = :b0 AND "AREA_SN" = :b1 AND "ROOM_ROOMSN" is NULL AND ROWNUM = 1>).
  
  2025-02-21 22:22:10  WARNING OGG-01003  Repositioning to rba 416466034 in seqno 42.
  

• RESTRICT_ALL_REF_CONS */ FROM "HT_XXXX"."V_DK_BED_INFO" WHERE "BED_BEDSN" = :b0 AND "AREA_SN" = :b1 AND "ROOM_ROOMSN" is NULL AND ROWNUM = 1>.

  查询mos文档【GoldenGate Replicat Fails With SQL Error 1732 Mapping on Materialized View (文档 ID 1381948.1)】

• 发现发现OGG仅支持可更新的Materialized View，不支持不可更新的Materialized View

二、问题验证

查询验证该对象是不是可更新的物化视图

SELECT MVIEW_NAME, UPDATABLE
FROM DBA_MVIEWS
WHERE MVIEW_NAME = 'V_DK_BED_INFO';


--输出：这里的N代表不可更新
MVIEW_NAME      UPDATABLE
V_DK_BED_INFO      N

三、问题解决

edit params rp1
--最后添加 
mapexclude "HT_HOSPITAL"."V_DK_BED_INFO" ;

--重启进程
start rp1 

参考：GoldenGate Replicat Fails With SQL Error 1732 Mapping on Materialized View (文档 ID 1381948.1)

本文由mdnice多平台发布