Need assistance with data guard
- From: "sol beach" <sol.beach@xxxxxxxxx>
- To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 15 Aug 2008 11:01:30 -0700
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
*
Other related posts:
