database

SQL-Server: What are VLF’s and why should I care about them?

Introduction: What are VLF’s? In SQL-Server, the transaction log is divided into several logical units called virtual log files (VLF). The amount of virtual log files and their size are managed automatically by the database engine. The database engine(…)

ZDM Physical Online Migration – A success story

I have been recently blogging about ZDM Physical Online Migration where I was explaining this migration method and preparing customer On-Premises to ExaCC migration. See my blog, https://www.dbi-services.com/blog/physical-online-migration-to-exacc-with-oracle-zero-downtime-migration-zdm/. I have now had the opportunity to(…)

ZDM Physical Online Migration failing during ZDM_SWITCHOVER_SRC phase

When using ZDM for a Physical Online Migration, even in the last current version, 21.4.5.0.0, switchover is failing. In this blog, I will share the reason and the solution to solve the problem before moving forward with the migration.

Patching Oracle databases with Nutanix NDB

A few years back I had the great opportunity to test Nutanix NDB, at that time called Nutanix Era, and I had written a few blogs about provisioning Oracle databases, taking snapshot, log catchup, cloning a database, restoring a database,(…)

Simplifying PostgreSQL Management: A Guide to Install and Use pgcli

Managing databases is a crucial aspect for a DBA, and PostgreSQL is a powerful open-source relational database management system that is widely used. To interact with a PostgreSQL database, DBA and developers often rely on command-line tools. The default(…)

Database Check for a one-to-one Migration with OMrun

Procedure to check a one-to-one migration between different database types autogenerated and generically with OMrun.

Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI)

Oracle offers a number of methods to migrate Oracle databases to the Oracle Cloud Infrastructure (OCI). From Data Pump through RMAN, Data Guard and even Golden Gate there should be a solution for just about everyone. However, most of(…)

Deploying 11.2.0.4 on a recent ODA

How to deploy 11gR2 database on a modern ODA(…)

Oracle DBs and ransomware attacks

By Clemens Bleile I had a discussion with a customer recently about the risk of running into an issue with ransomware encrypting data of Oracle databases. Just to quickly recap on what ransomware is: Wikipedia: Ransomware is a type(…)

Alfresco – Removing JMX settings via the AttributeService since the Revert doesn’t work

At a customer, I recently faced a problem with the JMX settings that couldn’t be reverted. If you already worked with Alfresco, you know that it’s possible to save configurations through the Alfresco Administration Console and that doing so will(…)