做DG的時候 主庫兩個節點無法把日志傳到備庫上

    SQL> select dest_name,status,type,database_mode,protection_mode,destination,applied_seq#,db_unique_name from v$archive_dest_status;



DEST_NAME                 STATUS    TYPE       DATABASE_MODE   PROTECTION_MODE      DESTINATIO APPLIED_SEQ# DB_UNIQUE_NAME

------------------------- --------- ---------- --------------- -------------------- ---------- ------------ ------------------------------

LOG_ARCHIVE_DEST_1        VALID     LOCAL      OPEN_READ-ONLY  MAXIMUM PERFORMANCE  +DATA/sharkd            0 sharkdg

                                                                                    b/archivel

                                                                                    og



LOG_ARCHIVE_DEST_2        ERROR     UNKNOWN    UNKNOWN         MAXIMUM PERFORMANCE  sharkdb                 0 sharkdb
  

?

發現 STATUS 非 VALID狀態。

select dest_id,error from v$archive_dest;

ORA-16047: DGID mismatch between destination setting and target database

看來沒有把日志傳過去

查看 ALTER.ORA日志

*** 2013-08-26 11:19:06.319

Archived Log entry 1792 added for thread 1 sequence 902 ID 0xfe904e46 dest 1: /arch/1_902_822142156.dbf

ORA-16055: FAL request rejected

檢查 log_archive_dest_2 設置

    SQL> show parameter LOG_ARCHIVE_DEST_2



NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_2                   string      service=shardb lgwr sync affirm valid_for=(online_logfiles,primary_role)db_unique_name=sharkdg	
  

    ?
  

    查看備庫的DB_UNIQUE_NAME 是否有錯  果然設置成了SHARKDB了 
  

    或查看log_archive_config='DG_CONFIG=（）‘
  

    ?
  

    修改了 LOG_ARCHIVE_DEST_2  SCOPE=BOTH   依舊要重啟實例 否則好像并不能生效。
  

    ?
  

ORA-16047: DGID mismatch between destination setting and target database