Thanks, but actually we don't need to allow the dynamic connection to 2 sites. We just need to allow the user to connect to either site.
If I disable secondary connect without configuring the new site yet, would the existing site have any issues?
i.e. As it's a production environment, I want to do testing/configuring one step at a time, so if something goes wrong I know what I should rollback.
Is there a way to check the current status of secondary connect (enabled or disabled).
e.g. is there a get secondary_connect status command? Or just check the trac_client_1.ttm file?
Currently to get the primary site back up and running, I have removed the secondary site from the RAC.
I'm thinking if I disable secondary connect first on all GWs, check that it's all working.
Add the secondary site back to the RAC, check that it's all working.
This would be the safest, with least downtime if it goes awry!