José Carlos Pavón | A Database Logbook 📔

“Performance only matters if your database is UP!”

Ensuring availability, recovery, and performance for business-critical operations. With extensive experience in complex Oracle diagnostics, I design and optimize data platforms. Currently evolving into a DSRE role, applying years of operational rigor to cloud ecosystems (AWS/OCI) and open-source engines like PostgreSQL and MongoDB.

Hello World: Migrando mi infraestructura a Hugo

Este es el primer post de mi nuevo blog. He decidido abandonar plataformas cerradas y montar mi propio “Data Center” estático usando Hugo, GitHub y Vercel. ¿Por qué este cambio? Como DBA y SRE, tener control absoluto de mi infraestructura es innegociable. Con este setup consigo: Rendimiento extremo (cero llamadas a BBDD). Soberanía de datos (mis posts son archivos Markdown en mi local). Flujo CI/CD (escribo, hago push y se despliega solo). Nos vemos en el próximo post. ...

April 22, 2026 · 1 min

RMAN-05541 & RMAN-05001 when duplicating database from a consistent (cold) RMAN backup

RMAN-05541: no archived logs found in target database. Problem: You are getting RMAN-05541 error when duplicating database from a consistent (cold) RMAN backup. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 04/16/2021 12:57:12 RMAN-05501: aborting duplication of target database RMAN-05541: no archived logs found in target database Solution: The error should be resolved by using NOREDO clause for your duplicate command. ...

June 15, 2021 · 1 min