- 流复制目标数据库apply进程出现错误如下：
STRMADMIN_APPLY ORA-26687: no instantiation SCN provided
for "chenhao"."t1" in source database "sm2"
- 查看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
- 然后在源库执行
begin
DBMS_APPLY_ADM.set_table_instantiation_scn@sm2(
source_object_name => 'chenhao.t1',
source_database_name => 'sm1',
instantiation_scn => 319230729);
end;
/
- 接着在目的库执行
BEGIN
DBMS_APPLY_ADM.EXECUTE_ERROR(
local_transaction_id => '1.9.1459',
execute_as_user => FALSE,
user_procedure => NULL);
END;
/
- 最后重启apply进程
BEGIN
DBMS_APPLY_ADM.START_APPLY(apply_name=>'APPLY$_SM1');
END;
/
