We have seen overview and prerequisites of fast-start failover in the previous post. Fast Start Failover in Data Guard Steps to configure fast start fail over . Step 1 : Connect to dgmgrl and check the configuration
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production Copyright (c) 2000, 2009, Oracle. All rights reserved. Welcome to DGMGRL, type "help" for information. DGMGRL> connect sys/oracle Connected. DGMGRL> show configuration; Configuration - dgconfig1 Protection Mode: MaxPerformance Databases: testdb - Primary database std_testdb - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS |
Step 2 : set faststartfailovertarget property.
1 2 3 4 |
DGMGRL> EDIT DATABASE TESTDB SET PROPERTY FASTSTARTFAILOVERTARGET=STD_TESTDB; Property "faststartfailovertarget" updated DGMGRL> EDIT DATABASE STD_TESTDB SET PROPERTY FASTSTARTFAILOVERTARGET=TESTDB; Property "faststartfailovertarget" updated |
Step 3 : set protection mode if not already set […]