Nihar,
This is not normal. Asynchronous propagation
populates the deferred transactions queues which are
then pushed at a later time, so the only thing that
should happen when network connectivity is lost is
that the job pushing the queues will fail. Once
connectivity is re-established the job wil lresume
pushing, unless it failed 16 times and was marked
broken in which case it will need to be manually run
or marked unbroken.
Even with synchronous replication it shouldn't hang
indefinitely. Eventually a timeout will be reached
and an error will be returned since the transaction
cannot commit at all sites.
What Oracle and OS versions are involved?
When your insert session is hanging, what is the wait
event in V$SESSION_WAIT for that session?
HTH,
- Anita
--- Nihar <nihar_at_netmagicsolutions.com> wrote:
> Hi!
>
> Well, i am not going to remove the link but What
> if the internet
> connectivity fails. My DB servers are at different
> locations and i am doing
> it through WAN link .Is there any way to queup the
> data till links come up.
> thanks
>
> -Nihar
>
> -----Original Message-----
> Sent: Tuesday, May 22, 2001 3:56 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Nihar,
>
> Don't remove the network link!!
>
> O.K....I'm not a replication guru, but my thoughts
> are that the way
> replication is setup, the commit can only happen if
> the data can be
> replicated as it should. If there is no network
> connectivity, the instance
> cannot get to one of the other required
> instances...and it hangs until it
> finds it.
>
> Ed Haskins
> Oracle DBA
> Verizon Wireless
>
> -----Original Message-----
> Sent: Monday, May 21, 2001 5:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> hi gurus
>
> My Asynchronus multimaster replication is working
> fine. But the moment i
> remove the physical connectiviy (network link),it
> hangs without even
> updating local data base. i mean it's not allowing
> me to commit insert
> statement at one location.
> Can anybody helps me in this.
>
> thanks
>
> -Nihar
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Nihar
> INET: nihar_at_netmagicsolutions.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Haskins, Ed
> INET: Ed.Haskins_at_VerizonWireless.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Nihar
> INET: nihar_at_netmagicsolutions.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon May 21 2001 - 21:23:19 CDT
