Corrupt blocks listed in V_$DATABASE_BLOCK_CORRUPTION
We started getting alert log messages identifying 3 corrupt blocks in an 11.2.0.2 DB. I went to DBA_EXTENTS to see what object they might be in, and not finding them there I went to DBA_FREE_SPACE but again they were not in a listed free extent. I wondered if they might be listed elsewhere so I searched dba_objects for sys objects with "CORRUPT' in the name, and I found V_$DATABASE_BLOCK_CORRUPTION which lists the three blocks.
What exactly is this view and how will these blocks be handled? Are they in fact not in use (we have not seen errors processing data) and are they safely quarantined? If they are in unused blocks, is there a way to have Oracle re-initialize them? The DB uses a high-end storage array so I doubt that there is a persistant problem with the physical storage.
What exactly is this view and how will these blocks be handled? Are they in fact not in use (we have not seen errors processing data) and are they safely quarantined? If they are in unused blocks, is there a way to have Oracle re-initialize them? The DB uses a high-end storage array so I doubt that there is a persistant problem with the physical storage.
0