Home » Server Options » Data Guard » 9i Standby Database - Failover Question - REF 227196.1
icon5.gif  9i Standby Database - Failover Question - REF 227196.1 [message #130959] Wed, 03 August 2005 10:36 Go to next message
Messages: 12
Registered: August 2005
Location: Ireland
Junior Member
Hi ,

Im researching the use of a Standby DB for out Production DB....

The Metalink DOC 227196.1 mentions that in failover , the Production going down , Standby becomes Primary and cannot be come Standby again , whereas with Switchover , they can be swapped as many times as you need for upgrades etc...

"The Difference between a Switchover and a Failover is, that after a Failover, the Standby Database becoming a Primary now, cannot switchback to become a Standby Database again. In Opposition a Switchover exchanges the Database Roles (The Primary becomes a Standby and the Standby becomes a Primary). Switchovers can be performed arbitrarily, a Failover only once."

If failover happens can someone tell me or point me in the right direction:

a) Can you config Failover to happen automatically?
b) If failover occurs , do you need to reconfig all the Primary/Standby DB again in the event that failover happens again?
c) Any clear step by step guide to config of standby... The Oracle docs whilst very good are robust and some "summary" steps would be great

thanks in advance

Re: 9i Standby Database - Failover Question - REF 227196.1 [message #130979 is a reply to message #130959] Wed, 03 August 2005 12:48 Go to previous messageGo to next message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Answers to your questions:

a) No - it requires manual intervention to prevent false failovers. However, one should be able to write a set of script to automate it.

b) You would only need to reestablish the secondary/ standby database.

c) The manuals are excellent indeed. In fact, they are so good that everyone I know use them directly instead of relying on their own procedures.

Best regards.

Re: 9i Standby Database - Failover Question - REF 227196.1 [message #131360 is a reply to message #130959] Fri, 05 August 2005 09:45 Go to previous message
Messages: 12
Registered: May 2005
Location: St Louis, MO
Junior Member
Here are a few of my favorite links too:


The Oracle docs are good as well as "Oracle Data Guard" by Bipul Kumar.
Previous Topic: Unable to create stby database through data guard.
Next Topic: recovery error
Goto Forum:

Current Time: Fri Dec 03 08:31:14 CST 2021