Category: Multitenant
-
19c PDB clones from Physical Standby
In previous articles we already explained how easy is to use a Refreshable PDB to re-create non production environments. We could periodically refresh it in the nonProd CDB, and use it to deploy the nonProd PDBs; thus avoiding a full database copy through the network. We could create full clones from it, create snapshot clones…
-
19c PDB “Snapshot copy” series- Chapter 3 – dNFS
In previous chapter 2nd we tested how easy is to implement PDB snapshot copies with a very simple setup. We leveraged this fantastic storage-based technology which is ACFS and it’s copy-on-write clones. In the example we used in that previous post, we had both the refreshable PDBs and the snapshot copies in the same CDB,…
-
19c PDB “Snapshot copy” series- Chapter 2 – ACFS
Today we will focus on a simple practical exercise where we are going to demonstrate how easy it is to create snapshot copies with a minimal infrastructure. We start from a 19c EE single instance database and ASM storage. This database consists of the CDB “CDBA” and the PDB “PDB1”, running on a virtual machine.…
-
19c PDB “Snapshot copy” series- Chapter 1
We can probably all agree that container databases (PDBs – “multitenant”) architecture has clearly improved DBAs quality of life. Most of the maintenance operations around the database lifecycle have become so simplified that activities such as cloning a database can now be done with a single, very simple, SQL command. And this without giving up…
-
19c Basic Multitenant operation combinations
The CDB (container database) architecture, also called multitenant, is the new standard in Oracle database architecture. So much so, that nonCDB databases are de-supported from versions 21c onwards. This implies that both in its singletenant model (one user PDB per CDB) and in its multitenant model (several user PDBs per CDB), PDB operations are going…
Oracle and Me 