11g默认valid_for引起ora-16009

dg的alert总是间断的出现ora-16009的错误

主库：
Sun Feb 17 03:34:52 2013
RFS[53]: Assigned to RFS process 6896
RFS[53]: Database mount ID mismatch [0x27bfa217:0x27c019ed] (666870295:666900973)
RFS[53]: Client instance is standby database instead of primary
RFS[53]: Not using real application clusters
Errors in file /db/app/oracle/diag/rdbms/xiaoyu/xiaoyu/trace/xiaoyu_rfs_6896.trc:
ORA-16009: invalid redo transport destination
Sun Feb 17 03:40:52 2013
RFS[54]: Assigned to RFS process 6942
RFS[54]: Database mount ID mismatch [0x27bfa217:0x27c019ed] (666870295:666900973)
RFS[54]: Client instance is standby database instead of primary
RFS[54]: Not using real application clusters
Errors in file /db/app/oracle/diag/rdbms/xiaoyu/xiaoyu/trace/xiaoyu_rfs_6942.trc:
ORA-16009: invalid redo transport destination

备库
Sun Feb 17 03:34:52 2013
Errors in file /orcl11g/app/oracle/diag/rdbms/xiaoyu_dg/xiaoyu/trace/xiaoyu_arc2_3042.trc:
ORA-16009: invalid redo transport destination
PING[ARC2]: Heartbeat failed to connect to standby 'xiaoyu'. Error is 16009.
Sun Feb 17 03:40:52 2013
Errors in file /orcl11g/app/oracle/diag/rdbms/xiaoyu_dg/xiaoyu/trace/xiaoyu_arc2_3042.trc:
ORA-16009: invalid redo transport destination
PING[ARC2]: Heartbeat failed to connect to standby 'xiaoyu'. Error is 1600

主库
SQL> show parameter log_archive_dest;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string location=/orclbak/xiaoyu

log_archive_dest_2 string service=xiaoyu_dg arch sync d
b_unique_name=xiaoyu_dg

SQL> select dest_name,error,status,process from v$archive_dest where rownum<3;

DEST_NAME ERROR STATUS PROCESS
-------------------- -------------------- --------- ----------
LOG_ARCHIVE_DEST_1 VALID ARCH
LOG_ARCHIVE_DEST_2 VALID ARCH

备库：
SQL> show parameter log_archive_dest;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string location=/orclbak/xiaoyudg

log_archive_dest_2 string service=xiaoyu arch sync d
b_unique_name=xiaoyu

SQL> select dest_name,error,status,process from v$archive_dest where rownum<3;

DEST_NAME ERROR STATUS PROCESS
---------- -------------------- --------- ----------
LOG_ARCHIV VALID ARCH
E_DEST_1

LOG_ARCHIV ORA-16009: invalid ERROR ARCH
E_DEST_2 redo transport
destination

需要这里说明的是11g这个ora-16009 invalid redo transport destination并没有影响dg体系结构的运行，而这个错误也是反映在备库的v$archive_dest下，这个因为 log_archive_dest_2参数不规范引起的，默认不设置valid_for属性oracle认为是VALID_FOR= (ALL_LOGFILES, ALL_ROLES)。

SQL> alter system set log_archive_dest_2='service=xiaoyu arch sync valid_for=(online_logfiles,primary_role) db_unique_name=xiaoyu';

System altered.

手动设置valid_for属性后主库做几次switch logfile，备库的v$archive_dest和alert没有出现上述的错误，建议按照dg的官档推荐指定log_archive_dest等参数属性。
SQL> select dest_name,error,status,process from v$archive_dest where rownum<3;

DEST_NAME ERROR STATUS PROCESS
-------------------- -------------------- --------- ----------
LOG_ARCHIVE_DEST_1 VALID ARCH
LOG_ARCHIVE_DEST_2 VALID ARCH

转载自： http://www.dbaxiaoyu.com/archives/812