Re: does FRA is really needed ?

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_at_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

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