Which configuration meets these requirements with the f…

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?

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



Leave a Reply 3

Your email address will not be published. Required fields are marked *


tania

tania

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