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 […]