ORA-16401: archivelog rejected by RFS ---解決方法

season0891發表於2011-07-03
在配置oracle physical database 的時候會出現ORA-16401這個錯誤。
解決方法如下 :
把備庫的引數
log_archive_dest_3 設定為空即可 :
修改前 :
2011-07-02 19:16:32 2011-07-02 21:09:05        592          1 NO
2011-07-01 20:26:20 2011-07-01 20:26:35       1084          2 YES

FIRST_TIME          NEXT_TIME            SEQUENCE#    THREAD# APP
------------------- ------------------- ---------- ---------- ---
2011-07-02 19:16:32 2011-07-02 21:09:05        592          1 YES
2011-07-02 21:09:05 2011-07-02 22:30:08        593          1 NO
2011-07-02 21:09:05 2011-07-02 22:30:08        593          1 YES
2011-07-02 21:32:30 2011-07-02 22:45:28       1103          2 NO
2011-07-02 21:32:30 2011-07-02 22:45:28       1103          2 YES
2011-07-02 22:45:28 2011-07-02 23:13:01       1104          2 NO
2011-07-02 22:45:28 2011-07-02 23:13:01       1104          2 YES
2011-07-02 22:30:08 2011-07-02 23:13:01        594          1 NO
2011-07-02 22:30:08 2011-07-02 23:13:01        594          1

修改後 :
2011-07-02 23:13:01 2011-07-03 00:03:19        595          1 YES
2011-07-02 23:13:01 2011-07-03 00:03:27       1105          2 YES

FIRST_TIME          NEXT_TIME            SEQUENCE#    THREAD# APP
------------------- ------------------- ---------- ---------- ---
2011-07-03 00:03:19 2011-07-03 00:04:04        596          1 YES
2011-07-03 00:03:27 2011-07-03 00:04:08       1106          2 YES


不會出現重複歸檔現象,雖然重複歸檔是可以忽略的錯。但是還是要追究下問題根源 。
而且主庫也會報這個錯 :
ORA-16401: archivelog rejected by RFS


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

相關文章