Exam 1z0-066 topic 1 question 11 discussion

Actual exam question from Oracle's 1z0-066

Question #: 11
Topic #: 1

Examine the Data Guard configuration:
DGMGRL> show configuration;

Configuration Animals -
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
cats- Snapshot standby database
sheep- Snapshot standby database

Fast-Start Failover: DISABLED -
Configuration Status:

ORA-01034: ORACLE not available -
ORA-16625: cannot reach database "dogs"
DGM-17017: unable to determine configuration status
You wish to perform a failover to Sheep.
Which command, or sequence of commands, should you issue to the broker before executing "failover to sheep", using the broker?

A. DGMGRL> convert database cats to physical standby;
B. DGMGRL> convert database sheep to physical standby;
C. DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical standby;
D. DGMGRL>edit configuration set protection mode as maxperformance; DGMGRL> convert database sheep to physical standby;
E. None, because you can directly failover to a Snapshot Standby Database.

Show Suggested Answer

Suggested Answer: C 🗳️
Note: Oracle Error: ORA-16625 -
Error Description:

Cannot reach the database -
Error Cause:
The broker rejected an operation requested by the client when the database required to execute that operation was not reachable from the database where the request was made. If the request modifies the configuration, the request must be processed by the copy of the broker running on an instance of the primary database.
Action:
Check your network connections between all of the databases in the configuration. Alternatively, you can connect your client to a different database in the Data
Guard broker configuration and try your request again. If you are simply attempting to determine the status of a particular database in the configuration, you may connect your client to that database and get the current value of the StatusReport property for that database.
References:
http://psoug.org/oraerror/ORA-16625.htm

by marpayer at May 5, 2021, 4:16 p.m.

Comments

Submit Cancel

Rogazan

Highly Voted 3 years, 6 months ago

E is TRUE A snapshot standby cannot be the target of a switchover or fast-start failover operation. You can, however, perform a manual failover to a snapshot standby.

upvoted 6 times

...

ScottL

Most Recent 1 year, 3 months ago

Selected Answer: E

Note:A snapshot standby cannot be the target of a switchover or fast-start failover operation. You can, however, perform a manual failover to a snapshot standby. https://docs.oracle.com/en/database/oracle/oracle-database/18/dgbkr/using-data-guard-broker-to-manage-switchovers-failovers.html#DGBKR3546

upvoted 1 times

...

JESUSBB

2 years, 5 months ago

Answer: C

upvoted 1 times

...

marpayer

3 years, 9 months ago

I believe only B is needed B. DGMGRL> convert database sheep to physical standby;

upvoted 2 times

...

Exam 1z0-066 All Questions

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