Alert.log showing corrupt blocks with segment_type=temporary segment
Hi,
In our 10.2.0.4 production database, we are seeing the following messages
in the alert.log
Corrupt Block Found
TSN = 11, TSNAME = TEST_DATA
RFN = 69, BLK = 3491, RDBA = 289410467
OBJN = -1, OBJD = 130479, OBJECT = TEST_DATA, SUBOBJECT =
SEGMENT OWNER = , SEGMENT TYPE = Temporary Segment
Corrupt Block Found
TSN = 11, TSNAME = TEST_DATA
RFN = 68, BLK = 1123, RDBA = 285213795
OBJN = -1, OBJD = 130446, OBJECT = TEST_DATA, SUBOBJECT =
SEGMENT OWNER = , SEGMENT TYPE = Temporary Segment
when we query, v$database_block_corruption, we get no results back
Is RFN the file id that we should use dbv against to verify if there is any corruption?
Also. the segment_type is shown as "Temporary Segment". What does it mean? How can we fix it?
0