【DataGuard】ORA-16014 and ORA-00312 Messages in Alert.log of Physical Standby-白红宇

安装完成dg后，发现alert 之中的有如下错误

ORA-16014: log 4 sequence# 44 not archived, no available destinations

ORA-00312: online log 4 thread 1: '/opt/oracle/oradata/orclpdg/redo04.log'

Wed Aug 24 22:55:45 2011

Errors in file /opt/oracle/admin/orcl/bdump/orclpdg_arc0_4062.trc:

ORA-16014: log 4 sequence# 44 not archived, no available destinations

ORA-00312: online log 4 thread 1: '/opt/oracle/oradata/orclpdg/redo04.log'

Wed Aug 24 22:55:45 2011

Redo Shipping Client Connected as PUBLIC

-- Connected User is Valid

RFS[2]: Assigned to RFS process 4762

RFS[2]: Identified database type as 'physical standby'

Primary database is in MAXIMUM PERFORMANCE mode

Re-archiving standby log 4 thread 1 sequence 44

Wed Aug 24 22:55:45 2011

ARC1: Archiving not possible: No primary destinations

ARC1: Failed to archive thread 1 sequence 44 (4)

查看备库的参数文件归档路径设置：备库本应该是orclpdg 这里是orcl(从主库拷贝过来，没有改成相应的值)

LOG_ARCHIVE_DEST_1='LOCATION=/opt/oracle/std_arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=

orcl'

解决方法：

LOG_ARCHIVE_DEST_1='LOCATION=/opt/oracle/std_arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=

orclpdg'

之后此错误解决！

对于LOG_ARCHIVE_DEST_N 参数的配置有语法错误比如少了空格，或者VALID_FOR参数配置错误都有可能导致上述错误！大多是此类错误，仔细检查就可避免！

附上metalink上的文档：

ORA-16014 and ORA-00312 Messages in Alert.log of Physical Standby. [ID 834771.1]

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2

Information in this document applies to any platform.

Checked for relevance on 18-Apr-2011

现象：

备库的alert.log出现 ORA-16014 and ORA-00312 信息

==========

ORA-16014: log 8 sequence# 2386 not archived, no available destinations

ORA-00312: online log 8 thread 2: '+DATADG/phpprd/onlinelog/group_8.271.636653821'

ORA-00312: online log 8 thread 2: '+FLASHDG/phpprd/onlinelog/group_8.317.636653821'

ORA-16014: log 6 sequence# 2393 not archived, no available destinations

ORA-00312: online log 6 thread 2: '+FLASHDG/phpprd/onlinelog/group_6.645.684556605'

原因：

问题发生时是否有如下配置：

++ There is no log_archive_dest_n parameter defined for standby redo log files archival

++ valid_for in log_archive_dest_1 is (ONLINE_LOGFILE,ALL_ROLES)

log_archive_dest_1 = location="+FLASHDG/phpprd/", valid_for=(ONLINE_LOGFILE,ALL_ROLES)

解决方法：

++ Make sure we define log_archive_dest_n with correct valid_for attribute that enables standby redo logs archival.

ALTER SYSTEM SET log_archive_dest_2 = 'location=+FLASHDG/phpprd/ valid_for=(standby_logfile, standby_role) db_unique_name= boston';

Note:- boston is the standby db_unique_name here

++ Remove valid_for from the log_Archive_dest_1, this assumes default valid_for attribute i.e., all_logfile, all_roles:

SQL>ALTER SYSTEM SET log_archive_dest_1 = 'location="+FLASHDG/phpprd/"';