Backup Failure — 2 Technical Articles

Nov 10, 2022 · Databases

Why Did My Incremental Backup Fail? Uncovering the Binlog_pos Length Issue in Percona XtraBackup

This article walks through a step‑by‑step investigation of why incremental backups failed on a DBaaS platform, revealing that the PERCONA_SCHEMA.xtrabackup_history table’s binlog_pos column was too short, and shows how altering its length resolves the problem.

Backup FailureDatabase OperationsMySQL

0 likes · 10 min read

Why Did My Incremental Backup Fail? Uncovering the Binlog_pos Length Issue in Percona XtraBackup

ITPUB

Oct 19, 2016 · Databases

Recovering Lost Oracle Datafiles: SCN Adjustment and Open‑Database Tricks

This article walks through a real Oracle 11gR2 datafile loss case, explains how backup‑software snapshots caused mismatched SCNs, and details step‑by‑step recovery methods—including offline drop, header SCN editing, and forcing the database open with SCN adjustment—to successfully restore the instance.

Backup FailureDatabase RecoveryDatafile Loss

0 likes · 12 min read

Recovering Lost Oracle Datafiles: SCN Adjustment and Open‑Database Tricks