Exam 1z0-066 topic 1 question 86 discussion

Actual exam question from Oracle's 1z0-066

Question #: 86
Topic #: 1

Examine the Data Guard configuration:
DGMGRL > show configuration;

Configuration-Animals -
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
dogsfsl Far Sync
sheep- Physical standby database

Fast-Start Failover: DISABLED -
Configuration Status:

SUCCESS -
An attempt to enable fast-start failover raises an eror:
DGMGRL> enable fast_start failover;
Error: ORA-16693: requirements not met for enabling fast-start failover
Failed.
Identify two possible reasons for this error.

A. The FastStartFailoverTarget property is not set on Sheep.
B. The FastStartFailoverTarget property is not set on Dogs.
C. The FastStartFailoverTarget property is not set on DogsFS1.
D. The LogXptMode property is set to ASYNC on Dogs.
E. The RedoRoutes property is not set on Dogs.
F. The RedoRoutes property is not set on DogsFS1.

Show Suggested Answer

Suggested Answer: AD 🗳️
D: Ensure that the LogXptMode property for both the primary database and the Fast-Start Failover target standby database are SYNC.
A: If more than one physical or logical standby database exists, in this case it is the sheep database, you must specify the FastStartFailoverTarget value explicitly, prior to enabling fast-start failover. The indicated target is verified when fast-start failover is enabled.
Note: DGMGRL> enable fast_start failover;
Error: ORA-16651: requirements not met for enabling fast-start failover
Failed.

SOLUTION -
1) Check whether the flashback database is enabled on primary & standby database
Select flashback_on from gv$database;
2) Check whether you have set the FastStartFailoverTarget parameter.
References:
https://docs.oracle.com/cd/E11882_01/server.112/e40771/dbpropref.htm#DGBKR862 http://psoug.org/oraerror/ORA-16651.htm

by marpayer at May 5, 2021, 12:30 p.m.

Comments

Submit Cancel

ScottL

1 year, 7 months ago

Answer: D and E ORA-16693 - requirements not met for enabling fast-start failover Cause The attempt to enable fast-start failover could not be completed because one or more requirements were not met: The effective redo transport mode for both the primary database and the fast-start failover target standby database must be set to either SYNC or FASTSYNC if the configuration protection mode was set to MaxAvailability mode.

upvoted 1 times

...

JESUSBB

2 years ago

Answer: D and E

upvoted 2 times

...

Giangtd

3 years, 7 months ago

To enable fast-start failover when a far sync instance is used to ship redo data to the standby database, the FastStartFailoverTarget property must first be set on both the primary and target standby database

upvoted 1 times

Giangtd

3 years, 7 months ago

AB correct answer

upvoted 2 times

...

marpayer

4 years ago

I think B and F B - because the FastStartFailover target must be enable on the primary (dog) F - if you use FarSync (DogsFS1) to send redo to the target standby you must define RedoRoutes

upvoted 1 times

...

Exam 1z0-066 All Questions

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

Exam 1z0-066 topic 1 question 86 discussion

Comments

ScottL

JESUSBB

Giangtd

Giangtd

marpayer

SY0-701