Monday, November 11, 2013

Error: ORA-16651: requirements not met for enabling fast-start failover

When I try to enable the fast start failover in the data guard below I got the below error message
Error: ORA-16651: requirements not met for enabling fast-start failover
DGMGRL> show configuration;
Configuration - DG_BHU
  Protection Mode: MaxAvailability
  Databases:
    BHU_A - Primary database
    BHU_B - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> show fast_start failover;
Fast-Start Failover: DISABLED
  Threshold:        90 seconds
  Target:           (none)
  Observer:         Bhuvan_observer
  Lag Limit:        30 seconds
  Shutdown Primary: TRUE
  Auto-reinstate:   TRUE
Configurable Failover Conditions
  Health Conditions:
    Corrupted Controlfile          YES
    Corrupted Dictionary           YES
    Inaccessible Logfile            NO
    Stuck Archiver                  NO
    Datafile Offline               YES

  Oracle Error Conditions:
    (none)

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.
Ex:
 edit database 'BHU_A' set property FastStartFailoverTarget='BHU_B';
edit database 'BHU_B' set property FastStartFailoverTarget='BHU_A';