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 -----------------------------------------------------------------