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: New Data Guard, logs not shipping across
Next Topic: Upgrading Physical Standby Database
Goto Forum:
  


Current Time: Mon Aug 21 22:20:58 CDT 2017

Total time taken to generate the page: 0.10956 seconds