 9i Standby Database - Failover Question - REF 227196.1 [message #130959] |
Wed, 03 August 2005 10:36  |
stepheng
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
Stephen
|
|
|
|
| Re: 9i Standby Database - Failover Question - REF 227196.1 [message #130979 is a reply to message #130959] |
Wed, 03 August 2005 12:48  |
Frank Naude
Messages: 4589
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.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
