Database Administration (MOSC)

MOSC Banner

Alert.log showing corrupt blocks with segment_type=temporary segment

edited Aug 21, 2013 7:25PM in Database Administration (MOSC) 3 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center