Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to revert to old primary in dataguard switchover for a 10g R2 database.

771417Jun 17 2011 — edited Jun 22 2011
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2011
Added on Jun 17 2011
9 comments
1,095 views