Skip to content
Try for FREE

Adding Dbvisit StandbyMP to Oracle SE2HA on ODA for greater resiliency

Marc Wagner of dbi services in Switzerland, shows how easy it is to set up a highly resilient, highly available Oracle Standard Edition database.
Technical Piece
NFS Error Guide
Product Review
dbi Services (Partner)
By Marc Wagner |
February 27, 2023 |
Link Clicked!

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 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?

Test Environment

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. 

Contact us

Take a Test Drive

Marc Wagner
Marc Wagner

Subscribe to our monthly blog updates

By subscribing, you are agreeing to have your personal information managed in accordance with the terms of DBVisit's Privacy Policy

Link Clicked!
Try StandbyMP for free

See for yourself how our continuous database protection can help keep your world in motion.

Find a local partner

We work with partners around the world to give you the best advice and world-class local support.

Mask Group 59
Mask Group 184-1
Group 781
Group 528
Let’s talk

Find out about our continuous database protection for yourself and see how you can keep your world in motion.