Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 34
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.
Answer options
- 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.
Correct answer: A, D
Explanation
The error ORA-16693 indicates that the requirements for enabling fast-start failover are not satisfied, and one likely reason is that the FastStartFailoverTarget property must be set for the standby database Sheep (Option A). Additionally, for fast-start failover to function properly, the LogXptMode property should ideally be set to SYNC, and if it's ASYNC on Dogs (Option D), it can also prevent fast-start failover from being enabled.