故障背景

数据迁移搭建DG，备库FAILOVER后，删除备库物化视图，主库物化视图增量刷新时发生报错ORA-12034。

故障现象

dg数据库failover后，主库物化视图增量刷新时，报错ORA-12034

SQL> exec dbms_mview.refresh('"XXX"."MV_XXXXX"','f');
BEGIN dbms_mview.refresh('"XXX"."MV_XXXXX"','f'); END;

*
ERROR at line 1:
ORA-12034: materialized view log on "XXX"."XXXXX" younger than last refresh