Need assistance with data guard

From: sol beach <sol.beach_at_gmail.com>
Date: Fri, 15 Aug 2008 11:01:30 -0700
Message-ID: <40a16b360808151101y5816635dl4d503f8119ec31e3@mail.gmail.com>


V10.2.0.1
RHEL5 I was using *Note:387339.1

I am close but not home free yet.
From alert log
Fri Aug 15 10:50:02 2008
ALTER SYSTEM SET log_archive_config='dg_config=(rac03_ora1d,ora1d)' SCOPE=BOTH;
Fri Aug 15 10:52:02 2008
Errors in file /u01/orasys/orcl/admin/ora1d/bdump/ora1d1_arc0_17722.trc: ORA-16057: DGID from server not in Data Guard configuration Fri Aug 15 10:52:02 2008
PING[ARC0]: Heartbeat failed to connect to standby 'RAC03_ORA1D'. Error is 16057.

From trace file mentioned above
kcrrwkx: nothing to do (end)
*** 2008-08-15 10:47:02.338

Redo shipping client performing standby login
*** 2008-08-15 10:47:02.379 64561 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful! This database DGID not in Data Guard configuration at 'RAC03_ORA1D' Error 16057 attaching to destination LOG_ARCHIVE_DEST_3 standby host 'RAC03 _ORA1D'
ORA-16057: DGID from server not in Data Guard configuration
*** 2008-08-15 10:47:02.382 60679 kcrr.c
PING[ARC0]: Heartbeat failed to connect to standby 'RAC03_ORA1D'. Error is 16057.
*** 2008-08-15 10:47:02.382 58941 kcrr.c
kcrrfail: dest:3 err:16057 force:0 blast:1 kcrrwkx: nothing to do (end)

16057, 00000, "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.

I see the above but nothing I have changed has made any difference.

  1. Exactly how do I obtain the "DGID" of the primary.
  2. Where on the secondary must this value be deposited?

A Google search showed somebody else had this but no solution was ever posted.

Any clues would be most welcomed.

TIA
*

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 15 2008 - 13:01:30 CDT

Original text of this message