This content has been marked as final. Show 3 replies
Here you have performed Failover and not Switchover hence your standby database is now activated and acting as indiviual (cannot be sync with old Primary)
Answers to your questions,
1. How I can Syncronize data from new primary to old primary? *(Not Possible as now SCN is different for both databases and cannot be sync. this you could have avoided if you would have taken snapshot for standby)*
2. How to perform RAC and DataGuard configuration as before RAC was corrupted? *(here you have to again configure your standby)*
what doest it means by RAC was corrupted. ??
- as both Grid Infrastructue and Cluster database are separate entities. Here GI is intact, only thing you need to do is configuring standby once again and perform switchover/switchback instead failover.
I hope this helps you :)
Thanks for your comment.
I have installed oracle 11g r2 rac with asm in two nodes. OS is hp-Unix.
I have installed oracle11g Active Data Guard using Single alone Database.
Both RAc and Active Data Guard works fine.
I have not configure Data Guard Broker.
If again RAC is down both node and not possible to Up, So to continue Client Transaction
How I can perform switchover/switchback to convert Data Guard as Primary(new).
So that when previous RAC is Up , I can sync previous primary and new primary(new)
also can make new primary(new) as Data Guard?
Your question depends upon how the Primary site went down. If you need a planned outage you can do a switchover to the Standby and then keep Log_archive_dest_state_n set to defer.
Once the outage is complete you can enable. In most cases Data Guard will SYNC and then you can switchover again to switch back.
If the outage is unplanned you have to recover the old primary site ( flashback, RMAN) to the last SCN where the two databases where sync. Then in a Standby role bring the old primary back in sync.
Here's a couple of short notes which may help :