Corrupt block relative dba - cheeyoung/sqlplus-public GitHub Wiki

"Corrupt block relative dba"

• "Fractured block found during "
• "Bad header found during "

"Fractured block found during "

106293  Hex dump of (file 11, block 721554) in trace file c:\oracle\admin\...\udump\..._ora_7184.trc
106294  Corrupt block relative dba: 0x02cb0292 (file 11, block 721554)
106295  Fractured block found during media recovery
106296  Data in bad block:
106297   type: 6 format: 2 rdba: 0x02cb0292
106298   last change scn: 0x08c5.8ac37500 seq: 0x1 flg: 0x06
106299   spare1: 0x0 spare2: 0x0 spare3: 0x0
106300   consistency value in tail: 0x45260601
106301   check value in block header: 0x4e89
106302   computed block checksum: 0x76de
106303  Reread of rdba: 0x02cb0292 (file 11, block 721554) found same corrupted data
...

"Bad header found during "

...
    318 Tue Oct 09 10:59:16 2018
    319 Hex dump of (file 218, block 1726061) in trace file /.../diag/rdbms/.../.../trace/..._ora_102298.trc
    320 Corrupt block relative dba: 0x369a566d (file 218, block 1726061)
    321 Bad header found during multiblock buffer read
    322 Data in bad block:
    323  type: 6 format: 2 rdba: 0x2606c023
    324  last change scn: 0x0c22.c8a0f61a seq: 0x1 flg: 0x06
    325  spare1: 0x0 spare2: 0x0 spare3: 0x0
    326  consistency value in tail: 0xf61a0601
    327  check value in block header: 0x57a0
    328  computed block checksum: 0x0
    329 Reading datafile '+.../.../datafile/....497.923855595' for corruption at rdba: 0x369a566d (file 218, block 1726061)
    330 Reread (file 218, block 1726061) found same corrupt data (no logical check)
    331 Starting background process ABMR
    332 Tue Oct 09 10:59:16 2018
    333 ABMR started with pid=379, OS id=32617
    334 Automatic block media recovery service is active.
    335 Automatic block media recovery requested for (file# 218, block# 1726061)
    336 Tue Oct 09 10:59:17 2018
    337 Corrupt Block Found
    338          TSN = 31, TSNAME = ...
    339          RFN = 218, BLK = 1726061, RDBA = 916084333
    340          OBJN = 482926, OBJD = 482926, OBJECT = ..., SUBOBJECT =
    341          SEGMENT OWNER = ..., SEGMENT TYPE = Index Segment
    342 Tue Oct 09 10:59:17 2018
    343 Automatic block media recovery successful for (file# 218, block# 1726061)
    344 Automatic block media recovery successful for (file# 218, block# 1726061)
...

1950383.1