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 19

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


PeraDetlic

PeraDetlic

Correct is B.

Option ‘D’ doesn’t meet *permanent requirements*.

Wim J

Wim J

I agree with option B

primary +
logical standby: rolling upgrade
phys standby (snapshot)
phys standby with real time query enabled

Wim J

Wim J

E is also valid?

One physical standby for RTQ (req 1 & 2)
One physical standby for 3 (converting to snapshot), temporarily converted to logical (for 1 & 2), as the extra requirements are ‘one at a time’.

This requires 3 db’s, option B has 4 db’s.

sm

sm

I agree with E…

JFK

JFK

“E” does not meet:
2. Upgrading to a new database release should be performed with the least possible amount of downtime.

YK6

YK6

@JFK but you can temporary convert one of physstdby to logical.
ps. when will you take exam?

JAG

JAG

Did anyone sit for this exam ? I came to know that the Q’s are changed.

YK6

YK6

about half questions currently unknown

JAG

JAG

Hi YK6, when you sat for exam ?

YK6

YK6

my coleage pass this exam week ago

raul

raul

i think B, is correct because:
one physical with Active data guard allow read only querys connect to standby and not to primary, this is a permanent requeriment

one logical standby allow, rolling upgrades and patches
“It reduces downtime associated with database upgrade from potentially hours to seconds.”
http://www.oracle.com/technetwork/database/availability/database-rolling-upgrade-3206539.pdf

and,

with a snapshot over the second physical standby allow, test new releases with up-to-date copy of database.

regards.

edge

edge

Hi Raul

I agree with you. I Think B is the correct answer.

Thanks

ssseee

ssseee

can someone share the full pdf version of this exam?

JFK

JFK

Go study 🙂

ssseee

ssseee

i want to study. But some diagrams can not be seen from this website.

PK

PK

Data loss is not permitted leads to “Maximum Protection” mode.
For maximum protection mode you need at least one physical standby but oracle recommends two as lost of one will force shutdown of primary db.
Thus C is incorrect as only one logical standby is simply not enough.
Also – as I guess this is oracle exam they want us to answer with recommended/best practice solution – F is incorrect. Nevertheless only one physical standby is not enough for other requirements.
For “Maximum Protection” always one physical db will be reserved and couldn’t be used. Second physical standby can be converted to snapshot standby (for application release testing) it can be used for dataguard rolling upgrade (upgrade to new database release).
I don’t see any use for logical standby based on these requirements.
Summary – E is correct as you need at minimum 2 physical standbys.

JorgeZG

JorgeZG

Hello community
I took the Exam 2 days ago and approved with 85%. Most of the Questions here are in the Exam with some changes and different situations.
There are many Questions with database Dog, Sheep and Cat with different Situations.

Obviously there are still here Questions that are missing but they could be answered if you study well.