Exam 1z0-066 topic 1 question 3 discussion

Actual exam question from Oracle's 1z0-066

Question #: 3
Topic #: 1

Examine the Data Guard configuration:
DGMGRL > show configuration;

Configuration-Animals -

Protection Mode: MaxPerformance -
Databases:
dogs-Primary database
sheep-Snapshot standby database
cats-Snapshot standby database

Fast-Start Failover: DISABLED -
Configuration Status:

SUCCESS -
You receive an error while attempting to raise the protection mode to Maximum Availability:
DGMGDRL> edit configuration set protection mode as maxavailability;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode
Failed.
Identify two statements that you can execute, either one of which will enable successful raising of the protection mode to Maximum Availability.

A. DGMGRL> convert database sheep to physical standby;
B. DGMGRL> convert database cats to physical standby;
C. DGMGRL> edit database dogs set property LogXptMode= fastsync;
D. DGMGRL> edit database sheep set property LogXptMode= fastsync;
E. DGMGRL> edit database cats set property LogXptMode= sync;

Show Suggested Answer

Suggested Answer: BE 🗳️
The MAXAVAILABILITY protection mode requires that there be at least one standby database configured to use standby redo log files, with its LogXptMode configurable database property set to SYNC.
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28295/cli.htm

by Kamaelk at Feb. 20, 2020, 3:10 p.m.

Comments

Submit Cancel

JESUSBB

2 years, 5 months ago

Answer: D y E

upvoted 1 times

...

Sugar

3 years, 3 months ago

I agree guys D E. fastsync is the new feature since Oracle 12C

upvoted 2 times

...

FelipeK

4 years, 3 months ago

Correct answer D,E

upvoted 3 times

...

Kamaelk

4 years, 11 months ago

One more test. Configuration - orcl_m2-1z0-066.ora.lab Protection Mode: MaxPerformance Members: orcl3 - Primary database orcl1 - Snapshot standby database orcl - Snapshot standby database Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 9 seconds ago) DGMGRL> edit configuration set protection mode as maxavailability; Error: ORA-16627: operation disallowed since no member would remain to support protection mode What we gona do? DGMGRL> edit database orcl1 set property LogXptMode='SYNC'; Property "logxptmode" updated DGMGRL> edit configuration set protection mode as maxavailability; Succeeded. Revent back: DGMGRL> edit configuration set protection mode as maxperformance; Succeeded. DGMGRL> edit database orcl1 set property LogXptMode='ASYNC'; Property "logxptmode" updated DGMGRL> edit database orcl1 set property LogXptMode='fastsync'; Property "logxptmode" updated DGMGRL> edit configuration set protection mode as maxavailability; B is Wrong! Correct answer is E and D