839396 wrote:I think John already mentioned how to do, let me derive more .
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?
Uwe Hesse wrote:Uwe,
There's a little mistake in the log_archive_dest_2 part:
SQL> alter system set log_archive_dest_2='SERVICE=same_lan SYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=<db_unique_name>'
instead it should be SYNC AFFIRM
Furthermore, with the usage of DG Broker, that whole log_archive_dest_2 setting is done automatically when you just specify LogXptMode=SYNC for the first standby - it will especially avoid the above mistake :)
"Don't believe it, test it"