Introduction Refreshable PDB Clones enable you to copy a PDB and keep the copy (the clone) up-to-date with the source PDB (refresh the clone). The clone can be on the same CDB (local) or on another CDB (remote). If the target database is a primary database in a Data Guard configuration, then the refreshable PDB…
Category: Multitenant
How to Move PDBs across CDBs with different Database Block Sizes with Minimal Downtime
Introduction Plugging a PDB into a CDB with a different database block size is possible, as in Doc ID 2027614.1. You only need to configure the target’s CDB buffer cache to have buffers of the block size of the PDB to be plugged in, which is done by setting the db_nk_cache_size database parameter in the…
Hot Clone a remote PDB in Data Guard Environments using Transient no-standby PDBs
Introduction Oracle Multitenant is integrated with Oracle Data Guard. Data Guard is configured at the CDB level and will replicate all transactions from the primary to the standby for all PDBs in a single stream, including creating and deleting PDBs. But! When we create a new PDB, which is a clone from PDB$SEED, or create…
How to Clone a PDB from a Standby Database in a Data Guard Environment
Introduction Cloning PDBs in Multitenant environments is an easy way to migrate a PDB from one CDB to another or to create multiple copies of that PDB for test and development purposes. The data files are being read from the source and transferred to the target CDB. Hence, cloning a PDB also means generating workload…
How to create PDBs with different Character Sets in the same CDB
Introduction Oracle Multitenant enables you to migrate and consolidate multiple databases as PDBs into one CDB. Starting with Oracle Database release 12.2.0.1, PDBs within the same CDB can be of different character sets, provided the CDB is created with the AL32UTF8 character set. If you are using Application Containers, then all application PDBs under the…
A Simple Approach – Creating PDBs in a Data Guard environment with TDE enabled
Introduction In the Oracle Cloud, every newly created database from 12c onward uses the Oracle Multitenant Architecture. Transparent Data Encryption is also enabled by default. So, as soon as you use Data Guard and create new PDBs, you have to take care of copying the wallets to the standby server. We already discussed two approaches…
Using STANDBYS=NONE to create PDBs in a Data Guard environment with TDE enabled
Introduction Creating and cloning PDBs in a multitenant environment is a simple and straightforward task, also when TDE is enabled. However, in a Data Guard environment where primary and standby use their own TDE wallets, it becomes challenging. In a previous blog post, we discussed how creating the master encryption key on the primary 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 post first. The Environment I’m using Oracle Database Cloud service Enterprise Edition Extreme Performance. The database version is 19.8.…
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 Oracle provides four pre-defined software editions in the Oracle Cloud to choose from. Each…
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…