Re: Dataguard - primary database moved to another server
- From: "David Morley" <dmorley@xxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Mar 2004 11:00:45 -0500
Chris,
When using dataguard the actual HOSTNAME of the primary/backup nodes are
imbedded in the dataguard configuration. I believe you will need to remove
and recreate the dataguard configuration.
Thanks,
Dave
----------------------------------------------------------------------------
----------------------
David A. Morley
dmorley@xxxxxxxxxxxxxxxxxxx
----- Original Message -----
From: "Grabowy, Chris" <chris.grabowy@xxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, March 25, 2004 10:17 AM
Subject: RE: Dataguard - primary database moved to another server
> Cold backup of the primary database. It was then restored on the new
server. A reset logs was done, but right now I'm trying to debug the
activation ID mismatch. Unless the activation id is tied into the sequence
number??
>
> Not sure if the DBA had stopped the standby last night. Probably not.
Would that really be a factor? The primary was shutdown, logs stopped
shipping.
>
> The old and new server name for the primary database are different. We
moved a bunch of databases from individual servers to a new monster server.
So Im wondering if that is killing me. Perhaps the hostname is coded into
the archive log file??? Dunno.
>
> Still scratching my head, poking and proding around...
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Carel-Jan Engel
> Sent: Thursday, March 25, 2004 10:01 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Re: Dataguard - primary database moved to another server
>
>
> Chris,
>
> Can you explain how you moved the primary? Did you stop the standby while
> the primary was moved?
>
>
>
>
> > A primary database was moved to a new server. The primary and standby
are
> > no longer communicating.
> >
> > The alert log on the primary is reporting....
> > ORA-16069: Archive Log standby database activation identifier mismatch
> >
> > The alert log on the standby is reporting....
> > RFS: Activation ID mismatch found xxxxx expected yyyyyy
> > RFS: Possible network disconnect with primary database
> >
> > Is there a config file that I can tweak to fix this activation id???
> >
> > I dropped the entry in Dataguard and attempted to recreate but it failed
> > because of the above errors.
> >
> > For what its worth I fixed fal_server on the standby.
> >
> > I have been searching around Metalink and the doc but I cant find many
> > references to the activiation id. I searched the DG .dat files, but I
> > can't find it in there either.
> >
> > We really don't want to recreate the standby from the primary again,
since
> > we are planning on moving a slew of primary databases to new servers.
> >
> > Help?
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
>
>
> Regards, Carel-Jan
>
> ===
> If you think education is expensive, try ignorance. (Derek Bok)
> ===
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
