Hi,
I have 11gr2 single instance primary database with two physical standby databases, one standby is two node RAC and 2nd one is single instance. Now I need to switch over to two node RAC physical standby.
I have few concerns related to switch over.
1. Should I keep up RAC standby database on just one node or both, before switch over?
2. Should I use scan name or VIP for RAC database on primary database server to ship logs. Log shipping is working fine with both scan name and vip. But not able to connect to standby from broker using scan name, getting error wrong username/password, but using VIP able to connect.
3. What things I need to make sure for successful switch over.
All comments and suggestions are appreciated.