ITPUB
ITPUB
Sep 28, 2016 · Databases

How to Diagnose and Repair Bad Blocks in Oracle Databases

This guide explains what Oracle bad blocks are, how they affect the database, common causes, methods to detect them, and step‑by‑step recovery techniques—including full datafile restore, RMAN block recovery, ROWID range scans, EVENT 10231, and DBMS_REPAIR—plus pre‑emptive detection tools.

Bad BlocksDBMS_REPAIROracle
0 likes · 10 min read
How to Diagnose and Repair Bad Blocks in Oracle Databases
dbaplus Community
dbaplus Community
May 20, 2016 · Databases

How to Tackle Oracle Bad Blocks: Practical Strategies for DBAs

The article explains why Oracle bad block incidents demand scenario‑driven handling, outlines interview questions, describes the pitfalls of inspecting each alert log, and advocates promptly switching to disaster‑recovery and using backups to restore service, while sharing real‑world cases and practical DBA advice.

Bad BlocksDBADatabase Recovery
0 likes · 8 min read
How to Tackle Oracle Bad Blocks: Practical Strategies for DBAs