Intro In my previous blog post, I showcased how to automate the refresh of a PDB clone using a DBMS scheduler job which gives a better control on the frequency, instead of relying on the minutely refresh. Handy if you don’t like keeping an automatic refresh every X minutes and rather have it run once …
Read more “What they don’t tell you about refreshable PDB clones (ghost archives)”
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”
I want to thank Ludovico Caldara [FPP & Cloud MAA Product Manager @Oracle] for accepting the publication of this interview which is based on a conversation we had some time ago. It is mainly focused on the Oracle Fleet Patching and Provisioning (FPP) “FUNDAMENTALS”, but I hope this could help the community to glean a …
Intro I have been asked to read about Oracle database fleet management at work but the turnoff was that it relied entirely on OEM. Aggregating both functionalities makes provisioning, in my opinion, cumbersome and unattractive for shops that only want to manage the fleet. Luckily for me, I got acquainted with an even better framework …
Read more “My Vagrant fork of Oracle Fleet Patching and provisioning (FPP)”
Intro First, before anyone starts sending me print screens about their successful Autoupgrade, or flexing about how their 100+ databases were smoothly migrated to PDBs over the weekend, I am stopping you right there. This is my honest feedback on the experience I had when trying the tool on a windows environment. It is obviously …
Read more “The not so AUTO …UPGRADE ! (ORACLE Autoupgrade in Windows )”
Intro One of the advantages of Oracle grid Infrastructure is to restart all managed resources (databases, asm, listeners,…etc) automatically whenever you (re)start the cluster service (crs) or reboot the whole server. I recently had to patch an oda where the client still had few listeners (with non default ports) managed locally and not through grid. …
Read more “Convert local listeners to Oracle Grid managed listeners”
Intro Infrastructure teams are usually more keen to maintain a network stability rather than altering their existing configuration every other day.This means that once the application and database hosts are provisioned and running, the DBA won’t witness a topology change unless a migration of the servers/applications are in the pipes. But for highly available environment …
Read more “Add SCAN VIPs to Oracle RAC with zero “listener” downtime”