Is it possible to transfer connections hitting NodeA & B to NodeC & NdeD?
We have two node RAC setup. We are in the process of migration of DB servers to different datacenter. We have a datagurad setup between the servers. On the day of migration, we stop the connections to Node A & B and sync up with Node C & D.. Them we make the standby as Primary database.
At this point of we would have stopped the applications. We donot want to make any changes at the applicaiton layer. Once the standby is made as primary database we want all the connections hitting old primary should now hit the new primary database. Is there any way we can transfer the connections hitting node A & B can be transferred to Node C & Node D. Let us know, whether this is possible achieve using remote_listener?