exam questions

Exam 1z0-066 All Questions

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

Exam 1z0-066 topic 1 question 86 discussion

Actual exam question from Oracle's 1z0-066
Question #: 86
Topic #: 1
[All 1z0-066 Questions]

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 Hide 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

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
ScottL
1 year, 3 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
1 year, 9 months ago
Answer: D and E
upvoted 2 times
...
Giangtd
3 years, 3 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, 3 months ago
AB correct answer
upvoted 2 times
...
...
marpayer
3 years, 9 months 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago