ORA-26687: no instantiation SCN

1. 流复制目标数据库apply进程出现错误如下：

STRMADMIN_APPLY  ORA-26687: no instantiation SCN provided
for "chenhao"."t1" in source database "sm2"

2. 查看apply_error等相关信息

select 
    apply_name,
    local_transaction_id,
    source_commit_scn,
    message_number,
    error_message 
from dba_apply_error;

得到
source_commit_scn：319230729
local_transaction_id：1.9.1459

3. 然后在源库执行

begin
    DBMS_APPLY_ADM.set_table_instantiation_scn@sm2(
    source_object_name   => 'chenhao.t1',
    source_database_name => 'sm1',
    instantiation_scn    => 319230729);
end;
/

4. 接着在目的库执行

BEGIN
  DBMS_APPLY_ADM.EXECUTE_ERROR(
    local_transaction_id => '1.9.1459',
    execute_as_user      => FALSE,
    user_procedure       => NULL);
END;
/

5. 最后重启apply进程

BEGIN
  DBMS_APPLY_ADM.START_APPLY(apply_name=>'APPLY$_SM1');
END;
/