SYNC and ASYNC for Physical Standby DB's
Dear Friends,
In 11g databgurad ,
I planned to used 2 physical standy once in the same LAN and another in the DR site
I need to have SYNC between primary and Standby 1 which is in same LAN
I need to have ASYNC between primary an standy 2 which is in DR site
Is it possible , if so how do i achieve this?
Because i believe SYNC and ASYNC will be decided by oracle internally based on the Protection mode we choose so in that case
we can't have mix up (SYNC and ASYNC) for standby databases?
Regards,
DB