René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback

Protection modes in Data Guard

There are three protection modes in Data Guard: Maximum protection, maximum availability and Maximum performance (9iR2).
The protection mode can be determined by the protection_mode (and protection_level) column in v$database.

Available protection modes

Maximum protection

Maximum availability

Maximum performance

Changing the protection mode

alter database set standby database to maximize [protection|availability|performance]