Hi,
I have a Oracle DB server running windows 2019 on Azure VM. This is a single instance DB running on Standard edition. During the DB patching it cost us a lot of downtime, so looking for solution to minimize the downtime. Any experts recommendations to start with planning?
One Option I explored is RAC one node, but to go with this I think below options needs to be considered :
Need to get the EE license (Unsure what would be cost difference)
RAC one node needs shared storage, so need to understand how we can migrate the local database to shared storage. Is shared storage a MUST in RAC one node architecture?
With RAC one node, can we create a temporary Azure VM and migrate the client connections to the new VM and then do the patching on primary DB and re-wind the connections post patching and then delete the secondary VM ?
Any other options we can consider ?
Thanks.