When 11241_bbed2.txt,11242.txt

Source: Internet
Author: User

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>

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.