Exam 1z0-066 topic 1 question 80 discussion

Actual exam question from Oracle's 1z0-066

Question #: 80
Topic #: 1

Examine the Data Guard configuration:
DGMGRL> show configuration;

Configuration Animals -

Protection Mode: MaxPerformance -
Databases:
dogs- Primary database
sheep- Physical 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 Protection:
DGMGRL> edit configuration set protection mode as maxprotection:
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode
Failed.
What can you conclude based on this error?

A. Cats is a snapshot standby database.
B. The redo transport mode is set to ASYNC for the standby database Sheep.
C. The redo transport mode is set to ASYNC for both standby databases.
D. The redo transport mode is set to ASYNC for the standby database Cats.

Show Suggested Answer

Suggested Answer: B 🗳️
Sheep is the Physical standby database.
Error cause: The broker rejects an attempt to change the configuration"s overall protection mode since it could not find any online, enabled standby databases that support the proposed protection mode.
Action: If changing the overall protection mode, confirm that at least one standby database satisfies the new protection mode.
References:
http://psoug.org/oraerror/ORA-16627.htm

by JESUSBB at May 3, 2023, 10:32 p.m.

Comments

Submit Cancel

Rockfics

1 year, 3 months ago

Selected Answer: B

In the state of Snapshot Standby can't be used for Maximum Protection, so the other standby have to be SYNC. For Maximum Protection with the requirement of Snapshot Standby must exist 2 minimum 1 standby for SYNC and other for Snapshot

upvoted 1 times

...

JESUSBB

1 year, 9 months ago

Answer: B

upvoted 1 times

...

Exam 1z0-066 All Questions

View all questions & answers for the 1z0-066 exam

Exam 1z0-066 topic 1 question 80 discussion

Comments

Rockfics

JESUSBB

SY0-701