| 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
Yes, I was aware of the resetlogs issue.
But the activation id issue sent me off on a tangent. I was paranoid, as always, and wondering if the activation id issue was something different from the resetlogs. We havent setup ops with standbys so everything little thing with standbys conerns us. I believe were doing something called....testing...an amazing concept...I wonder if Microsoft.........
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of John P Weatherman
Sent: Thursday, March 25, 2004 2:55 PM
To: oracle-l_at_freelists.org
Subject: RE: Dataguard - primary database moved to another server
Chris,
You don't change the activation number. Remember the "incarnation" that gets reset with reset logs...
Remember, the standby is dependent on the change# and redo sequences of
the
primary. When you resetlogs, you break all of that in a big way. Just
like you can't recover until you take a new backup of the primary, the
standby can't recover until you rebuild it to match the incarnation of
the
primary.
You need to rebuild the standby. If taking down the primary is a
problem,
there are good notes on Metalink for building off of a hot backup.
HtH,
John P Weatherman
Oracle Database Administrator
Advance America
> [Original Message]
> From: Grabowy, Chris <chris.grabowy_at_lmco.com>
> To: <oracle-l_at_freelists.org>
> Date: 3/25/2004 2:45:33 PM
> Subject: RE: Dataguard - primary database moved to another server
>
> Close, I took a look at v$database, and there is a activation# field
in
it, and the number, converted to hex, matches the number reported in the
error messages on the standby database. So that is my problem. That
activation# changed when the primary was restored onto the new server.
>
> But, activation# and dbid do not match. Not even close.
>
> Now I know what and where it is, but not how to change it...time to
update the TAR...
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mladen Gogala
> Sent: Thursday, March 25, 2004 2:05 PM
> To: oracle-l_at_freelists.org
> 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_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 Fri Mar 26 2004 - 07:05:06 CST
 |
 |