From oracle-l-bounce@freelists.org Thu Mar 25 15:08:32 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2PL8V918334 for ; Thu, 25 Mar 2004 15:08:31 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2PL8Po18315 for ; Thu, 25 Mar 2004 15:08:25 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 324F8393AAC; Thu, 25 Mar 2004 16:03:56 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19836-21; Thu, 25 Mar 2004 16:03:56 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B4C76393A2E; Thu, 25 Mar 2004 16:03:04 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 25 Mar 2004 16:01:09 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1B6433921B2 for ; Thu, 25 Mar 2004 16:00:20 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18899-23 for ; Thu, 25 Mar 2004 16:00:19 -0500 (EST) Received: from hsmailout2.prnewswire.com (hsmailout2.prnewswire.com [199.230.26.204]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 75F2F393954 for ; Thu, 25 Mar 2004 15:59:14 -0500 (EST) Received: from [198.199.176.19] (helo=hssmtp4.us.prnews.net) by hsmailout2.prnewswire.com with esmtp (Exim 3.35 #3) id 1B6c3f-0004Lg-00 for oracle-l@freelists.org; Thu, 25 Mar 2004 16:06:35 -0500 Received: from webmail.prnewswire.com ([199.230.26.28]) by hssmtp4.us.prnews.net (Lotus Domino Release 5.0.12) with ESMTP id 2004032516071095:680287 ; Thu, 25 Mar 2004 16:07:10 -0500 To: oracle-l@freelists.org Subject: RE: Dataguard - primary database moved to another server MIME-Version: 1.0 Message-ID: From: "Indy Johal" Date: Thu, 25 Mar 2004 16:06:33 -0500 Content-Type: multipart/alternative; boundary="=_alternative 0073E33E85256E62_=" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1840 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Indy.Johal@prnewswire.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org --=_alternative 0073E33E85256E62_= Content-Type: text/plain; charset="us-ascii" Yes your need to rebuild in 9i Not the case in 10g where Flashback DB can save your efforts in both of the following cases Failover to Standby -- No Need to rebuilt the Primary db from scratch Opening Primary with Resetlog -- Standby db will be back with the use of Flashback Db Indy Johal Manager, Database Administration PR Newswire indy_johal@prnewswire.com http://www.prnewswire.com (201) 946-5687 [W] (201) 220 6781 [M] "We tell your story to the world." "John P Weatherman" Sent by: oracle-l-bounce@freelists.org 03/25/2004 02:54 PM Please respond to oracle-l To: oracle-l@freelists.org cc: 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 > To: > 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@freelists.org > [mailto:oracle-l-bounce@freelists.org]On Behalf Of Mladen Gogala > Sent: Thursday, March 25, 2004 2:05 PM > To: oracle-l@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@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@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@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 ----------------------------------------------------------------- --=_alternative 0073E33E85256E62_= Content-Type: text/html; charset="us-ascii"
Yes your need to rebuild in 9i

Not the case in 10g where Flashback DB can save your efforts in both of the following cases
  • Failover to Standby  -- No Need to rebuilt the Primary db from scratch
  • Opening Primary with Resetlog -- Standby db will be back with the use of Flashback Db


    Indy Johal
    Manager, Database Administration
    PR Newswire
    indy_johal@prnewswire.com
    http://www.prnewswire.com

    (201) 946-5687 [W]
    (201) 220 6781 [M]

    "We tell your story to the world."



    "John P Weatherman" <asahoshi@infionline.net>
    Sent by: oracle-l-bounce@freelists.org

    03/25/2004 02:54 PM
    Please respond to oracle-l

           
            To:        oracle-l@freelists.org
            cc:        
            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@lmco.com>
    > To: <oracle-l@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@freelists.org
    > [mailto:oracle-l-bounce@freelists.org]On Behalf Of Mladen Gogala
    > Sent: Thursday, March 25, 2004 2:05 PM
    > To: oracle-l@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@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@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@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
    -----------------------------------------------------------------


--=_alternative 0073E33E85256E62_=-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------