在配置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博客 ” ,链接:https://blog.itpub.net/90618/viewspace-701219/
,如需转载,请注明出处,否则将追究法律责任。