Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 716 invoked from network); 17 Dec 2007 06:40:37 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 17 Dec 2007 06:40:37 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E19527D9E60; Mon, 17 Dec 2007 07:40:36 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21823-05; Mon, 17 Dec 2007 07:40:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 507017D9EFD; Mon, 17 Dec 2007 07:40:36 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 17 Dec 2007 06:53:11 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 22DB57D9A5A for ; Mon, 17 Dec 2007 06:53:11 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13454-05 for ; Mon, 17 Dec 2007 06:53:11 -0500 (EST) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.242]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CA9877D9996 for ; Mon, 17 Dec 2007 06:53:10 -0500 (EST) Received: by an-out-0708.google.com with SMTP id b36so1094364ana.101 for ; Mon, 17 Dec 2007 03:53:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references; bh=gUs2JAQ1RyscGvahSqhZ4vZufZAGLCOpHe+6YiLuuvA=; b=Grk6XUMQltfzDzyc0gI1RxePD1gdyx6fDkDfSlht1cIcdX87K9jB+GeFUq5Cu1qI3g3vYWscLnI7P0zrSzYe6cgHoPZeWjfaAYGehADC1jpt2lP63VBmkHMnzmz9kH2yasHaUTvkTPsy3zzGHTwblYXtHoLi5mZnluwqDEHxvqw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references; b=Z0Jw+Yd+FUBLzYOiOxEOXRyv7GoCUb8Lpbix+CaobbxnBHTa6Vo09ML3o9WIXm22bYo6JbSulVm6UgO1RN+sKTvJ6SmvgjDTEFS9aED9TNkjvcddyehrF/H0T7AUow5m6+d4934Pu+6uZJ4zjb0t9ZmSzK3JfFoiykA7iZUxNaI= Received: by 10.100.172.17 with SMTP id u17mr11245032ane.86.1197892390169; Mon, 17 Dec 2007 03:53:10 -0800 (PST) Received: by 10.100.41.4 with HTTP; Mon, 17 Dec 2007 03:53:10 -0800 (PST) Message-ID: <7b8774110712170353h769c6121oe962ff1f89404e95@mail.gmail.com> Date: Mon, 17 Dec 2007 05:53:10 -0600 From: "Charles Schultz" To: oracle-l@freelists.org Subject: Re: does FRA is really needed ? In-Reply-To: <7b8774110712160501k7cf8d570ic6dd587c98e00774@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7225_31891721.1197892390161" References: <916349.5896.qm@web58006.mail.re3.yahoo.com> <4025610e0712150927l31a88113o36cc4aac77056c69@mail.gmail.com> <476511C6.3070709@interia.pl> <7b8774110712160501k7cf8d570ic6dd587c98e00774@mail.gmail.com> X-archive-position: 3964 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: sacrophyte@gmail.com Precedence: normal Reply-to: sacrophyte@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_7225_31891721.1197892390161 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I wanted to apologize for confusing the issue. For some reason I had ASM on the brain, even though there was no mention of it in the OP's note (not even RAC for that matter). I am sure some of you were thinking after reading my note "What was he smoking?" I assure you, I am thinking the same thing. On Dec 16, 2007 7:01 AM, Charles Schultz wrote: > Grzegorz, > > Good question, that is something we have been wondering about as well. > There are some other questions that go along with this, I believe. > > For instance, are you using a RAC? Seems like an obvious one, but I did > not want to assume (that BAAG party as got to be for something, right?). > Second question, do you currently or plan to use Flashback database? From my > limited experience, these seem to be the key things that "require" an FRA. > > To answer you question, dataguard, in and of itself, does not need FRA > whatsoever. In fact, DG and RAC are two completely separate technologies, > used to achieve a single goal (Maximum Availability). > > In our RAC environment, we do not currently have need of an FRA; we > implemented the Flashback Recovery Area as part of the "Best Practices", but > for us, it is a real pain dealing with archive log gaps (both for physical > standbys and streams). And we have chosen, at this point, to avoid the > dataguard broker as well. These are choices we have made for our particular > environment and may not be well suited for everyone. We are still learning > things about RAC, FRA and the broker, so there is still a chance our > environment may change a little. > > If anyone finds holes this, please let me know. =) > > > On Dec 16, 2007 5:53 AM, Grzegorz Goryszewski > wrote: > > > Hi, > > > > can You please clarify one thing for me. > > I'm wonder if FRA is really neccessary for Data Guard solution ? > > I'm preparing for DG configuration with physical standby, do I need FRA > > for > > failover switch from primary to standby and back ? > > Oracle 10.2.0.2 . > > Regards. > > Grzegorz > > > > > > ---------------------------------------------------------------------- > > Las Vegas wsrod portali! Sprawdz >> http://www.interia.pl/ > > > > > > -- > > http://www.freelists.org/webpage/oracle-l > > > > > > > > > -- > Charles Schultz -- Charles Schultz ------=_Part_7225_31891721.1197892390161 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I wanted to apologize for confusing the issue. For some reason I had ASM on the brain, even though there was no mention of it in the OP's note (not even RAC for that matter). I am sure some of you were thinking after reading my note "What was he smoking?" I assure you, I am thinking the same thing.

On Dec 16, 2007 7:01 AM, Charles Schultz <sacrophyte@gmail.com> wrote:
Grzegorz,

Good question, that is something we have been wondering about as well. There are some other questions that go along with this, I believe.

For instance, are you using a RAC? Seems like an obvious one, but I did not want to assume (that BAAG party as got to be for something, right?). Second question, do you currently or plan to use Flashback database? From my limited experience, these seem to be the key things that "require" an FRA.

To answer you question, dataguard, in and of itself, does not need FRA whatsoever. In fact, DG and RAC are two completely separate technologies, used to achieve a single goal (Maximum Availability).

In our RAC environment, we do not currently have need of an FRA; we implemented the Flashback Recovery Area as part of the "Best Practices", but for us, it is a real pain dealing with archive log gaps (both for physical standbys and streams). And we have chosen, at this point, to avoid the dataguard broker as well. These are choices we have made for our particular environment and may not be well suited for everyone. We are still learning things about RAC, FRA and the broker, so there is still a chance our environment may change a little.

If anyone finds holes this, please let me know. =)


On Dec 16, 2007 5:53 AM, Grzegorz Goryszewski < grzegorzof@interia.pl> wrote:
Hi,

   can You please clarify one thing for me.
I'm wonder if FRA is really neccessary for Data Guard solution ?
I'm preparing for DG configuration with physical standby, do I need FRA for
failover switch from primary to standby and back ?
Oracle 10.2.0.2 .
Regards.
Grzegorz


----------------------------------------------------------------------
Las Vegas wsrod portali! Sprawdz >> http://www.interia.pl/


--
http://www.freelists.org/webpage/oracle-l





--
Charles Schultz



--
Charles Schultz ------=_Part_7225_31891721.1197892390161-- -- http://www.freelists.org/webpage/oracle-l