Oracle’s Multitenant Architecture 

The recently released StandbyMP includes full support for Oracle’s multitenant architecture. This blog runs through some of the benefits of Oracle’s multitenant architecture on Oracle Standard Edition which has been available since version 19c.

Benefits of Oracle Multitenant

1. Database consolidation:

By introducing a max of three pluggable databases (PDBs) per multitenant container database (CDB) in Standard Edition, applications running in different databases can be consolidated under one CBD for efficient resource utilisations and overall security. In addition, this consolidation enables infrastructure cost savings through reduced hardware and software footprints.

2. Ease of maintenance:

Instead of managing three separate databases, everything can be consolidated under one CDB. In addition, patching, backups, configuration, and upgrades are done centrally under a single Oracle home rather than on individual Oracle homes.

3. Development and testing flexibility:

Instead of waiting for environments, the DBAs can provision individual PDBs in their testing environments and save time for testing and development teams.

StandbyMP Automates Pluggable Detection and Replication

Now let’s look at what Dbvisit brings to the party! StandbyMP supports up to three pluggable databases on one Standby™️ license to deliver even greater value.  The process to add a pluggable database is also smooth, with any new pluggable database added to primary automatically refreshed in the standby. This is all automated without any additional manual steps or hassles. 

By default, whenever an archive log file is sent from primary to standby, the process detects a new PDB, and a backup of the PDB is taken from the primary and transferred to standby. When the archive log application process kicks in, the PDB is restored, and the archive logs are recovered. This feature avoids the need to recreate the standby database whenever new PDBs are added to the primary. The support is for up to three PDBs in the primary. Our documentation explains the process in detail.