A warm standby database can be added to Oracle SE2HA environments to guarantee database continuity and reduce RTO (recovery times) and RPO (data loss). This is especially important for business critical databases.
In this blog Marc Wagner from dbi services Switzerland, shows how easy it is to set up a highly resilient, highly available Oracle SE database by combining (1) Oracle Standard Edition, (2) Standard Edition High Availability, ODA, and Dbvisit StandbyMP. This delivers automated switchovers for minor issues, fast failovers for major disasters, and reduced downtime for system maintenance while minimizing cost.
by Marc Wagner | 08.02.2023
Original blog: Combine Oracle SE2HA on ODA with Dbvisit StandbyMP?
I recently blogged about Oracle SE2HA on ODA, see my article https://www.dbi-services.com/blog/seha-on-oda/. Oracle SE2HA is used for High Availability for Standard Edition. Dbvisit Standby is a Disaster Recovery well-known application designed for Oracle Standard Edition. Dbvisit guarantees database continuity, and will reduce RTO and RPO. With Dbvisit we will limit business impact in case of failure like hardware, operating system or human failure by activating a standby database. With Dbvisit we can also reduce the downtime linked to maintenance on the system. But what about combining both Oracle SE2HA and Dbvisit?
For my test I’m using :
an ODA X5-2-HA with 2 nodes dbioda02 and dbioda03
an ODA X8-2M with node named dbi-oda-x8
The privileged nodes for primary would be the ODA X5-2-HA so we can take advantage of Oracle SE2HA. The test would be then to simulate a configuration where the primary database is usually running on a 2 nodes cluster and the standby database running on a single node. We accept to be in a lighter configuration on standby side knowing this one is less sought, and the standby node will less be activated as primary. We have some customer using such configuration with EE having a Data Guard configuration with a primary on RAC and a standby with single instance. Of course recall that Oracle SE2HA is not as RAC. With Oracle SE2HA we will only have one instance connected to the database at the same time compared to RAC on Enterprise Edition where you can have multiple instances.
I’m going to install Dbvcontrol on dbi-oda-x8 node.
Read the full blog at dbi services to see how Marc sets up a resilient Oracle SE database using StandbyMP.
If you're interested in learning more about implementing a standby database for Disaster Recovery, take a Test Drive, or talk with a Technical Specialist about your environment and goals.