RMAN, Incarnation, & ME part I: โ€œORA-19906โ€: Recovery target incarnation changed during recovery

Intro If there is something I honestly always struggled with as a DBA, itโ€™s RMAN incarnation. Both mystical like its name suggests and vital, ensuring absolute consistency of your database and backups. But deep down, you always know itโ€™ll back fire one day out of the shadows. Because thatโ€™s where it hides, lurking until a …

19c PDB Refreshable clones

Intro Beside Long term release benefits, upgrading to a multitenant 19c Database will allow to completely ease the way test environments are refreshed from production servers. Say Goodbye to complex & lengthy RMAN duplicate scripts and hello to remote cloning. Even better with refreshable clones, production data is now automatically updated. Many blogs were written …

How to run Datapump from a PDB as SYS when ORACLE_PDB_SID canโ€™t work

Intro In Oracle multitenant architecture, default database container upon connection is CDB$ROOT. But as of 18c, a new environment variable appeared to ease the direct access to a specific PDB (given a defined ORACLE_SID). The variable in question is ORACLE_PDB_SID.  As explained in Mike Dietrichโ€™s Blog, this variable is checked by a small AFTER EVENT …

Terraform for dummies part 5: Terraform deployment On-premises (KVM)

Intro For a long time, Terraform was associated with deploying resources in the cloud. But what many people donโ€™t know is that terraform already had private and community based providers that worked perfectly on non cloud environments. Today, we will discover how to deploy a compute vm in a KVM host. Not only that, but …

KVM lab inside a VirtualBox vm (Nested virtualization) using vagrant

Intro It has been a while since I wanted to blog about nested virtualization, but the good news is I now have a vagrant build to share with you so you can  vagrant it up:). KVM started to interest me as soon as I learned that Oracle allowed for hard partitioning on KVM boxes if …