When 11241_bbed2.txt,11242.txt
201710000112420.bbed's use question 2.txt
-- // Bbed is a good tool for exploring oracle data blocks. Sometimes it can directly view the internal structure of oracle internal blocks without dumping.
-- // Pay attention to some problems during use. A similar error was made yesterday. The following is an example:
SCOTT @ book> select rowid, dept. * from dept;
ROWID DEPTNO DNAME LOC
-------------------------------------------------------
AAAVRCAAEAAAACHAAA 10 ACCOUNTING NEW YORK
AAAVRCAAEAAAACHAAB 20 RESEARCH DALLAS
AAAVRCAAEAAAACHAAC 30 SALES CHICAGO
AAAVRCAAEAAAACHAAD 40 OPERATIONS BOSTON
SCOTT @ book> @ & r/rowid AAAVRCAAEAAAACHAAA
Object file block row ROWID_DBA DBA TEXT
------------------------------------------------------------------------------------------------------------------------
87106 4 135 0 0x1000087 4,135 alter system dump datafile 4 block 135;
SCOTT @ book> select OWNER, SEGMENT_NAME, SEGMENT_TYPE, HEADER_FILE, HEADER_BLOCK from dba_segments where owner = user and segment_name = 'dept ';
OWNER SEGMENT_NAME SEGMENT_TYPE HEADER_FILE HEADER_BLOCK
-------------------------------------------------------------------
Scott dept table 4 130
-- // I once mentioned:
-- // If I execute a command similar to the following:
BBED> p tailchk dba 4,131
Ub4 tailchk @ 8188 0x0ee40602
BBED> p tailchk dba 4,130
BBED-00400: invalid blocktype (35)
BBED> p tailchk dba 4,131
BBED-00400: invalid blocktype (35)
-- // The method I used at the time is to first enter dba in front. You can understand the above command as follows:
BBED> set DBAs 4,131
DBA 0x01000083 (16777347 4,131)
BBED> p tailchk dba 4,130
BBED-00400: invalid blocktype (35)
BBED> show all
FILE #4
BLOCK #130.
OFFSET 8188
DBA 0x01000082 (16777346 4,130)
FILENAME/mnt/ramdisk/book/users01.dbf
BIFILE bifile. bbd
LISTFILE/home/oracle/bbed/filelist.txt
Blocsize 8192
MODE Edit
EDIT Unrecoverable
IBASE Dec
OBASE Dec
WIDTH 160
COUNT 64
LOGFILE log. bbd
SPOOL Yes
-- // Check the FILE # = 4, BLOCK # = 130 displayed in show all.
BBED> p tailchk dba 4,131
BBED-00400: invalid blocktype (35)
-- // When you input p tailchk dba 4,131, you actually access dba 4,130 first and then dba 4,131.
-- // If dba 4,130 access is abnormal, dba 4,131 will not be accessed. execution error.
BBED> p dba 4,131 tailchk
Ub4 tailchk @ 8188 0x0ee40602
-- // I think it is best to enter parameters according to the help prompt for execution of bbed.
-- // For example, display the execution method of the P command:
BBED> help p
PRINT [/x | d | u | o | c] [DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | * symbol]
-- // It is best to enter the following parameters in the order displayed:
BBED> p dba 4,131 tailchk
Ub4 tailchk @ 8188 0x0ee40602
-- // You can directly read and access the tailchk of dba 4,131.
BBED> p/d DBAs 4,131 tailchk
Ub4 tailchk @ 8188 249824770
BBED> p filename '/mnt/ramdisk/book/users01.dbf' block 131 tailchk
Ub4 tailchk @ 8188 0x0ee40602
-- // If it is written as follows:
BBED> p filename '/mnt/ramdisk/book/users01.dbf' tailchk block 131
Ub4 tailchk @ 0 0x0000a206
-- // I do not know which block to access.
-- // Dump has a similar command input method:
BBED> help dump
DUMP [/v] [DBA | FILENAME | FILE | BLOCK | OFFSET | COUNT]
BBED> dump/v filename '/mnt/ramdisk/book/users01.dbf' block 131 offset 0 count 256
File:/mnt/ramdisk/book/users01.dbf (4)
Block: 131 Offsets: 0 to 255 Dba: 0x01000083
Bytes -----------------------------------------------------------------------------------------------------------
06a20000 83000001 e40e0e00 00000204 5d700000 01000c00 42540100 e40e0e00 l ......] p ...... BT ......
0000e81f 02003200 80000001 00000000 00000000 00000000 00000000 00000000 l ...... 2 .........................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 ffff0e00 981f8a1f 8a1f0000 109c819 73191e19 c5186c6 l ........................ s ..... l.
1018b417 5817fc16 a0164416 e8158c15 3215d814 7c142014 c6136c13 1913c612 l ...... X ...... D ...... 2 ...... | .....
6b121012 ba116411 0811ac10 58100410 a80f4c0f f50e9d0e 2017ee90d 970d2017d l k ..... d ..... X ..... L ..... C ..... e.
F10c9d0c 2017ced0b 970b410b f50aa90a 4d0af109 a1095109 0108b108 5d080908 l .... E ..... A ..... M ..... q...]...
Bf077507 1f07c906 70061706 bb055f05 0b05b704 5c040104 b812c812 d812e812 l .. u ..... p ..... _..... \...........
<32 bytes per line>
-- // If the input is as follows:
BBED> dump/v offset 0 count 256 filename '/mnt/ramdisk/book/users01.dbf' block 135
File:/mnt/ramdisk/book/users01.dbf (4)
Block: 135 Offsets: 0 to 255 Dba: 0x01000087
Bytes -----------------------------------------------------------------------------------------------------------
06a20000 87000001 70786917 03000204 56a50000 01001600 42540100 70786917 l.
0300e81f 021f3200 80000001 09000200 64030000 b067c100 9a002e00 00800000 l ...... 2 ......... d .... g ..........
F00e0e00 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00010400 ffff1a00 261f221f 221f0000 04007e1f 261f541f 3c1f8918 l ............&.".".....~. &. T. <...
2d18d117 7e172b17 d8168516 3216df15 8b153715 db147f14 2314c713 74132113 l -...~. +... 2... 7... #... t .!.
C5126912 0d12b111 5511f910 9d104110 e50f890f 350fe10e 850e290e ce0d730d l .. I ..... U ..... A ..... 5 .....)... s.
170dbb0c 640c0d0c ba0b670b 140bc10a 6e0a1b0a c8097509 1a09bf08 6b081608 l .... d ..... g ..... n ..... u ..... k...
Bb076007 0e07bc06 6a061806 c5057205 1605ba04 65041004 02000400 12000000 l .. '..... j ..... r ..... e ...........
<32 bytes per line>
BBED> dump/v offset 8000 count 256 filename '/mnt/ramdisk/book/users01.dbf' block 135
File:/mnt/ramdisk/book/users01.dbf (4)
Block: 135 Offsets: 0 to 255 Dba: 0x01000087
Bytes -----------------------------------------------------------------------------------------------------------
06a20000 87000001 70786917 03000204 56a50000 01001600 42540100 70786917 l.
0300e81f 021f3200 80000001 09000200 64030000 b067c100 9a002e00 00800000 l ...... 2 ......... d .... g ..........
F00e0e00 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00010400 ffff1a00 261f221f 221f0000 04007e1f 261f541f 3c1f8918 l ............&.".".....~. &. T. <...
2d18d117 7e172b17 d8168516 3216df15 8b153715 db147f14 2314c713 74132113 l -...~. +... 2... 7... #... t .!.
C5126912 0d12b111 5511f910 9d104110 e50f890f 350fe10e 850e290e ce0d730d l .. I ..... U ..... A ..... 5 .....)... s.
170dbb0c 640c0d0c ba0b670b 140bc10a 6e0a1b0a c8097509 1a09bf08 6b081608 l .... d ..... g ..... n ..... u ..... k...
Bb076007 0e07bc06 6a061806 c5057205 1605ba04 65041004 02000400 12000000 l .. '..... j ..... r ..... e ...........
<32 bytes per line>
-- // The first execution is correct, and the first execution is incorrect (offset or 0 ).
-- // If you enter the parameters in the order of dump help, no problem will occur.
BBED> help dump
DUMP [/v] [DBA | FILENAME | FILE | BLOCK | OFFSET | COUNT]
BBED> dump/v filename '/mnt/ramdisk/book/users01.dbf' block 135 offset 0 count 256
File:/mnt/ramdisk/book/users01.dbf (4)
Block: 135 Offsets: 0 to 255 Dba: 0x01000087
Bytes -----------------------------------------------------------------------------------------------------------
06a20000 87000001 70786917 03000204 56a50000 01001600 42540100 70786917 l.
0300e81f 021f3200 80000001 09000200 64030000 b067c100 9a002e00 00800000 l ...... 2 ......... d .... g ..........
F00e0e00 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00010400 ffff1a00 261f221f 221f0000 04007e1f 261f541f 3c1f8918 l ............&.".".....~. &. T. <...
2d18d117 7e172b17 d8168516 3216df15 8b153715 db147f14 2314c713 74132113 l -...~. +... 2... 7... #... t .!.
C5126912 0d12b111 5511f910 9d104110 e50f890f 350fe10e 850e290e ce0d730d l .. I ..... U ..... A ..... 5 .....)... s.
170dbb0c 640c0d0c ba0b670b 140bc10a 6e0a1b0a c8097509 1a09bf08 6b081608 l .... d ..... g ..... n ..... u ..... k...
Bb076007 0e07bc06 6a061806 c5057205 1605ba04 65041004 02000400 12000000 l .. '..... j ..... r ..... e ...........
<32 bytes per line>
BBED> dump/v filename '/mnt/ramdisk/book/users01.dbf' block 135 offset 8000 count 256
File:/mnt/ramdisk/book/users01.dbf (4)
Block: 135 Offsets: 8000 to 8191 Dba: 0x01000087
Bytes -----------------------------------------------------------------------------------------------------------
Ff0180ff 018004c3 07382402 c1022c00 1204c306 2423ff01 80196a61 76612f6e l ...... 8 $ ......, ...... $ #. java/n
65742f55 524c436c 6173734c 6f616465 72243402 c102ff02 c11e0778 7109180c l et/URLClassLoader $4...
2e120778 7109180c 2e122c00 0302c115 08524553 45415243 48064441 4c4c4153 l ...... xq ......, ...... RESEARCH. DALLAS
2c000302 c1290a4f 50455241 54494f4e 5306424f 53544f4e 2c000302 c11f0553 l,...). OPERATIONS. BOSTON, ...... S
414c4553 07434849 4341474f 3c020302 c1150852 45534541 52434806 44414c4c l ALES. CHICAGO <...... RESEARCH. DALL
201732c00 0302c10b 0a414343 4f554e54 494e4708 4e455720 594f524b 02067078 l AS, ...... ACCOUNTING. new york... px
<32 bytes per line>