Re: Detail of the TAF mecanism used with Rac Guard or even just RAC

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Mon, 6 Dec 2004 03:21:35 -0800 (PST)
Message-ID: <20041206112135.9673.qmail@web52604.mail.yahoo.com>

Hi Peter,

The most of the TAF functionality is done on the client side as you probably know.

That means your client side is full of the hidden OCI variables (some accesible through regular OCI calls) that are used to retry the cursor in the TAF environment and even continue from the place where it stopped (RETRY).

Just imagine your code that can do the similar thing. Many apps are doing that already manually without using OCI functionality. Not a big deal. Just Oracle will do this much better because of knowing a lots of internals (sometimes not true :)

In this case Oracle client side just do it for you.

Regards,
Zoran

• LOMAX Peter Ext ROSI/SIFAC <plomax.ext_at_francetelecom.com> wrote:

> Good morning,
>
> I have scurged the documents on this to no avail.
> I wish to fully understand how a cursor is replayed
> at the point where it left off whilst using a TAF
> connection.
>
> I have defined a TAF connection with a PRECONNECT
> using both Primary and Secondary
> connections each including a backup to each other.
>
> So I already have a connection to the second
> instance open as well as the first instance, of
> course.
>
> Boom, my instance fails then my SELECT is FAILEDOVER
> to the surviving instance.
> With the First instance as Primary I had already
> displayed lines 1 to 100.
> The client connection uses my defined backup
> connection: DED_PRE or DED_BASIC.
>
> When the second instance takes over as now the
> PRIMARY instance my select resumes at exactly the
> same place it left off.
>
> For clarity, my libcache update job has not updated
> the executed SQL from the first instance onto the
> second instance.
>
> So the cursor must be copied, re -executed and a
> reference to the current rownum must be passed.
>
> Question:
> Can someone explain from where the SQL and rownum is
> obtained?
>
> Regards,
> Peter
>
> --
> Peter Lomax
> tel: 0155881546
> fax: 0155881594
> 65-67, avenue Vladimir Illich Lénine
> 94110 Arcueil
> SIFAC / DO-NSFM
> email: plomax.ext_at_francetelecom.com
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
                

---

Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250

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

Received on Mon Dec 06 2004 - 05:17:05 CST