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

邱東陽發表於2014-06-04
REMHiveDatabase

今天建立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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章