今天创建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/