LATEST POSTS
-

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
-

The optimistic view of a former Oracle DBA
As we look forward to the start of a new year, I’ve decided to revive my old blog (at that time in yahoo) that I started more than 15 years ago and in which I published the most interesting things that I was discovering about the Oracle database. That old blog did not add anything
ORACLE AND ME NEWSLETTER
Sign up to receive an email whenever I publish a new post. Eventually several times a month.
