This content has been marked as final. Show 2 replies
Requirements for Maximum Protection mode:
Redo Transport mode: SYNC
Disk Write Option: AFFIRM
Standby Redo Logs: Yes
Standby Database Type: Physical
so use like this
.log_archive_dest_2='SERVICE=cdssty LGWR SYNC AFFIRM VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=cdssty'
or read more on :
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?
you can confirm this in the alert log and v$database on the standby DB
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>