| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dataguard - primary database moved to another server
Hey Dave,
I am attempting to do that but when I select the standby database, it reports an error.
Physical standby validation error: The selected standby's activation ID does not match the primary.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of David Morley
Sent: Thursday, March 25, 2004 11:01 AM
To: oracle-l_at_freelists.org
Subject: Re: Dataguard - primary database moved to another server
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
> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Carel-Jan Engel
> Sent: Thursday, March 25, 2004 10:01 AM
> To: oracle-l_at_freelists.org
> 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_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Mar 25 2004 - 11:27:00 CST
 |
 |