Marc Wagner

ZDM 21.5 Physical Online Migration failing during TEMP tablespace encryption

The ZDM 21.5 version brings some new functions like encrypting automatically now the TEMP, SYSTEM, SYSAUX and UNDO tablespaces. There is no need to do it manually any more after the ZDM migration, ZDM will take care of it on(…)

Oracle ZDM 21.5 new features

I have already written several articles about my experience migrating databases with Oracle Zero Downtime Migration. At that time, the version available was 21.4. The current version is now 21.5. Recently, I had the opportunity to patch our customer ZDM(…)

Automatisation for Oracle ZDM installation and update

Let's have a look how we can install and update Oracle Zero Downtime Migration tool, and see how we can automatise it with ansible...

What will happen to your spare clones during a switchover on ExaCC?

As you might know, on ExaCC, it is possible to create spare clones. This is based on snapshot technology. There is no physical copy and the modified blocks will be written to the sparse clone, and in our case these(…)

dbaascli database move failing with ORA-01691 on ExaCC

I recently had to move a database from a 19.23 to a 19.26 dbhome on an ExaCC. This will include the database to be patched. The command dbaascli database move failed during the datapatch steps with following error: DBD::Oracle::st execute(…)

dbhome prepatch failing on ODA due to missing sqldeveloper files

I have been recently patching RAC databases on ODA 2-HA configured with Data Guard from version 19.20 to 19.26. During prepatch I have been facing an issue with missing sqldeveloper files, for which I could find a solution. I would(…)

Restore a database using Veeam RMAN plug-in on an ODA

I recently wrote a blog to show how to configure Veeam RMAN plug-in to take database backups. As all DBA knows, configuring a backup, will not go without testing a restore. In this blog I will show how I tested(…)

Installing and configuring Veeam RMAN plug-in on an ODA

I recently had to install and configure the Veeam RMAN plug-in on an ODA, and would like to provide the steps in this article, as it might be helpful for many other people. Create Veeam linux OS user(…)

Convert Single Instance database to RAC on an ODA

In this article, I will show you how to convert a SI (Single Instance) database to a RAC database on an ODA using rconfig. Of course this is only possible with the ODA 2-HA model as it comes with a(…)

And what about cloning a PDB in a Data Guard environment on ExaCC?

I have recently blogged about how to create a new PDB on ExaCC in a Data Guard environment, see https://www.dbi-services.com/blog/create-new-pdb-in-a-data-guard-environment-on-exacc/. And what about if I clone a PDB on the primary CDB? Let’s see. Clone PDB on the primary(…)