ORA-26687

l、流复制目标数据库出现错误如下：

STRMADMIN_APPLY  ORA-26687: no instantiation SCN provided

for "BASECONF"."PUB_USER" in source database "BILLBJ.CHINACACHE"

2、查看apply_error等相关信息

SQL> desc dba_apply_error

select APPLY_NAME,LOCAL_TRANSACTION_ID,SOURCE_COMMIT_SCN,MESSAGE_NUMBER,ERROR_MESSAGE from dba_apply_error;
得到SOURCE_COMMIT_SCN

3、然后在源库执行

SQL> begin
  2    DBMS_APPLY_ADM.set_table_instantiation_scn(source_object_name   => ''BASECONF.PUB_USER'',
  3                                                         source_database_name => ''BILLBJ.CHINACACHE'',
  4                                                         instantiation_scn    => 34327911302);
  5  end;
  6  /

4、在目标库执行即可
BEGIN
  DBMS_APPLY_ADM.EXECUTE_ERROR(
    local_transaction_id => ''14.39.3430485'',
    execute_as_user      => FALSE,
    user_procedure       => NULL);
END;

转载于:https://www.cnblogs.com/landexia/archive/2012/08/30/2664645.html