Database Support

This section will cover the supported Database versions and features for Dbvisit StandbyMP product for each platform: Oracle, SQL Server and Postgres.

1. Oracle Database Support

1.1 Oracle Database Editions Support

Dbvisit StandbyMP product supports following editions of Oracle database:

Oracle Database Standard Edition 2 (Including “Standard Edition” and “Standard Edition 1”)
Oracle Database Enterprise Edition
Oracle Database Express Edition

It is not supported to create Oracle Standby database with different edition than primary database. Only in very specific case when absolutely no EE features are used in primary database, it is possible to create SE2 standby database.

1.2 Oracle Database Versions Support

Following table contains list of supported database versions by Dbvisit StandbyMP:

Oracle Database Version
10g 11g 12.1 12.2 18c 19c 21c 23ai

Support of Oracle Database version isn’t limited by specific release (for example 11.2.0.4), but we always recommend to be on the terminal patchset, otherwise there could be bugs resulting in issues with deployment or synchronziation.

1.3 Oracle Database Features and Advanced Deployment Configurations Support

In following table you can find list of features supported by Dbvisit StandbyMP:

Feature	Supported	Support Notes
ASM	Yes	Oracle grid on latest possible version is recommended ACFS is supported on Linux platform for all OS combinations certified by Oracle ASM mirroring syntax for standby init parameters (e.g. `db_create_file_dest=+DATA(FG$FILEGROUP_TEMPLATE_MIRROR)` ) is NOT supported
SEHA (Standard Edition High Availability)	Yes	Dbvisit StandbyMP Supports SEHA configurations. Dbvisit must be installed on shared storage and run with dedicated VIP
RAC	Yes	Dbvisit StandbyMP Supports RAC Database configurations excluding version 19c and newer Dbvisit must be installed on shared storage and run with dedicated VIP
Failsafe	Partially	Failsafe is only partially supported Dbvisit doesn’t include interface for Failsafe, manual scripting is required
PDB (Pluggable database)	Yes	Up to three PDBs for SE2 only (one PDB for pre-19c versions) Adding new PDBs on primary is supported by Dbvisit StandbyMP synchronization It is not supported to synchronize only specific PDBs or synchronize PDB to multiple CDBs (synchronization happens only on CDB level)
Non-Oracle OS Clustering Software (Pacemaker)	Partially	Dbvisit doesn’t include interface for other technology than Oracle grid Manual scripting is required when deploying on non-Oracle OS Clusters
ODA KVM DB	Yes	Dbvisit supports deployment on ODA KVM DB Virtual machines (Homogenous deployment only) Excluding SEHA / RAC support

1.4 Oracle Database Deployment Support for configuration-heterogenous environments

Dbvisit StandbyMP supports configuration-heterogenous deployment for following cases:

	Standby SI FS	Standby SI ASM	Standby RAC ASM	Standby SEHA ASM
Primary SI FS	Yes	Yes	No	No
Primary SI ASM	Yes	Yes	No	No
Primary RAC ASM	Yes	Yes	Yes	N/A
Primary SEHA ASM	Yes	Yes	N/A	Yes

SEHA ASM support includes Databases with datafiles on ASM or ACFS

SI = Single Instance Deployment

FS = Filesystem

We Strongly recommend that standby server does have sufficient hardware configuration so as it will be able to sustain live production traffic without any issues in case of Disaster Recovery scenario.

2. SQL Server Database Support

2.1 SQL Server Database Editions Support

Below are the editions supported by Dbvisit StandbyMP:

Enterprise Edition
Standard Edition
Web Edition
Personal Edition
Express Edition

2.2 SQL Server Database Versions Support

Dbvisit StandbyMP supports SQLServer from version SQL Server 2012 to the version of SQL Server 2022.
Dbvisit StandbyMP supports Lower to Higher version combinations (Primary Lower version 🡪 Standby Higher version) for migrations. Switchover is not possible in this case, only failover.

2.3 SQL Server Database Advanced Deployment Configurations Support

Dbvisit StandbyMP supports SQLServer on WFC configurations. It is required to install Dbvisit StandbyMP on Shared storage.

3. Postgres Database Support

Dbvisit StandbyMP supports versions of PostgreSQL from version 10 to to verison 16 (including).

It is not supported to create postgres Standby database with different version than primary database