How to revert to old primary in dataguard switchover for a 10g R2 database.
771417Jun 17 2011 — edited Jun 22 2011Hi Guys,
We have a 10gr2 database(P1) on solaris 8. We want to move to a new server running on solaris 10.
This is what we are planning to do:
-Setup a standby(S1) on new solaris 10 server in advance
-Let the logs move/apply on S1 for a few days
-Do a manual switchover on the move day so S1 is the new Production(P2) now
-Keep the old primary(P1) as new standby(S2)
-If any major issues after switchover then revert back to old Primary using another switchover from P2 to S2
I tries looking around everywhere but did not find anything which could provide me steps for last 2 action items. We can use rolling upgrade methodology but for that we have to use a logicla standby database(thereby limiting some data types).
Is their a way to use physical standby configuration to do a switchover and then(if needed) another swichover back to the original primary.
We are not using flashback.
Any help would be appreciated.
Thanks.