You must design an Oracle Data Guard configuration for an OLTP database 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:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. New application software releases should be tested against an exact and up-to-date replica of the primary
database.
Which configuration meets these requirements with the fewest databases?
A.
a primary database with three physical standby databases
B.
a primary database with one logical and two physical standby databases
C.
a primary database with one logical standby database
D.
a primary database with one logical and one physical standby database
E.
a primary database with two physical standby databases
F.
a primary database with one physical standby database
D
Hi , I would choose E :
1.Data loss is not permitted so we need Maximum Protection ,
in that case Oracle recommends to have two standby’s .
We need one physical standby for data protection ,
3. New application software releases should be tested against an exact and up-to-date replica of the primary database.
So we need a second physical standby which will be converted temporarily to a snapshot standby for testing.
A logical standby does not guarantee to have the same data as on the primary.
Applying patches can be done using a transient logical standby
D