From oracle-l-bounce@freelists.org Fri Mar 26 07:05:06 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2QD56S12449 for ; Fri, 26 Mar 2004 07:05:06 -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 i2QD55o12444 for ; Fri, 26 Mar 2004 07:05:05 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3CA9B390B6B; Fri, 26 Mar 2004 08:02: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 05237-39; Fri, 26 Mar 2004 08:02:20 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7DCD1390AD4; Fri, 26 Mar 2004 08:02:19 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 26 Mar 2004 08:01:01 -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 87407390B3C for ; Fri, 26 Mar 2004 08:01:00 -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 04185-40 for ; Fri, 26 Mar 2004 08:01:00 -0500 (EST) Received: from mailgw3a.lmco.com (mailgw3a.lmco.com [192.35.35.7]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F1AE4390B3F for ; Fri, 26 Mar 2004 08:00:59 -0500 (EST) Received: from emss04g01.ems.lmco.com (relay4.ems.lmco.com [166.17.13.122]) by mailgw3a.lmco.com (8.12.10/8.12.10) with ESMTP id i2QD8RZr023912 for ; Fri, 26 Mar 2004 08:08:27 -0500 (EST) Received: from CONVERSION-DAEMON.lmco.com by lmco.com (PMDF V6.1-1X6 #30884) id <0HV600K01PU3EF@lmco.com> for oracle-l@freelists.org; Fri, 26 Mar 2004 08:08:27 -0500 (EST) Received: from EMSS04I00.us.lmco.com ([166.17.13.135]) by lmco.com (PMDF V6.1-1X6 #30884) with ESMTP id <0HV6005CWPU3RU@lmco.com> for oracle-l@freelists.org; Fri, 26 Mar 2004 08:08:27 -0500 (EST) Received: from EMSS04M12.us.lmco.com ([166.17.13.94]) by EMSS04I00.us.lmco.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 26 Mar 2004 08:08:25 -0500 Date: Fri, 26 Mar 2004 08:08:26 -0500 From: "Grabowy, Chris" Subject: RE: Dataguard - primary database moved to another server To: oracle-l@freelists.org Message-id: <974B0BC4C9F3BB40B2651F8FC12B7B98A5211A@emss04m12.us.lmco.com> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft Exchange V6.0.6487.1 Content-Type: text/plain; charset=US-ASCII Thread-Topic: Dataguard - primary database moved to another server Thread-Index: AcQSpxQXwps/ci7vTWqMjDcwUC/AVQAikG9Q content-class: urn:content-classes:message X-MS-Has-Attach: X-MS-TNEF-Correlator: X-OriginalArrivalTime: 26 Mar 2004 13:08:25.0942 (UTC) FILETIME=[6C98A760:01C41333] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1883 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chris.grabowy@lmco.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of John P Weatherman Sent: Thursday, March 25, 2004 2:55 PM To: oracle-l@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 > 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------