By Mouhamadou Diaw
In Oracle 20c, we can now validate a Fast Start Failover configuration with the new command VALIDATE FAST_START FAILOVER. This command will help identifying issues in the configuration. I tested this new feature.
The Fast Start Failover is configured and the observer is running fine as we can see below.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
DGMGRL> show configuration verbose Configuration - prod20 Protection Mode: MaxPerformance Members: prod20_site1 - Primary database prod20_site2 - (*) Physical standby database (*) Fast-Start Failover target Properties: FastStartFailoverThreshold = '30' OperationTimeout = '30' TraceLevel = 'USER' FastStartFailoverLagLimit = '30' CommunicationTimeout = '180' ObserverReconnect = '0' FastStartFailoverAutoReinstate = 'TRUE' FastStartFailoverPmyShutdown = 'TRUE' BystandersFollowRoleChange = 'ALL' ObserverOverride = 'FALSE' ExternalDestination1 = '' ExternalDestination2 = '' PrimaryLostWriteAction = 'CONTINUE' ConfigurationWideServiceName = 'prod20_CFG' ConfigurationSimpleName = 'prod20' Fast-Start Failover: Enabled in Potential Data Loss Mode Lag Limit: 30 seconds Threshold: 30 seconds Active Target: prod20_site2 Potential Targets: "prod20_site2" prod20_site2 valid Observer: oraadserver2 Shutdown Primary : TRUE Auto-reinstate: TRUE Observer Reconnect: (none) Observer Override: FALSE Configuration Status: SUCCESS DGMGRL> |
If we run the command we can see that everything is working and that a failover will happen if needed
1
2
3
4
5
6
7
|
DGMGRL> VALIDATE FAST_START FAILOVER; Fast-Start Failover: Enabled in Potential Data Loss Mode Protection Mode: MaxPerformance Primary : prod20_site1 Active Target: prod20_site2 DGMGRL |
Now let’s stop the observer
1
2
3
|
DGMGRL> stop observer Observer stopped. |
And if we run the Validate command again, we have the following message
1
2
3
4
5
6
7
8
9
10
11
|
DGMGRL> VALIDATE FAST_START FAILOVER; Fast-Start Failover: Enabled in Potential Data Loss Mode Protection Mode: MaxPerformance Primary : prod20_site1 Active Target: prod20_site2 Fast-start failover not possible: Fast-start failover observer not started. DGMGRL> |