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…
Tag: Multitenant
How to create a TEMP File after PDB Creation in Data Guard Environments
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…
Creating PDBs in Data Guard Environments while using OCI Vault for TDE Key Management
Introduction Oracle Databases on Oracle Cloud use the Multitenant Architecture and are encrypted with TDE by default. Creating new PDBs in Data Guard environments while using a local wallet for TDE master encryption keys requires some additional steps to copy the wallet file and recover the PDB on standby. We discussed these approaches in previous…
How PDB Recovery Isolation in 21c makes your Life easier
Introduction We already talked about remote PDB cloning in Data Guard environments in previous blog posts. As the datafiles of the cloned PDB are not present on the standby database, there are several manual steps to be followed to create the PDB on the standby site in 19c: Using Transient no-standby PDB. Using STANDBYS=NONE followed…
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…
Migrating from non-encrypted, non-CDB on local file system to encrypted PDB on ASM
Introduction Oracle Databases on Oracle Cloud are created using the Multitenant architecture. All databases are encrypted using Transparent Data Encryption (TDE) by default. All databases on Exadata, Bare Metal machines, and RAC on Virtual Machines use ASM storage management. For Single Instance databases on Virtual Machine DB systems you have the choice between Logical Volume…
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…