dbaliw

Another Migration Utility: ORAdiff

Upgrading a database can sound hard and risky. When you move your database from an older version like Oracle 19c to a newer version like Oracle 26ai, many things inside the system change. To help with this, Oracle gives us a free online tool called ORAdiff (Oracle Release Analyzer Diff Utility ). This tool helpsContinue reading “Another Migration Utility: ORAdiff”

Troubleshooting Oracle M5 XTTS Migration: Unraveling ORA-19638 in M5 Workflows

Introduction Oracle M5 Cross-Platform Transportable Tablespaces (XTTS), is an efficient way to migrate large databases between platforms with different endianness while minimizing downtime. However, adapting the standard M5 workflow to meet specific application requirements can introduce unexpected SCN (System Change Number) mismatches. In this article, I will explain a real-world issue involving hundreds of read-onlyContinue reading “Troubleshooting Oracle M5 XTTS Migration: Unraveling ORA-19638 in M5 Workflows”

Understanding Cascade Snapshot Cloning in Oracle Multitenant

Oracle Exascale supports sparse snapshots and fast cloning at the block level. With Cascade Snapshot Cloning, you can create a clone from another clone: Base PDB → Clone A → Clone B → Clone C This is useful when you need many database copies for development, testing, or migration. In this article, we will lookContinue reading “Understanding Cascade Snapshot Cloning in Oracle Multitenant”

Exadata Exascale VM Storage is Finally Available

Exadata Exascale VM Storage is officially available in our region! If you are setting up new environments in ExaCC or OCI , Oracle now strongly recommends deploying your VM clusters using an Exascale VM Storage Vault rather than traditional local compute storage. By completely decoupling your VM’s file system from the underlying physical server, thisContinue reading “Exadata Exascale VM Storage is Finally Available”

Ghost in the Datafile: Fixing “Empty Block” Corruption in Oracle

A common frustration for DBAs occurs after identifying a corrupted index or table. You drop the object, expecting the error to vanish, but RMAN backups still fail and Data Guard continues to report a gap. Even though the block is no longer part of a segment, it remains “physically” corrupted in the eyes of theContinue reading “Ghost in the Datafile: Fixing “Empty Block” Corruption in Oracle”

Oracle 26ai: Out-of-Place Database Patching Explained

Patching a database often means turning it off, which is a problem for businesses. In Oracle 26ai, there is a great new feature called Local Rolling Out-of-Place Patching. This feature helps you move your database to a new, patched “Oracle Home” on the same server without stopping database (or short downtime). Here is how itContinue reading “Oracle 26ai: Out-of-Place Database Patching Explained”

Exadata Snapshot PDB Clone with ACFS

When working with Exadata, there are several ways to create snapshot PDB clones. The main options are: Sparse Clone Exascale PDB Clone ACFS Snapshot Clone Each one works well, but the best choice really depends on your environment and what you need. Exascale Clone This is clearly the most modern solution. It’s fast, simple, andContinue reading “Exadata Snapshot PDB Clone with ACFS”

ACFS Replication Background Process Stopped After Upgrade to 23ai

If you recently moved from Oracle 19c to Oracle 23ai, you might find your file replication has stopped. Your status shows “Stopped”, and no matter how many times you try to start it, nothing happens. The Problem: The “SCAN” Name In the old version (19c), replication usually connected directly to a specific server’s name orContinue reading “ACFS Replication Background Process Stopped After Upgrade to 23ai”

Deinstalling Oracle Grid Home in Oracle 23ai: Step-by-Step Guide

In Oracle 23ai, the procedure for deinstalling an Oracle Home or Grid Infrastructure Home has not changed compared to previous releases. The standard deinstall utility is still used, and the process remains straightforward. In this article, I will walk through the real procedure I followed to remove an Oracle Grid Home in Oracle 23ai andContinue reading “Deinstalling Oracle Grid Home in Oracle 23ai: Step-by-Step Guide”