Home » Server Options » Data Guard » failover with multiple standby
failover with multiple standby [message #178437] Wed, 21 June 2006 02:48 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: DBNAME and SID of standby database
Next Topic: Datafiles on Standby Databases
Goto Forum:
  


Current Time: Sat Sep 26 10:20:09 CDT 2020