在schema模式下的Streams資料傳輸,出現某個表不能傳輸錯誤ORA-26687

mengzhaoliang發表於2010-12-20

在配置Streams資料傳輸時,配置schema傳輸,如果出現某個表不能傳輸。如果如果為ORA-26687: no instantiation SCN provided
可以參考itpub論述上的一個帖子來試試處理。

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
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
APPLY_NAME                                         VARCHAR2(30)
QUEUE_NAME                                NOT NULL VARCHAR2(30)
QUEUE_OWNER                               NOT NULL VARCHAR2(30)
LOCAL_TRANSACTION_ID                               VARCHAR2(22)
SOURCE_DATABASE                                    VARCHAR2(128)
SOURCE_TRANSACTION_ID                              VARCHAR2(22)
SOURCE_COMMIT_SCN                                  NUMBER
MESSAGE_NUMBER                                     NUMBER
ERROR_NUMBER                                       NUMBER
ERROR_MESSAGE                                      VARCHAR2(4000)
RECIPIENT_ID                                       NUMBER
RECIPIENT_NAME                                     VARCHAR2(30)
MESSAGE_COUNT                                      NUMBER
ERROR_CREATION_TIME                                DATE

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

3、然後在源庫執行
SQL>
SQL> begin
  2       => '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;

問題解決。

 

 

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12778571/viewspace-682170/,如需轉載,請註明出處,否則將追究法律責任。

相關文章