ORA-16009: remote archive log destination must be a STANDBY database

今天创建ORACLE10G 的Data Guard，使用的是物理备库。在查询物理备库时出现ORA-16009: remote archive log destination must be a STANDBY database

 

 

SQL>  select dest_name,status,error from v$archive_dest where rownum<3;   DEST_NAME -------------------------------------------------------------------------------- STATUS    ERROR --------- ----------------------------------------------------------------- LOG_ARCHIVE_DEST_1 VALID   LOG_ARCHIVE_DEST_2 ERROR     ORA-16009: remote archive log destination must be a STANDBY           database

 

 

日志：

edo shipping client performing standby login *** 2014-06-04 06:21:58.706 64561 kcrr.c Logged on to standby successfully Client logon and security negotiation successful! Error 16009 attaching RFS server to standby instance at host 'orcl_pd' Error 16009 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orcl_pd' ORA-16009: remote archive log destination must be a STANDBY database *** 2014-06-04 06:21:58.759 60679 kcrr.c PING[ARC0]: Heartbeat failed to connect to standby 'orcl_pd'. Error is 16009. *** 2014-06-04 06:21:58.759 58941 kcrr.c kcrrfail: dest:2 err:16009 force:0 blast:1

 

上网上查看了下资料，说是因为在备库log_archive_dest_2未清空导致的。

 

解决方法：在log_archive_dest_2参数中加入 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

SQL> show parameter log_archive_dest_2   NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_2                   string      service=orcl_pd DB_UNIQUE_NAME                                                  =orcl_pd SQL> alter system set LOG_ARCHIVE_DEST_2='service=orcl_pd VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl_pd';   System altered.   SQL> select dest_name,status,error from v$archive_dest where rownum<3;   DEST_NAME -------------------------------------------------------------------------------- STATUS    ERROR --------- ----------------------------------------------------------------- LOG_ARCHIVE_DEST_1 VALID   LOG_ARCHIVE_DEST_2 VALID     SQL>

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29532781/viewspace-1175435/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29532781/viewspace-1175435/