This will clean up the V$DATABASE_BLOCK_CORRUPTION view Once cleared you can un the rman backup to fill this view again. But be aware that the corrupted blocks will remain corrupted until will be reused and reformatted, so even you will drop and recreate a corrupted object the corrupted blocks will be reported as corrupted until will be reused, but after recreating the object the corrupted blocks do not belong to any object. This means that you still will see the same corrupted blocks in V$DATABASE_BLOCK_CORRUPTION, but when you execute the query to check the affected objects you will find no object with corruptions.