1. Home
  2. Knowledge Base
  3. High Availability
  4. 10g Data Guard Broker Fast Start Failover

10g Data Guard Broker Fast Start Failover

FAST START FAILOVER IS DISABLED BY DEFAULT

Configuration
  Name:                streams2.hq.emirates.com
  Enabled:             YES
  Protection Mode:     MaxAvailability
  Fast-Start Failover: DISABLED  Databases:
    streams2 - Primary database
    blade08  - Physical standby database

Current status for "streams2.hq.emirates.com":
SUCCESS

PREPARE TO ENABLE TO FAST START FAILOVER

DGMGRL> EDIT DATABASE 'streams2' SET PROPERTY FastStartFailoverTarget = 'blade08';
Property "faststartfailovertarget" updated
DGMGRL> EDIT DATABASE 'blade08' SET PROPERTY FastStartFailoverTarget = 'streams2';
Property "faststartfailovertarget" updated

WE SET THE THRESHOLD FOR FAILOVER TO 60 SECONDS.
OBSERVER WILL MONITOR FOR NO RESPONSE > 60 SECONDS

DGMGRL> EDIT CONFIGURATION SET PROPERTY FastStartFailoverThreshold =60;
Property "faststartfailoverthreshold" updated

FROM ANOTHER SESSION START OBSERVER - IT WILL RUN IN THE FOREGROUND 

streams2:/opt/oracle/product10gr2/db/network/admin>dgmgrl
DGMGRL for Linux: Version 10.2.0.1.0 - 64bit Production

Copyright (c) 2000, 2005, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/oracle
Connected.
DGMGRL> start observerObserver started

ENABLE THE FAST START FAILOVER 

DGMGRL> ENABLE FAST_START FAILOVER;
Enabled.

CONFIRM THE CONFIGURATION IF FAST START FAILOVER IS ENABLED 

DGMGRL> show configuration;

Configuration
  Name:                streams2.hq.emirates.com
  Enabled:             YES
  Protection Mode:     MaxAvailability
  Fast-Start Failover: ENABLED
  Databases:
    streams2 - Primary database
    blade08  - Physical standby database
             - Fast-Start Failover target

Current status for "streams2.hq.emirates.com":
SUCCESS

SIMULATE A FAILURE BY SHUTTING DOWN CURRENT PRIMARY DATABASE - STANDBY

standby:/opt/oracle/product10gr2/db/network/admin>sql

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP
and Data Mining options

SQL> shutdown abort
ORACLE instance shut down.

AFTER ONE MINUTE HAS LAPSED, YOU WILL SEE THAT THE OBSERVER HAS INITIATED A FAILOVER
12:51:28.78  Tuesday, May 15, 2007
Initiating fast-start failover to database "streams2"...
Performing failover NOW, please wait...
Failover succeeded, new primary is "streams2"
12:51:40.35  Tuesday, May 15, 2007

CONFIRM THAT THE NEW PRIMARY IS NOW STREAMS2

DGMGRL> show configuration;

Configuration
  Name:                streams2.hq.emirates.com
  Enabled:             YES
  Protection Mode:     MaxAvailability
  Fast-Start Failover: ENABLED
  Databases:
    streams2 - Primary database
    blade08  - Physical standby database (disabled)
             - Fast-Start Failover target

Current status for "streams2.hq.emirates.com":
Warning: ORA-16608: one or more databases have warnings

USING FLASHBACK WE CAN REINITIATE THE CURRENT STANDBY - BLADE08 - NO NEED TO RECREATE FROM SCRATCH
The following two tabs change content below.

Gavin Soorma

Latest posts by Gavin Soorma (see all)

Updated on June 2, 2021

Was this article helpful?

Related Articles

Leave a Comment