In continuation with my previous post, some more revelations. The minimum size of a datafile that I can create in a 8k block size tablespace is 128 Kb. I created such a tablespace and this is what I saw after the KTFB Bitmapped File Space Bitmap block.
buffer tsn: 6 rdba: 0x00000009 (0/9)scn: 0x0000.00000000 seq: 0x01 flg: 0x05 tail: 0x00000001frmt: 0x02 chkval: 0xa709 type: 0x00=unknownHex dump of corrupt header 4 = CORRUPTDump of memory from 0x06FD2200 to 0x06FD2214So when there is no data the rdba does not specify the file ID while the block ID is specified.
Next I populated this tablespace with some data and compared both files with
WinMerge.
The same block id is now present at a different rdba.
buffer tsn: 6 rdba: 0x02c00009 (11/9)scn: 0x0000.003ac39c seq: 0x02 flg: 0x00 tail: 0xc39c2002frmt: 0x02 chkval: 0x0000 type: 0x20=FIRST LEVEL BITMAP BLOCKHex dump of block: st=0, typ_found=1Dump of memory from 0x04B12200 to 0x04B14200Now we also have a SCN and a new type. Memory addresses have also now changed. This I need to look into further. What I found most unusual is marking blocks as CORRUPT (enough to give someone a heart attack!).
Managed to get the before and after view in a tabular format.
Empty Tablespace | Non Empty TableSpace |
buffer tsn: 6 rdba: 0x02c00002 (11/2) scn: 0x0000.003ac320 seq: 0x01 flg: 0x00 tail: 0xc3201d01 frmt: 0x02 chkval: 0x0000 type: 0x1d=KTFB Bitmapped File Space Header Hex dump of block: st=0, typ_found=1 Dump of memory from 0x06FD2200 to 0x06FD4200 -- buffer tsn: 6 rdba: 0x02c00003 (11/3) scn: 0x0000.003ac314 seq: 0x01 flg: 0x00 tail: 0xc3141e01 frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap Hex dump of block: st=0, typ_found=1 Dump of memory from 0x06FD2200 to 0x06FD4200 -- buffer tsn: 6 rdba: 0x02c00004 (11/4) scn: 0x0000.003ac316 seq: 0x01 flg: 0x00 tail: 0xc3161e01 frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap Hex dump of block: st=0, typ_found=1 Dump of memory from 0x06FD2200 to 0x06FD4200 -- buffer tsn: 6 rdba: 0x02c00005 (11/5) scn: 0x0000.003ac318 seq: 0x01 flg: 0x00 tail: 0xc3181e01 frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap Hex dump of block: st=0, typ_found=1 Dump of memory from 0x06FD2200 to 0x06FD4200 -- buffer tsn: 6 rdba: 0x02c00006 (11/6) scn: 0x0000.003ac31a seq: 0x01 flg: 0x00 tail: 0xc31a1e01 frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap Hex dump of block: st=0, typ_found=1 Dump of memory from 0x06FD2200 to 0x06FD4200 -- buffer tsn: 6 rdba: 0x02c00007 (11/7) scn: 0x0000.003ac31c seq: 0x01 flg: 0x00 tail: 0xc31c1e01 frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap Hex dump of block: st=0, typ_found=1 Dump of memory from 0x06FD2200 to 0x06FD4200 -- buffer tsn: 6 rdba: 0x02c00008 (11/8) scn: 0x0000.003ac31e seq: 0x01 flg: 0x00 tail: 0xc31e1e01 frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap Hex dump of block: st=0, typ_found=1 Dump of memory from 0x06FD2200 to 0x06FD4200 -- buffer tsn: 6 rdba: 0x00000009 (0/9) scn: 0x0000.00000000 seq: 0x01 flg: 0x05 tail: 0x00000001 frmt: 0x02 chkval: 0xa709 type: 0x00=unknown Hex dump of corrupt header 4 = CORRUPT Dump of memory from 0x06FD2200 to 0x06FD2214 -- buffer tsn: 6 rdba: 0x0000000a (0/10) scn: 0x0000.00000000 seq: 0x01 flg: 0x05 tail: 0x00000001 frmt: 0x02 chkval: 0xa70a type: 0x00=unknown Hex dump of corrupt header 4 = CORRUPT Dump of memory from 0x06FD2200 to 0x06FD2214 -- buffer tsn: 6 rdba: 0x0000000b (0/11) scn: 0x0000.00000000 seq: 0x01 flg: 0x05 tail: 0x00000001 frmt: 0x02 chkval: 0xa70b type: 0x00=unknown Hex dump of corrupt header 4 = CORRUPT Dump of memory from 0x06FD2200 to 0x06FD2214 -- buffer tsn: 6 rdba: 0x0000000c (0/12) scn: 0x0000.00000000 seq: 0x01 flg: 0x05 tail: 0x00000001 frmt: 0x02 chkval: 0xa70c type: 0x00=unknown Hex dump of corrupt header 4 = CORRUPT Dump of memory from 0x06FD2200 to 0x06FD2214 -- buffer tsn: 6 rdba: 0x0000000d (0/13) scn: 0x0000.00000000 seq: 0x01 flg: 0x05 tail: 0x00000001 frmt: 0x02 chkval: 0xa70d type: 0x00=unknown Hex dump of corrupt header 4 = CORRUPT Dump of memory from 0x06FD2200 to 0x06FD2214 -- buffer tsn: 6 rdba: 0x0000000e (0/14) scn: 0x0000.00000000 seq: 0x01 flg: 0x05 tail: 0x00000001 frmt: 0x02 chkval: 0xa70e type: 0x00=unknown Hex dump of corrupt header 4 = CORRUPT Dump of memory from 0x06FD2200 to 0x06FD2214 -- buffer tsn: 6 rdba: 0x0000000f (0/15) scn: 0x0000.00000000 seq: 0x01 flg: 0x05 tail: 0x00000001 frmt: 0x02 chkval: 0xa70f type: 0x00=unknown Hex dump of corrupt header 4 = CORRUPT Dump of memory from 0x06FD2200 to 0x06FD2214 -- buffer tsn: 6 rdba: 0x00000010 (0/16) scn: 0x0000.00000000 seq: 0x01 flg: 0x05 tail: 0x00000001 frmt: 0x02 chkval: 0xa710 type: 0x00=unknown Hex dump of corrupt header 4 = CORRUPT Dump of memory from 0x06FD2200 to 0x06FD2214 | buffer tsn: 6 rdba: 0x02c00002 (11/2) scn: 0x0000.003ac37f seq: 0x02 flg: 0x00 tail: 0xc37f1d02 frmt: 0x02 chkval: 0x0000 type: 0x1d=KTFB Bitmapped File Space Header Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c00003 (11/3) scn: 0x0000.003ac37f seq: 0x01 flg: 0x00 tail: 0xc37f1e01 frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c00004 (11/4) scn: 0x0000.003ac316 seq: 0x01 flg: 0x00 tail: 0xc3161e01 frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c00005 (11/5) scn: 0x0000.003ac318 seq: 0x01 flg: 0x00 tail: 0xc3181e01 frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c00006 (11/6) scn: 0x0000.003ac31a seq: 0x01 flg: 0x00 tail: 0xc31a1e01 frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c00007 (11/7) scn: 0x0000.003ac31c seq: 0x01 flg: 0x00 tail: 0xc31c1e01 frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c00008 (11/8) scn: 0x0000.003ac31e seq: 0x01 flg: 0x00 tail: 0xc31e1e01 frmt: 0x02 chkval: 0x0000 type: 0x1e=KTFB Bitmapped File Space Bitmap Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c00009 (11/9) scn: 0x0000.003ac39c seq: 0x02 flg: 0x00 tail: 0xc39c2002 frmt: 0x02 chkval: 0x0000 type: 0x20=FIRST LEVEL BITMAP BLOCK Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c0000a (11/10) scn: 0x0000.003ac39c seq: 0x01 flg: 0x00 tail: 0xc39c2101 frmt: 0x02 chkval: 0x0000 type: 0x21=SECOND LEVEL BITMAP BLOCK Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c0000b (11/11) scn: 0x0000.003ac39a seq: 0x02 flg: 0x00 tail: 0xc39a2302 frmt: 0x02 chkval: 0x0000 type: 0x23=PAGETABLE SEGMENT HEADER Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c0000c (11/12) scn: 0x0000.003ac382 seq: 0x02 flg: 0x04 tail: 0xc3820602 frmt: 0x02 chkval: 0x8358 type: 0x06=trans data Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c0000d (11/13) scn: 0x0000.003ac382 seq: 0x02 flg: 0x04 tail: 0xc3820602 frmt: 0x02 chkval: 0x3a63 type: 0x06=trans data Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c0000e (11/14) scn: 0x0000.003ac382 seq: 0x02 flg: 0x04 tail: 0xc3820602 frmt: 0x02 chkval: 0x7f8e type: 0x06=trans data Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c0000f (11/15) scn: 0x0000.003ac39c seq: 0x01 flg: 0x00 tail: 0xc39c0601 frmt: 0x02 chkval: 0x0000 type: 0x06=trans data Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 -- buffer tsn: 6 rdba: 0x02c00010 (11/16) scn: 0x0000.003ac39c seq: 0x02 flg: 0x00 tail: 0xc39c0602 frmt: 0x02 chkval: 0x0000 type: 0x06=trans data Hex dump of block: st=0, typ_found=1 Dump of memory from 0x04B12200 to 0x04B14200 |