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
0 Comments