Tag: Multitenant

Hello Upgrade! Do you run faster in the Cloud?

Introduction A customer is having long upgrade times on-premises. As they are moving to the Cloud, I got the question whether their upgrade in the Cloud would be faster. First of all, when it comes to patching, upgrade, and migration, I can only encourage you to read the blogs by Mike Dietrich and Daniel Overby…

Minimal Downtime Patching using Refreshable PDB Clones

Introduction Oracle Multitenant allows you to clone PDBs from one CDB to another easily, even though the source and target CDBs were of different patch levels, e.g. 19.9 and 19.10, and even different editions like moving from SE to EE. The only thing you’ll need is to run datapatch afterwards. Unplug and Plug the PDB…

Create PDBs in a Data Guard Environment with TDE enabled

Introduction See what happens and how to proceed after creating or cloning a PDB in a Data Guard environment while Transparent Data Encryption (TDE) is enabled. If you are new to TDE, have a look at this blog first. The Environment I’m using Oracle Database Cloud service Enterprise Edition Extreme Performance. The database version is 19.8. TDE…

Is the Multitenant Option mandatory in the Oracle Cloud?

No, not necessarily. All Oracle databases from version 12.1 in the Oracle Cloud are automatically deployed using the Multitenant architecture. This is probably the reason why this question is asked. Let’s have a deeper look. Database Cloud Service (DBCS) License Included For EE-HP and EE-EP, you can create up to 4096 PDBs. For SE and…

Part 7/10: Migration Methods using Multitenant Architecture

In this part we will introduce the following migration methods using Multitenant Architecture: Unplug & Plug Remote Cloning Remote Hot Cloning PDB Refreshable Clone PDB Relocate Multitenant Architecture The multitenant architecture provides easy and powerful features to move databases across platforms, even with just one single SQL command. It’s almost magic! The multitenant option was…

Refreshable PDB Switchover in Standard Edition Cloud Service

Oracle Database Standard Edition in the Cloud offers additional features including: All versions: Transparent Data Encryption, which is available only for Enterprise Edition on-prem. 18c onwards: Refreshable PDB Switchover, which is available only for EE on Engineered Systems (Exadata and ODA) on-prem. Additionally, in the Cloud you benefit from Automatic Backups, one-click Restore, one-click CPU up/down Scaling, and Simplified Patching. This…