Re: Need assistance with data guard

What is your log_archive_config parameter set to?

and does the entry for the standby in there match what the db_unique_name that the standby is set to?

jason.

--
http://jarneil.wordpress.com


On Fri, Aug 15, 2008 at 7:01 PM, sol beach <sol.beach_at_gmail.com> wrote:



> 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