Intro In an ideal world, I believe, every backup script should be matched by 2 recovery scenarios. As this swiss OUC figure reminds us, having a backup that works means nothing without a tested restore and recovery. Today Iโll try to depict the donโt doโs after an recovery of a controlfile with open resetlogs using …
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 …
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 …
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 …
Read more “How to run Datapump from a PDB as SYS when ORACLE_PDB_SID canโt work”
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 …
Read more “Terraform for dummies part 5: Terraform deployment On-premises (KVM)”