Re: data guard fast start failover

From: Mark Strickland <strickland.mark_at_gmail.com>
Date: Sun, 18 Jan 2009 14:17:15 -0800
Message-ID: <90ad14210901181417i3fed1d86h4c5d588f3e12b92e_at_mail.gmail.com>

I'll find out more from our WebLogic SME, but we're using WebLogic multi-pools (multi-datasources?), ie each server running WebLogic has three connection pools -- one for each of the RAC instances. The connections do re-connect automatically after failover. We're finding that it takes 60-90 seconds for failover and reconnect. I believe that we are using WebLogic XA transactions but I'll verify.

-Mark

On Sun, Jan 18, 2009 at 1:49 PM, Alex Gorbachev <ag_at_oracloid.com> wrote:

> Hi Mark,
> Could you elaborate on WebLogic config you are using for RAC?
> - Is it configured using WebLogic multi-datasources?
> - Do you use WebLogic XA transactions? Does WebLogic datasource re-tries
> transaction on reconnect?
> - What are the patched you mentioned (perhaps, you have the reference to
> the WebLogic support docs)?
>
> Cheers,
> Alex
>
> On 17/01/2009, at 8:52 AM, Mark Strickland wrote:
>
> We've been testing FSF with 10.2.0.2 and my co-DBA discovered a bug that
> can cause a split-brain to occur. I don't remember the exact circumstances,
> but the fix is in 10.2.0.4 which is driving us to apply that patchset. Our
> FSF testing with 10.2.0.4 has been going very well. If you use WebLogic, it
> will handle a failover but it requires a patch depending on what version you
> use. I've been doing new 10.2.0.4 builds with RAC and Data Guard with FSF
> for a new customer. No issues so far.
>
> Mark
> Seattle, WA
>
>
> On Thu, Jan 15, 2009 at 11:27 PM, <Laimutis.Nedzinskas_at_seb.lt> wrote:
>
>>
>> Hi all
>>
>> Anyone's using data guard fast-start failover ?
>> What are the experiences ?
>> What about split brain?
>> Does it interfere heavily with normal database activities?
>> Any other comments?
>>
>> Thank you in advance,
>>
>> Laimis N
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>

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

Received on Sun Jan 18 2009 - 16:17:15 CST