Marc Wagner

How to check if my Oracle dbhome is RO or RW?

As you might know, RO (Read Only) dbhome was introduced in Oracle 18c and became default configuration in Oracle 21c. Oracle came back with RW (Read Write) dbhome as default configuration in 23ai. It might be interesting to know how(…)

Possible to relocate a PDB on ExaCC with move option?

In some of my previous blogs, I showed how we were migrating on-premise databases to the ExaCC using Oracle ZDM at one of our customer. I also explained in some article how it was important in some case to relocate(…)

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(…)