Oracle 12c-Testing the Oracle Data Guard Fast-Start Failover

Oracle 12c-Testing the Oracle Data Guard Fast-Start FailoverDescription:-

We have already enabled the Fast Start Failover,now we are going to testing the Failover.

Oracle 12c-Configure Oracle Data Guard Fast-Start Failover Here

Environment Details:-

Let’s Start the Demo:-

Step1:-Show the configuration

DGMGRL> SHOW CONFIGURATION;
Configuration – hari
Protection Mode: MaxAvailability
Members:
prime – Primary database
stand – (*) Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS (status updated 10 seconds ago)

Step2:-check the observer session is running to monitor the primary & standby 

oracle@primary ~]$ export ORACLE_SID=prime
[oracle@primary ~]$ dgmgrl
DGMGRL for Linux: Version 12.1.0.2.0 – 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type “help” for information.
DGMGRL> connect sys/oracle@prime
Connected as SYSDBA.
DGMGRL> enable fast_start failover;
Enabled.
DGMGRL> start observer;
Observer started

SQL> select FS_FAILOVER_STATUS,FS_FAILOVER_OBSERVER_PRESENT from v$database;

FS_FAILOVER_STATUS FS_FAIL
———————- ——-
SYNCHRONIZED YES

Step3:-kill the Smon process in primary database

To simulate a fast start failover,i will kill the smon proceess in primary database so that it looses the connectivity with the observer and the standby database.

[oracle@primary ~]$ ps -ef|grep smon
oracle 4528 1 0 00:13 ? 00:00:00 ora_smon_prime
oracle 7150 7136 0 03:48 pts/4 00:00:00 grep smon
[oracle@primary ~]$ kill -9 4528
[oracle@primary ~]$

Step4:-observer start the failover

DGMGRL> start observer;
Observer started

03:49:34.53 Thursday, June 14, 2018
Initiating Fast-Start Failover to database “stand”…
Performing failover NOW, please wait…
Failover succeeded, new primary is “stand”
03:49:41.17 Thursday, June 14, 2018

Step5:-Automatically Initiating the reinstate command in observer session. (just mount the old primary database)

03:52:49.20 Thursday, June 14, 2018
Initiating reinstatement for database “prime”…
Reinstating database “prime”, please wait…
Reinstatement of database “prime” succeeded
03:53:10.82 Thursday, June 14, 2018

Step6:-show the configuration 

DGMGRL> show configuration;
Configuration – hari
Protection Mode: MaxAvailability
Members:
stand – Primary database
prime – (*) Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS (status updated 54 seconds ago)

Catch Me On:- Hariprasath Rajaram

LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter:  https://twitter.com/hariprasathdba