Overview of Oracle Database DataGuard

Protection Modes

• Maximum Availability: This mode provides the highest level of data protection by ensuring zero data loss during primary database shutdown or failure.

• Maximum Performance: This mode aims to minimize any performance impact on the primary database by allowing potential data loss in case of a disaster. In this mode, the primary database does not wait for confirmation from one or more standby databases before committing transactions.

• Maximum Protection: This mode prioritizes data safety over performance by ensuring that transactions are not considered committed until all configured standby databases have received and written the redo data. As a result, it provides the highest resilience against data loss but may have an impact on primary database performance.