Loading....
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
Please follow and like us:

Last Update: June 25, 2009  

June 25, 2009 99 Gavin Soorma
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

, , ,

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?