Fabricio_Jorge wrote: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.
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.