OraFAQ Forum: Data Guard » switching over to a standby with a 24 hours apply delay

Home » Server Options » Data Guard » switching over to a standby with a 24 hours apply delay (10.2.0.4 Sun Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

switching over to a standby with a 24 hours apply delay [message #418045]

Wed, 12 August 2009 13:12

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

Report message to a moderator