Examice

You must propose an Oracle Data Guard configuration for a database supporting an OLTP workload that meets these permanent requirements:

1. Data loss is not permitted.

2. Read-only applications should not connect to the primary database instance.

Additionally, there are these requirements, only one of which is ever done at any one time:

3. It should be possible to apply and test designated patches with a minimum amount of downtime.

4. Upgrading to a new database release should be performed with the least possible amount of downtime.

5. New application software releases should be tested against an exact up-to-date replica of the production database.

You propose a primary database with one physical standby database configured in Maximum Protection mode.

Which requirements do you meet?

Correct Answer: B

The configuration of a primary database with one physical standby database in Maximum Protection mode meets the requirement of zero data loss (requirement 1). A physical standby database can be used for read-only applications, keeping them off the primary database (requirement 2). For applying and testing patches with minimal downtime, a physical standby can be switched over to become the primary database temporarily (requirement 3). Database upgrades can be performed on the standby database and then switched over to minimize downtime (requirement 4). Finally, an exact up-to-date replica allows testing new application software releases without impacting the production environment (requirement 5). Therefore, this configuration meets all five requirements.