<<Back to Oracle DataGuard Main Page
What are Oracle Data Guard Protection Modes?
The Oracle Data Guard Protection Mode defines the availability of the data on the standby database. An Oracle Data Guard configuration always runs in one of three data protection modes.Maximum Protection
Maximum Availability
Maximum Performance (default mode of operation)
Maximum Protection
This protection mode guarantees 0 data loss. To guarantee the availability of data no data loss on the standby database in case of Primary database failure, The commit on the primary only succeeds if an only if the redo data needed to recover each transaction must be written to both the local online redo log and to a standby redo log on at least one standby database.
If in case no standby destination is available to primary the primary also goes unavailable resulting in an outage for the application.
Maximum Availability
This protection mode provides the highest level of data protection without affecting the availability of the primary database. This means in this mode also the commit of a transaction is only completed if the redo is written on at least on standby destination but if the standby database is not available due to any reason (eg n/w disconnection) the primary is still up and available (with compromised data availability) in RESYNCHRONIZATION mode, as soon as the standby database is available and again synchronized with the primary database, The primary database again starts operating in maximum availability mode
Maximum Performance
This mode provides the possible highest level of data protection without affecting the performance and availability of the primary database.
This is accomplished by allowing the transaction to commit as soon as the redo data to recover the transaction is written to the local redo logfile
How to Find the Protection of The database
SQL> select protection_mode, protection_level from v$database;How to Change the Protection Mode of the Database
SQL> alter database set standby database to maximize {AVAILABILITY | PERFORMANCE | PROTECTION};
Using Broker
DGMGRL> edit configuration set protection mode as {AVAILABILITY | PERFORMANCE | PROTECTION};
Related Posts
Oracle Data Guard an Overview
How Oracle Data Guard Works
Related Posts
Oracle Data Guard an Overview
How Oracle Data Guard Works
Sweet blog! I found it while searching on Yahoo News. Do you have any tips on how to get listed in Yahoo News? I've been trying for a while but I never seem to get there! Many thanks. How To Insulate A Shipping Container
ReplyDelete