Intro Common trend for cloud providers is to compare their services/offers with AWS (even AWS itself does it when releasing new features). But it seems that the top 3 reached a sort of agreement where they only acknowledge their respective direct competition & dismiss any player outside this oligopoly. Oracle Cloud or AliCloud being more …
Read more “Compare OCI, AWS, Azure, GCP application services”
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”