RE: Dataguard - primary database moved to another server
- From: "Grabowy, Chris" <chris.grabowy@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 25 Mar 2004 10:17:23 -0500
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
-----------------------------------------------------------------
Other related posts:
