| failover with multiple standby [message #178437] |
Wed, 21 June 2006 02:48  |
dbarrett
Messages: 1
Registered: June 2006
|
Junior Member |
|
|
In a situation where there is a Production DB and 2 Standby DB's, if production fails and Standby[1] becomes the new production, can it take over the primary role for Standby [2] and continue to feed it REDO information, or do I need to take a new copy of Production and start the process all over again for Standby [2]?
Dave.
|
|
|
|
| Re: failover with multiple standby [message #178439 is a reply to message #178437] |
Wed, 21 June 2006 02:54  |
aciolac
Messages: 242
Registered: February 2006
|
Senior Member |
|
|
|
To open standby database in read/write mode, You must open them with RESETLOGS option. This means, that all information about arhived redo logs will be cleared. So, You must to recreate you standby[2] database.
|
|
|
|
| Re: failover with multiple standby [message #180202 is a reply to message #178439] |
Fri, 30 June 2006 12:52 |
poconojohnny
Messages: 4
Registered: June 2006
Location: Dallas / Fort Worth, TX
|
Junior Member |
|
|
(Oracle 9.2.0.6, AIX 5.2, Data Guard)
Having two standbys with Data Guard:
Standby[1]
Standby[2] - with an n hour delay of replication (tertiary in event of data corruption)
What would it entail or you suggest after the Switchover to Standby[1] and yet maintain the n hour replication to Standby[2]?
Thanks.
John
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
