ORA-16401: archivelog rejected by RFS ---解決方法
在配置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
解決方法如下 :
把備庫的引數
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- rake deploy ! [rejected] master -> master (non-fast-forward) error: failed to push some refs to解決方法ASTForwardErrorAI
- Oracle歸檔空間不足,delete archivelog all;命令失效時解決方法OracledeleteHive
- RFS 理解
- 解壓三星.rfs檔案
- .gitignore檔案配置以及gitee提交報Push rejected...錯誤解決Gitee
- standby database No RFS 程式Database
- TSM備份 ANS1025E (RC137) Session rejected: Authentication failure解決。SessionAI
- ! [rejected] master -> master (fetch first)AST
- FAL[server, ARCN]: FAL archive failed ORA-16401ServerHiveAI
- 網路卡優化RPS/RFS優化
- TabError的解決方法Error
- EXE病毒解決方法
- ArtifactDescriptorException的解決方法Exception
- Restore ArchivelogRESTHive
- RPC:authentication error:why = server rejected credentialRPCErrorServer
- SERVICE問題解決方法
- No Task Available解決方法AI
- No input file specified 解決方法
- ANR原因及解決方法
- pyenv BUILD FAILED解決方法UIAI
- defunct僵死程式解決方法
- putty亂碼解決方法
- hash衝突解決方法
- Delete Dataguard ArchivelogdeleteHive
- 配置ARCHIVELOG 模式Hive模式
- dns劫持怎麼解決 dns劫持的解決方法DNS
- javaweb中中文亂碼解決方法總結之response和request解決方法JavaWeb
- RMAN - backup archivelog all 與 backup database plus archivelog 區別HiveDatabase
- rfs (PID:146054): Database mount ID mismatch案例Database
- hive使用報錯解決方法Hive
- 解決問題通用方法論
- Method ReflectionParameter::getClass() 解決方法
- As常見問題解決方法
- css命名衝突解決方法CSS
- 介面返回[object,Object]解決方法Object
- ImportError: No module named ‘torch‘ 解決方法ImportError
- 遇到問題的解決方法
- ORA-01795解決方法