To know about Fast Start Failover in Data Guard To disable Fast_Start failover apply following command :
|
1 |
DGMGRL> DISABLE FAST_START FAILOVER; |
When we perform above command Fast_Start failover is first disabled on target standby database with data guard broker then it is disabled from the primary database. Then these changes are propagated to all standby database present in the […]
Here I am simulating scenario for fast-start failover. Configuring Fast-Start Fail Over Step 1: View fast_start failover is enabled or not.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
DGMGRL> show configuration; Configuration - drdb Protection Mode: MaxAvailability Databases: testdb - Primary database std_testdb - (*) Physical standby database Fast-Start Failover: ENABLED Configuration Status: SUCCESS |
Step 2: I am aborting the Simulating and Restriction After enabling FAST_START failoverdatabase.
|
1 2 3 |
SQL> shut abort ORACLE instance shut down. SQL> exit |
Step 3: Check observer
|
1 2 3 4 5 6 |
DGMGRL> start observer Observer started16:22:49.59 Saturday, June 23, 2018 Initiating Fast-Start Failover to database "std_testdb"... Performing failover NOW, please wait... Failover succeeded, new primary is "std_testdb" 16:23:02.29 Saturday, June 23, 2018 |
Step 4: Now again I am starting a primary database.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
[oracle@test1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Jun 23 16:23:21 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 663908352 bytes Fixed Size 2256192 bytes Variable Size 578814656 bytes Database Buffers 79691776 bytes Redo Buffers 3145728 bytes Database mounted. ORA-16649: possible failover to another database prevents this database from being opened |
Step 5: check […]