839396 wrote:No error will be throw. BUT the Protection Mode is revert back to MAXIMUM PERFORMANCE mode.
In 11g databgurad i am setting the Protection mode of Primary to : Maximum protection at the DB level(so that it uses sync)
But while defining in init file if i say ASYNC for standby DB as mentioned below
LOG_ARCHIVE_DEST_2= 'SERVICE=boston ASYNC
Then will setting will take precednce , SYNC from maximum protection mode defined at DB level (or) ASYNC which is defined in init file?
(or) will it throw error if there is any mismatch?
SYNC is a major attributes you need to set, if you want MAXIMUM PROTECTION mode.
SQL> alter database SET STANDBY DATABASE TO MAXIMIZE PROTECTION; Database altered. Perform a log switch at the primary DB i.e alter system switch logfile; SQL> select PROTECTION_MODE from v$database; PROTECTION_MODE -------------------- MAXIMUM PERFORMANCE SQL>