修改块数据-bbed2.pdf - 墨天轮文档

修改块数据-bbed2.pdf

牛仔宅

289

4页

1次

2021-10-15

10墨值下载

修改块数据-bbed2.txt

0、编译bbed：

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed

1、查询表的rowid

SQL> select rowid,e.* from emp e;

ROWID EMPNO ENAME JOB MGR HIREDATE

SAL COMM DEPTNO

------------------ ---------- ---------- --------- ---------- ---------

---------- ---------- ----------

AAANEzAAEAAAAAdAAA 7369 SMITH CLERK 7902 17-DEC-80

800 20

AAANEzAAEAAAAAdAAB 7499 ALLEN SALESMAN 7698 20-FEB-81

1600 300 30

AAANEzAAEAAAAAdAAC 7521 WARD SALESMAN 7698 22-FEB-81

1250 500 30

AAANEzAAEAAAAAdAAD 7566 JONES MANAGER 7839 02-APR-81

2975 20

AAANEzAAEAAAAAdAAE 7654 MARTIN SALESMAN 7698 28-SEP-81

1250 1400 30

AAANEzAAEAAAAAdAAF 7698 BLAKE MANAGER 7839 01-MAY-81

2850 30

AAANEzAAEAAAAAdAAG 7782 CLARK MANAGER 7839 09-JUN-81

2450 10

AAANEzAAEAAAAAdAAH 7788 SCOTT ANALYST 7566 19-APR-87

3000 20

AAANEzAAEAAAAAdAAI 7839 KING PRESIDENT 17-NOV-81

5000 10

AAANEzAAEAAAAAdAAJ 7844 TURNER SALESMAN 7698 08-SEP-81

1500 0 30

AAANEzAAEAAAAAdAAK 7876 ADAMS CLERK 7788 23-MAY-87

1100 20

AAANEzAAEAAAAAdAAL 7900 JAMES CLERK 7698 03-DEC-81

950 30

AAANEzAAEAAAAAdAAM 7902 FORD ANALYST 7566 03-DEC-81

3000 20

AAANEzAAEAAAAAdAAN 7934 MILLER CLERK 7782 23-JAN-82

1300 10

2、通过rowid得到文件号和块号

SQL> select DBMS_ROWID.ROWID_RELATIVE_FNO('AAANEzAAEAAAAAdAAA') file_id from

dual;

FILE_ID

----------

SQL> select DBMS_ROWID.ROWID_BLOCK_NUMBER('AAANEzAAEAAAAAdAAA') block_id from

dual;

BLOCK_ID

----------

第 1 页

Tel：010-88589826 Fax：010-88587520 网址: http://www.cuug.com

修改块数据-bbed2.txt

3、设置文件4，第29块

BBED> set dba 4,29

DBA 0x0100001d (16777245 4,29)

4、使用map查看block结构

BBED> map

File: /home/oracle/oracle/product/10.2.0/oradata/cuug/users01.dbf (4)

Block: 29 Dba:0x0100001d

------------------------------------------------------------

KTB Data Block (Table/Cluster)

struct kcbh, 20 bytes @0

struct ktbbh, 72 bytes @20

struct kdbh, 14 bytes @100

struct kdbt[1], 4 bytes @114

sb2 kdbr[14] @118

ub1 freespace[5754] @146

ub1 rowdata[2288] @5900

ub4 tailchk @8188

5、设置行数据的偏移量

BBED> set offset 5900

OFFSET 5900

6、查看block内容

BBED> d /v

File: /home/oracle/oracle/product/10.2.0/oradata/cuug/users01.dbf (4)

Block: 29 Offsets: 5900 to 6411 Dba:0x0100001d

-------------------------------------------------------

2c000803 c24a4605 534d4954 4805434c l ,...F.SMITH.CL

45524b03 c2500307 77b40c11 01010102 l ERK...w.....

c209ff02 c1152c00 0803c24b 6405414c l ..,...d.AL

4c454e08 53414c45 534d414e 03c24d63 l LEN.SALESMAN.c

0777b502 14010101 02c21102 c20402c1 l .w.......

1f2c0008 03c24c16 04574152 44085341 l .,.....WARD.SA

4c45534d 414e03c2 4d630777 b5021601 l LESMAN.c.w..

010103c2 0d3302c2 0602c11f 2c000803 l ...3..,...

c24c4305 4a4f4e45 53074d41 4e414745 l C.JONES.MANAGE

5203c24f 280777b5 04020101 0103c21e l R.(.w.....

4cff02c1 152c0008 03c24d37

064d4152 l L..,...7.MAR

54494e08 53414c45 534d414e 03c24d63 l TIN.SALESMAN.c

0777b509 1c010101 03c20d33 02c20f02 l .w.....3..

c11f2c00 0803c24d 6305424c 414b4507 l ,...c.BLAKE.

4d414e41 47455203 c24f2807 77b50501 l MANAGER.(.w.

第 2 页

Tel：010-88589826 Fax：010-88587520 网址: http://www.cuug.com

修改块数据-bbed2.txt

01010103 c21d33ff 02c11f2c 000803c2 l ....3..,...

4e530543 4c41524b 074d414e 41474552 l NS.CLARK.MANAGER

03c24f28 0777b506 09010101 03c21933 l .(.w.....3

ff02c10b 2c000803 c24e5905 53434f54 l ..,...Y.SCOT

5407414e 414c5953 5403c24c 430777bb l T.ANALYST.C.w

04130101 0102c21f ff02c115 2c000803 l ........,...

c24f2804 4b494e47 09505245 53494445 l (.KING.PRESIDE

4e54ff07 77b50b11 01010102 c233ff02 l NT..w.......

c10b2c00 0803c24f 2d065455 524e4552 l ,...-.TURNER

0853414c 45534d41 4e03c24d 630777b5 l .SALESMAN.c.w

09080101 0102c210 018002c1 1f2c0008 l .........,..

03c24f4d 05414441 4d530543 4c45524b l .M.ADAMS.CLERK

03c24e59 0777bb05 17010101 02c20cff l .Y.w......

02c1152c 000802c2 50054a41 4d455305 l .,....JAMES.

434c4552 4b03c24d 630777b5 0c030101 l CLERK.c.w...

0103c20a 33ff02c1 1f2c0008 03c25003 l ..3..,....

04464f52 4407414e 414c5953 5403c24c l .FORD.ANALYST.

<16 bytes per line>

7、查找SMITH

BBED> f /c SMITH top

File: /home/oracle/oracle/product/10.2.0/oradata/cuug/users01.dbf (4)

Block: 29 Offsets: 5908 to 6419 Dba:0x0100001d

------------------------------------------------------------------------

534d4954 4805434c 45524b03 c2500307 77b40c11 01010102 c209ff02 c1152c00

0803c24b 6405414c 4c454e08 53414c45 534d414e 03c24d63 0777b502 14010101

02c21102 c20402c1 1f2c0008 03c24c16 04574152 44085341 4c45534d 414e03c2

BBED> d /v

File: /home/oracle/oracle/product/10.2.0/oradata/cuug/users01.dbf (4)

Block: 29 Offsets: 5908 to 6419 Dba:0x0100001d

-------------------------------------------------------

534d4954 4805434c 45524b03 c2500307 l SMITH.CLERK...

77b40c11 01010102 c209ff02 c1152c00 l w.......,.

0803c24b 6405414c 4c454e08 53414c45 l ..d.ALLEN.SALE

534d414e 03c24d63 0777b502 14010101 l SMAN.c.w....

8、将其修改为CUUGBJ

BBED> m /c CUUGB dba 4,29 offset 5908 －－注意修改的字符串的长度与原来的要一

样

File: /home/oracle/oracle/product/10.2.0/oradata/cuug/users01.dbf (4)

Block: 29 Offsets: 5908 to 6419 Dba:0x0100001d

------------------------------------------------------------------------

43555547 424a434c 45524b03 c2500307 77b40c11 01010102 c209ff02 c1152c00

0803c24b 6405414c 4c454e08 53414c45 534d414e 03c24d63 0777b502 14010101

02c21102 c20402c1 1f2c0008 03c24c16 04574152 44085341 4c45534d 414e03c2

4d630777 b5021601 010103c2 0d3302c2 0602c11f 2c000803 c24c4305 4a4f4e45

9、在修改数据块之后，重新计算并更新checksum

BBED> sum apply

Check value for File 4, Block 29:

current = 0xb657, required = 0xb657

第 3 页

Tel：010-88589826 Fax：010-88587520 网址: http://www.cuug.com

of 4

10墨值下载

oracle bbed

相关文档

评论