Tag: pdb
-
23c – Hybrid Read-Only PDBs
Several application’s maintenance tasks in an database require keeping users out of it. For instance, performing a parallel recompilation of objects after a code update. In these cases one of the most useful tools is to use dynamic services, which allow us to disconnect clients in a controlled, convenient and centralized manner. However, even today…
-
19c – The mystery of Snapshot Carousel (Ch. 1)
Oracle has taken a giant step forward with the introduction of the container architecture (aka multitenant). The core set of operations with PDBs is now well known to DBAs, who are beginning to see operations such as a “PDB hot clone” or “Refreshable PDBs” as part of their routine. But beyond that core set of…
-
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 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 