The process of marking the table block as corrupt automatically removes it from the freelists.
The inconsistent nature of the review process leaves application developers unsure of what constitutes an acceptable change leading them to make avoidable mistakes over and over again.
The consistent evaluation provided by the Dynamic Rules Engine removes uncertainty about what is acceptable and empowers application developers to write safe, compliant changes every time.
BMR can only be performed via RMAN using the package allows you to detect and repair corruption.
The process requires two administration tables to hold a list of corrupt blocks and index keys pointing to those blocks. If the orphan key count is greater than 0 the index should be rebuilt.
I created the Data Model Scorecard to proactively determine how “good” a data model, and therefore improve the structures before the database and code work have begun.