oracle oracle, October 06, 2016 - 11:11 am UTC
Thanks for reply.
Question, how to repair fractured block
Vipin R, July 07, 2017 - 8:55 pm UTC
How to repair fractured block, which have no segment in it now. I have fracture block and it have index segment, which is rebuild but I still see that block marked as fractured. How to clear it?
July 08, 2017 - 11:29 am UTC
If you are on Enterprise Edition you can use RMAN
RMAN> blockrecover datafile NNN block BBBBBB;
but otherwise, if the fractured block is now no longer being occupied by a segment, you dont need to worry about it. Oracle will eventually re-use the block for other things and reformat it in the process.