Troubleshooting Oracle RMAN: A Full FRA, Missing Image Copies, and a Backup That Still Succeeded
An Oracle 19c RMAN backup failed with what initially looked like a straightforward storage problem:
Sep 24, 20267 min read26
Command Palette
Search for a command to run...
Latest articles
Why Cardinality Estimates Go Wrong: An Oracle Optimizer Lab with Skewed Data
Building a deliberately skewed dataset to watch the CBO's row estimates fall apart — and which fix actually applies to each failure mode
Sep 12, 202611 min read78
Migrating a Non-CDB 12c Database into a 19c PDB with Full Transportable Export/Import
A step-by-step guide to FTEX, PDB targeting, and cutting outage windows with RMAN incremental backups
Sep 8, 202614 min read56
Building a Real-Time PostgreSQL Migration Pipeline with Striim
This guide walks through the exact process used to build and verify a complete online database migration demo on an Apple Silicon Mac. The environment uses PostgreSQL as both source and target, Striim
Sep 3, 202615 min read19
Diagnosing an Oracle Blocking Chain: From Application Symptom to Root Cause
A reproducible multi-session lab for finding the actual root of a blocking chain... not just whoever happens to be standing in your way
Sep 3, 202610 min read6
Oracle AI Database 26ai: Performance Tuning Basics
What's the same, what's worth re-reading, and the one feature that actually changes how you'd tune contention
Aug 29, 20266 min read278
Oracle Exadata Exascale: What Actually Changes for ASM (and RMAN) Users
The headlines say 'bye bye ASM.' The scope is narrower, more Exadata-specific, and more of a migration path than a cutover here's what I found when I looked into it.
Aug 27, 20269 min read90
Setting Up a New ORDS DB Pool for the API Gateway
Provisioning an api DB pool in ORDS and wiring it through Apache httpd
Aug 19, 20263 min read2
Migrating Oracle LOBs from BasicFile to SecureFiles: A Field Guide
Notes from a real production migration on Oracle Standard Edition 2, ahead of a 12c → 19c upgrade. BasicFile is Oracle's original LOB storage mechanism, predating 11g. SecureFiles has been the default
Aug 6, 20267 min read14