Home » Server Options » Data Guard » switching over to a standby with a 24 hours apply delay (10.2.0.4 Sun Solaris)
switching over to a standby with a 24 hours apply delay [message #418045] Wed, 12 August 2009 13:12 Go to next message
Orna
Messages: 62
Registered: November 2008
Member
Hi

I would like to setup a 10.2.0.4 standby database with a 24 hours apply delay.
I want to be able to switchover my primary database to a day old database in case a user error occurs .

Is that even possible ? I undestand that in order to do a switchover - I need to cancel the apply delay..

Can I switchover to the standby without having it brought up to date ?
If yes - how is that working wit hthe primary ( which is 24 hours ahead ) becoming the standby ?

If not - what is the point to that delay anyway ? is it only good for a failveor /standby activation ?

thanks in advance
Orna
Re: switching over to a standby with a 24 hours apply delay [message #418049 is a reply to message #418045] Wed, 12 August 2009 14:00 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check Specifying a Time Delay for the Application of Archived Redo Log Files.
Previous Topic: Data Guard For Oracle 11G
Next Topic: Creating 2 Physical Standbys
Goto Forum:
  


Current Time: Thu Mar 28 11:54:22 CDT 2024