RE: Dataguard - primary database moved to another server

  • From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 25 Mar 2004 11:13:12 -0800

Mladen is clearly shooting in the dark here :) 
Stay away from changing the dbid unless you have to, the only time I know
where resetting the dbid is acceptable is when you are restoring an instance
from RMAN completely, where the control files and spfile have to be first
recovered from an RMAN backupset. You need to set the DBID in order to get
your empty instance to startup force. I have run several dataguard standby
configs, and moved the primary several times, never have I had to reset the
DBID. You killed your config when you opened the primary resetlogs. But I
already said that :)

Josh C.

-----Original Message-----
From: Mladen Gogala [mailto:mladen@xxxxxxxxxxxxxxx]
Sent: Thursday, March 25, 2004 11:05 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Dataguard - primary database moved to another server


On 03/25/2004 01:52:40 PM, "Grabowy, Chris" wrote:
> Huh?  How do you know that DBID is the same as the standby activation
id????
> 
> What secrets are you keeping??

No secrets here, I definitely talk too much. The word "secret" isn't 
even a part of my vocabulary. As for the DBID, isn't that the error
that you are getting? I believe that standby ID and the main database
ID should definitely be the same.
----------------------------------------------------------------
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: