Fri Mar 13 02:28:00 2015
PING[ARC2]: Heartbeat failed to connect to standby 'd012dg'. Error is 16057.? <<<Fri Mar 13 02:29:01 2015
PING[ARC2]: Heartbeat failed to connect to standby 'd012dg'. Error is 16057.
Fri Mar 13 02:30:01 2015
PING[ARC2]: Heartbeat failed to connect to standby 'd012dg'. Error is 16057.
Fri Mar 13 02:31:02 2015
PING[ARC2]: Heartbeat failed to connect to standby 'd012dg'. Error is 16057.
Fri Mar 13 02:32:02 2015
PING[ARC2]: Heartbeat failed to connect to standby 'd012dg'. Error is 16057.
Fri Mar 13 02:33:02 2015
PING[ARC2]: Heartbeat failed to connect to standby 'd012dg'. Error is 16057.
Fri Mar 13 02:34:03 2015
PING[ARC2]: Heartbeat failed to connect to standby 'd012dg'. Error is 16057.
Fri Mar 13 02:35:03 2015
PING[ARC2]: Heartbeat failed to connect to standby 'd012dg'. Error is 16057.
Fri Mar 13 02:36:04 2015
PING[ARC2]: Heartbeat failed to connect to standby 'd012dg'. Error is 16057.
? ? 以上告警在ADG的环境中已经多次遇到，请注意类似报错的错误ID，这里的ID是16057，Oracle对该错误是这样解释的：
ORA-16057: DGID from server not in Data Guard configuration
Cause: The Data Guard name of the primary database or the FAL server is not in the Data Guard configuration of the standby.
Action: In order for the primary database or the FAL server to archive logs to the standby database, the Data Guard name of the primary or FAL server must be in the Data Guard configuration of the standby.
在MOS中找到如下文章：
Primary Remote log shipping failing with ORA-16057 - Server not in Data Guard configuration (Doc ID 1570928.1)
?
In this Document
?Symptoms?
?Cause?
?Solution?
?
?
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.
Symptoms
?------------Primary Alert log-----------------
Thu Jul 11 16:28:16 2013
ALTER SYSTEM SET log_archive_dest_2='service=chicago async valid_for=(all_logfiles,primary_role) db_unique_name=chicago'
SCOPE=BOTH;
Thu Jul 11 16:28:17 2013
PING[ARC1]: Heartbeat failed to connect to standby 'chicago'. Error is 16057..'
..
.
Error 16057 for archive log file 1 to 'chicago'
Thu Jul 11 16:28:19 2013
Errors in file /u01/app/oracle/diag/rdbms/boston/boston/trace/boston_tt01_6296.trc:
ORA-16057: server not in Data Guard configuration
@primary,
SQL> col error for a30
SQL> select dest_id,error,status,log_sequence,applied_scn from v$archive_dest where dest_id=2;
? DEST_ID ERROR? ? ? ? ? ? ? ? ? ? ? ? ? STATUS? ? LOG_SEQUENCE APPLIED_SCN
---------- ------------------------------ --------- ------------ -----------
? ? ? ? 2 ORA-16057: server not in Data? ERROR? ? ? ? ? ? ? 61? ? ? ? ? 0
? ? ? ? ? Guard configuration
Cause
log_archive_config not set.
Solution
@primary,
SQL> col error for a30
SQL> select dest_id,error,status,log_sequence,applied_scn from v$archive_dest where dest_id=2;
? DEST_ID ERROR? ? ? ? ? ? ? ? ? ? ? ? ? STATUS? ? LOG_SEQUENCE APPLIED_SCN
---------- ------------------------------ --------- ------------ -----------
? ? ? ? 2 ORA-16057: server not in Data? ERROR? ? ? ? ? ? ? 61? ? ? ? ? 0
? ? ? ? ? Guard configuration
SQL> sho parameter log_archive_config
NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE? ? ? ? VALUE
------------------------------------ ----------- ------------------------------
log_archive_config? ? ? ? ? ? ? ? ? string
SQL>ALTER SYSTEM SET log_archive_config='dg_config=(boston,ChicagO)' SCOPE=BOTH;
System altered.
SQL> alter system set log_archive_dest_state_2=defer;
System altered.
SQL>? alter system set log_archive_dest_state_2=enable
System altered.
SQL> alter system switch logfile;
System alter