This discussion is archived
3 Replies Latest reply: Mar 18, 2013 6:58 AM by CKPT RSS

Data guard and network slowness

Fabricio_Jorge Explorer
Currently Being Moderated
Hi all,

I would like to hear (or read) from you all, how actually find out if the network is a "problem" in a data guard configuration. For example, if a have two sites, SITE A (primary) and SITE B (standby away from site a with a distance of 20 miles, for example). This configuration is using SYNC redo log transmition (Max protection).

The main doubt here is: With the configuration above explained, how to find if i have a network problem, regarding slowness? For example, does AWR report something related to this? What OS tool should i use to discover this slowness (ping?).

Thanks in advance.
  • 1. Re: Data guard and network slowness
    mseberg Guru
    Currently Being Moderated
    Hello;

    I cannot remember your OS but Wireshark does a great job :

    http://www.wireshark.org/


    You can also set the Oracle Net SDU parameter :

    http://docs.oracle.com/cd/B19306_01/server.102/b14239/troubleshooting.htm#i635902

    ( I don't believe this has changed since Oracle 10 )

    Best Regards

    mseberg
  • 2. Re: Data guard and network slowness
    Fabricio_Jorge Explorer
    Currently Being Moderated
    Ops, sorry for not mentioning the SO. I'm using a Oracle Linux 6 with Oracle version 11.2.0.3.

    Thanks for your suggestions.
  • 3. Re: Data guard and network slowness
    CKPT Guru
    Currently Being Moderated
    Fabricio_Jorge wrote:
    Hi all,

    I would like to hear (or read) from you all, how actually find out if the network is a "problem" in a data guard configuration. For example, if a have two sites, SITE A (primary) and SITE B (standby away from site a with a distance of 20 miles, for example). This configuration is using SYNC redo log transmition (Max protection).

    The main doubt here is: With the configuration above explained, how to find if i have a network problem, regarding slowness? For example, does AWR report something related to this? What OS tool should i use to discover this slowness (ping?).

    Thanks in advance.
    For maximum protection it is recommended to use at least more than one standby database, So that synchronously it can write at least on one standby. so you must have either good band width or distance should be less, In that case if you have two standby one can be near where there is no network problems and for high availability it can be other location.
    In AWR reports you can see the wait class type related to network also, But AWR can give you most information from the database. Not from the OS level network latency, port latency, ping packet lost so on.

    You can also work out on SDU/TDU as mentioned by Mseberg, You can check some good information on Redo transport and network best practices from http://www.oracle.com/technetwork/database/features/availability/maa-wp-10gr2-dataguardnetworkbestpr-134557.pdf

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points