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';
No comments:
Post a Comment