Time for action – configuring fast-start failover
The following steps will help you configure FSFO in a configuration managed by the Data Guard broker:
Check if Data Guard is in the Maximum Performance(11gRx) or Maximum Availability mode using the following command:
DGMGRL> show configuration Configuration - PACKT Protection Mode: MaxPerformance Databases: TURKEY_UN - Primary database INDIA_UN - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS
If your configuration is in the Maximum Availability mode, make sure that
LogXptMode
is set to synchronous redo transport.Make sure you have configured a flashback database and fast recovery area. This is applicable on both the primary and standby databases and helpful in case you want to reinstate the old primary database or perform a flashback as shown in the following query:
SQL> select flashback_on from v$database; FLASHBACK_ON ------------------ NO
We must set some parameters before turning...