【bbed】bbed工具使用小记

最新推荐文章于 2022-06-28 09:54:39 发布
最新推荐文章于 2022-06-28 09:54:39 发布
阅读量376 收藏
点赞数
分类专栏： Oracle数据库-管理
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/q3dxdx/article/details/48948691
版权
[oracle@db1 oradata]$ pwd
/u01/oradata
[oracle@db1 oradata]$ ll
total 16
-rw-r--r--. 1 oracle oinstall   47 Oct  7 14:15 bbed.par
drwxr-x---. 2 oracle oinstall 4096 Oct  7 14:11 denver
drwxr-x---. 2 oracle oinstall 4096 Oct  5 10:08 denver_bak20151005
-rw-r--r--. 1 oracle oinstall  362 Oct  7 14:13 filelist.lst
[oracle@db1 oradata]$ cat filelist.lst 
1 /u01/oradata/denver/system01.dbf 713031680
2 /u01/oradata/denver/sysaux01.dbf 566231040
3 /u01/oradata/denver/undotbs01.dbf 314572800
4 /u01/oradata/denver/users01.dbf 5242880
5 /u01/oradata/denver/example01.dbf 104857600
6 /u01/oradata/denver/example02.dbf 104857600
7 /u01/oradata/denver/example03.dbf 104857600
8 /u01/oradata/denver/example04.dbf 104857600
[oracle@db1 oradata]$ cat bbed.par 
blocksize=8192
listfile=filelist.lst
mode=edit
[oracle@db1 oradata]$ bbed help=y
PASSWORD - Required parameter
FILENAME - Database file name
BLOCKSIZE - Database block size
LISTFILE - List file name
MODE - [browse/edit]
SPOOL - Spool to logfile [no/yes]
CMDFILE - BBED command file name
LOGFILE - BBED log file name
PARFILE - Parameter file name
BIFILE - BBED before-image file name
REVERT - Rollback changes from BIFILE [no/yes]
SILENT - Hide banner [no/yes]
HELP - Show all valid parameters [no/yes]
[oracle@db1 oradata]$ bbed parfile=bbed.par 
Password: < blockedit>

BBED: Release 2.0.0.0.0 - Limited Production on Wed Oct 7 14:16:49 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

************* !!! For Oracle Internal Use only !!! ***************

BBED> show
        FILE#           1
        BLOCK#          1
        OFFSET          0
        DBA             0x00400001 (4194305 1,1)
        FILENAME        /u01/oradata/denver/system01.dbf
        BIFILE          bifile.bbd
        LISTFILE        filelist.lst
        BLOCKSIZE       8192
        MODE            Edit
        EDIT            Unrecoverable
        IBASE           Dec
        OBASE           Dec
        WIDTH           80
        COUNT           512
        LOGFILE         log.bbd
        SPOOL           No

BBED> info
 File#  Name                                                        Size(blks)
 -----  ----                                                        ----------
     1  /u01/oradata/denver/system01.dbf                                 87040
     2  /u01/oradata/denver/sysaux01.dbf                                 69120
     3  /u01/oradata/denver/undotbs01.dbf                                38400
     4  /u01/oradata/denver/users01.dbf                                    640
     5  /u01/oradata/denver/example01.dbf                                12800
     6  /u01/oradata/denver/example02.dbf                                12800
     7  /u01/oradata/denver/example03.dbf                                12800
     8  /u01/oradata/denver/example04.dbf                                12800

BBED> 

SQL> select username,account_status,DEFAULT_TABLESPACE from dba_users where DEFAULT_TABLESPACE='USERS' and account_status='OPEN';


USERNAME                       ACCOUNT_STATUS                   DEFAULT_TABLESPACE
------------------------------ -------------------------------- ------------------------------
HR                             OPEN                             USERS
SCOTT                          OPEN                             USERS


SQL> 

以scott连接数据库：

SQL> show user;
USER is "SCOTT"
SQL> create table t1(id int, name varchar2(10));

Table created.

SQL> insert into t1 values(1,'a');

1 row created.

SQL> insert into t1 values(2,'b');

1 row created.

SQL> insert into t1 values(3,'c');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t1;

        ID NAME
---------- ----------
         1 a
         2 b
         3 c

SQL> 
下面通过bbed在外部修改这个表id=1的name字段的值c为d：

先找到t1对象的位置：

SQL> select SEGMENT_NAME,EXTENT_ID,FILE_ID,BLOCK_ID,BLOCKS from dba_extents where SEGMENT_NAME='T1';

SEGMENT_NAME                    EXTENT_ID    FILE_ID   BLOCK_ID     BLOCKS
------------------------------ ---------- ---------- ---------- ----------
T1                                      0          4        528          8

SQL> 

其实找到我们要修改的row行的位置更好：

SQL> select rowid,a.* from t1 a where a.rowid='AAATH1AAEAAAAIUAAA';


ROWID                      ID NAME
------------------ ---------- ----------
AAATH1AAEAAAAIUAAA          1 a


SQL> 

利用内部函数将rowid分解：

SQL> select dbms_rowid.rowid_object(rowid)  object_id,
  2  dbms_rowid.rowid_relative_fno(rowid) file_id,
  3  dbms_rowid.rowid_block_number(rowid)  block_id,
  4  dbms_rowid.rowid_row_number(rowid) row_num,
  5  a.*
  6  from t1 a where a.rowid='AAATH1AAEAAAAIUAAA';


 OBJECT_ID    FILE_ID   BLOCK_ID    ROW_NUM         ID NAME
---------- ---------- ---------- ---------- ---------- ----------
     78325          4        532          0          1 a


SQL> 

我们的1,a记录在4号文件的532号块上，直接用bbed定位：

[oracle@db1 oradata]$ bbed PARFILE=./bbed.par
Password: 


BBED: Release 2.0.0.0.0 - Limited Production on Thu Oct 8 20:11:09 2015


Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


************* !!! For Oracle Internal Use only !!! ***************


BBED> set file 4
        FILE#           4


BBED> set block 532
        BLOCK#          532


BBED> dump /v
 File: /u01/oradata/denver/users01.dbf (4)
 Block: 532     Offsets:    0 to  511  Dba:0x01000214
-------------------------------------------------------
 06a20000 14020001 29ff1400 00000106 l ........).......
 a42b0000 01000000 f5310100 25ff1400 l .+.......1..%...
 00000000 02003200 10020001 09000000 l ......2.........
 fb030000 ba03c000 f5001400 03200000 l ............. ..
 29ff1400 00000000 00000000 00000000 l )...............
 00000000 00000000 00000000 00000000 l ................
 00000000 00010300 ffff1800 801f651f l ..............e.
 651f0000 0300901f 881f801f 00000000 l e...............
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................


 <16 bytes per line>


BBED> 

这里显示的32行，每行16bytes，那么只显示了512bytes，也就是0.5k。我们一个oracle data block是8192bytes，所以我们需要count 8192：

BBED> dump /v count 8192
 File: /u01/oradata/denver/users01.dbf (4)
 Block: 532     Offsets:    0 to 8191  Dba:0x01000214
-------------------------------------------------------
 06a20000 14020001 29ff1400 00000106 l ........).......
 a42b0000 01000000 f5310100 25ff1400 l .+.......1..%...
 00000000 02003200 10020001 09000000 l ......2.........
 fb030000 ba03c000 f5001400 03200000 l ............. ..
 29ff1400 00000000 00000000 00000000 l )...............
 00000000 00000000 00000000 00000000 l ................
 00000000 00010300 ffff1800 801f651f l ..............e.
 651f0000 0300901f 881f801f 00000000 l e...............
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 00000000 00000000 00000000 l ................
 00000000 2c010202 c1040163 2c010202 l ....,......c,...
 c1030162 2c010202 c1020161 010629ff l ...b,......a..).


 <16 bytes per line>


BBED> 

计算字母a的16进制：

SQL> select dump('a',1016) from dual;

DUMP('A',1016)
--------------------------------------
Typ=96 Len=1 CharacterSet=ZHS16GBK: 61

SQL>

在bbed里面找当前块中61的记录：

BBED> find /x 61 curr
 File: /u01/oradata/denver/users01.dbf (4)
 Block: 532              Offsets: 8187 to 8191           Dba:0x01000214
------------------------------------------------------------------------
 61010629 ff 
<8187=61,8188=01,8189=06,8190=29,8191=ff>

 <32 bytes per line>


BBED> 

BBED> modify /x 62 file 4 block 532 offset 8187 <我们把offset=8187的记录修改为62>
 File: /u01/oradata/denver/users01.dbf (4)
 Block: 532              Offsets: 8187 to 8191           Dba:0x01000214
------------------------------------------------------------------------
 62010629 ff 
<成功修改>

 <32 bytes per line>


BBED> verify
DBVERIFY - Verification starting
FILE = /u01/oradata/denver/users01.dbf
BLOCK = 532


Block 532 is corrupt
Corrupt block relative dba: 0x01000214 (file 0, block 532)
Bad check value found during verification
Data in bad block:
 type: 6 format: 2 rdba: 0x01000214
 last change scn: 0x0000.0014ff29 seq: 0x1 flg: 0x06
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0xff290601
 check value in block header: 0x2ba4
 computed block checksum: 0x300




DBVERIFY - Verification complete


Total Blocks Examined         : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing   (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing   (Index): 0
Total Blocks Empty            : 0
Total Blocks Marked Corrupt   : 1
Total Blocks Influx           : 0
Message 531 not found;  product=RDBMS; facility=BBED

<使用verify验证块，Total Blocks Marked Corrupt   : 1表示有坏块>


BBED> sum file 4 block 532
Check value for File 4, Block 532:
current = 0x2ba4, required = 0x28a4


BBED> verify
DBVERIFY - Verification starting
FILE = /u01/oradata/denver/users01.dbf
BLOCK = 532


Block 532 is corrupt
Corrupt block relative dba: 0x01000214 (file 0, block 532)
Bad check value found during verification
Data in bad block:
 type: 6 format: 2 rdba: 0x01000214
 last change scn: 0x0000.0014ff29 seq: 0x1 flg: 0x06
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0xff290601
 check value in block header: 0x2ba4
 computed block checksum: 0x300




DBVERIFY - Verification complete


Total Blocks Examined         : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing   (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing   (Index): 0
Total Blocks Empty            : 0
Total Blocks Marked Corrupt   : 1
Total Blocks Influx           : 0
Message 531 not found;  product=RDBMS; facility=BBED




BBED> sum file 4 block 532 apply
Check value for File 4, Block 532:
current = 0x28a4, required = 0x28a4
<重新校验块的一致性>

BBED> verify
DBVERIFY - Verification starting
FILE = /u01/oradata/denver/users01.dbf
BLOCK = 532




DBVERIFY - Verification complete


Total Blocks Examined         : 1
Total Blocks Processed (Data) : 1
Total Blocks Failing   (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing   (Index): 0
Total Blocks Empty            : 0
Total Blocks Marked Corrupt   : 0
Total Blocks Influx           : 0
Message 531 not found;  product=RDBMS; facility=BBED



BBED> 

让scott用户重新查询一次表：

SQL> select * from t1;


        ID NAME
---------- ----------
         1 a
         2 b
         3 c

没有变化，肯定是buffer cache的原因。
SQL> alter system flush buffer_cache;


System altered.


SQL> select * from t1;


        ID NAME
---------- ----------
         1 b
         2 b
         3 c


SQL> 

成功修改。


总结：

1. bbed可以修改oracle data block；

2. 修改时必须指定modify子句为如下格式：

    modify /x 62 file 4 block 532 offset 8187，也就是必须指定文件号、块号以及偏移值（偏移值从0到8191）。

    0开头的部分offset是block header，里面有事务槽数据，以及block的其他元数据，一般不允许修改。

    /x 62，表示修改为十六进制的62（也就是字母b）；

3. 修改之后，必须使用sum file 4 block 532 apply来重新校验block的一致性；

4. 其实这个工具对于海量的数据恢复来说，并没有什么卵用，因为其恢复粒度太细了，不具备可行性。

q3dxdx
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
bbed Oracle数据修复工具
04-06
3. **启动bbed**：使用bbed命令行工具，加载损坏的数据文件，并定位到需要修复的块。 4. **复制数据**：如果存在健康的副本，可以将健康副本中的相同位置的数据块复制到损坏的块中。bbed支持多种操作，如COPY、EDIT...
Oracle BBED工具解压包
09-30
BBED(Oracle Block Browerand EDitor Tool)，用来直接查看和修改数据文件数据的一个工具，是Oracle一款内部工具，可以直接修改Oracle数据文件块的内容，在一些极端恢复场景下比较有用。该工具不受Oracle支持。
BBED的详细说明
白非马的博客
05-02 5536
一. BBED介绍 “` Thename bbed is an acronym for Block Browser and EDitor and it is shipped with thedatabase. It is intended for Oracle internal use only and the company neverpublishes any details...
【BBED】bbed的使用(三)
sqlora的专栏
05-14 648
bbed的使用(一)介绍了BBED的编译安装。 bbed的使用(二)介绍了bbed的语法规则和常用命令的使用。 本文继续介绍bbed常用命令的使用。 17 DUMP[/v] [ DBA | FILENAME | FILE | BLOCK | OFFSET | COUNT ] dump 命令可以转储数据块的内容。 使用/v 选项可以输出详细的内容。有上面的提示可以看出，dump命令可以指定DBA,FILENAME,FILE,BLOCK,OFFSET,COUNT参数。 如果没有...
bbed安装及配置
听雪楼主
11-27 1639
bbed安装及配置 1. 什么是bbed ？ Oracle Block Brower and EDitor Tool,是一个可以对oracle data block进行查看，编辑修改的内置工具。 对于bbed，oracle本身是不提供支持的. 2. 如何编译bbed环境？10g版本： 1) 编译bbed cd $ORACLE_HOME/rdbms/lib make -f $ORACLE_HO...
Oracle 之BBED 工具介绍
雨花石
02-21 2609
oracle bbed
oracle--BBED (dump 深入实践三)
Z14523299999的博客
05-05 180
一,工具介绍 　　bbed是Block Browser and Editor（块浏览编辑器）的缩写，它是Oracle数据库在安装时一起附带的工具。 一般此工具倾向于仅作为Oracle内部使用，且Oracle公司并不公开此工具使用细节。 由于bbed可以对Oracle数据库中的数据块进行内容修改和破坏，因此此工具功能强大同时伴有很高的使用风险。 二,工具...
bbed工具依赖环境bbed.zip
最新发布
11-10
使用方法解压后 cd /bbed cp ssbbded.o sbbdpt.o $ORACLE_HOME/rdbms/lib/ cp bbedus.msb bbedus.msg $ORACLE_HOME/rdbms/mesg/ cd $ORACLE_HOME/rdbms/lib/ make -f ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $...
bbed使用.docx
07-07
**bbed工具详解** 在Oracle数据库管理中，`bbed`是一个非常实用的工具，主要用于在Linux环境下对数据库的数据文件进行直接编辑。由于11g版本的Linux环境中默认并未提供`bbed`，因此需要从10g版本中获取必要的文件并...
Oracle bbed工具 包含Linux和Windows版本
06-21
Oracle bbed工具是Block Browser and Editor（块浏览编辑器）的缩写，...由于bbed可以对Oracle数据库中的数据块进行内容修改和破坏，因此此工具功能强大同时伴有很高的使用风险。 该资源包含了windows版本和 linux版本
bbed_for_win_11G
04-07
压缩文件中的bbed_win 中的文件解压到 $ORACLE_HOME\bin 压缩文件中的bbed 中的bbedus.msb和bbedzhs.msb文件解压到 $ORACLE_HOME\RDBMS\mesg 即可运行bbed了
oracle11gR2 安装bbed工具
08-07
NULL 博文链接：https://wrong1111.iteye.com/blog/2110342
bbed工具——12C、19C（64位）
10-19
数据库文件修改工具，块修改，bbed手术刀，文件编译等操作数据库文件修改工具，块修改，bbed手术刀，文件编译等操作
【tool】bbed的安装及使用
践行见远
02-20 1354
1、11g下bbed的安装 windows环境下没有提供bbed,以下操作均为linux环境下操作。 11g下编译安装bbed缺少文件，需要从10g中拷贝相关文件   其中把sbbdpt.o和ssbbded.o拷贝到$ORACLE_HOME/rdbms/lib/目录下。  把bbedus.msb和bbedus.msg拷贝到$ORACLE_HOME/mesg/目录下。 然后手动编译 c
BBED如何编译和使用
evil0305的博客
08-25 171
OracleDatabase 11g及以后版本中不再提供BBED库文件，但是可以用10g的文件编译出来，需要先从10g中复制如下文件到相应目录，然后再执行上述连接命令，参考如下步骤： （1）复制Oracle 10g文件 cp $ORA10g_HOME/rdbms/lib/ssbbded.o to$ORA11g_HOME/rdbms/lib cp $ORA10g_HOME/rdbms/lib/sbbdpt.o to $ORA11g_HOME/rdbms/lib cp $ORA10g_HOME/rdbms/m
bbed一（安装）
04-14 86
bbed ----------------------- block brows editer是oracle提供的块编辑工具但这个工具是内部使用的一旦使用oracle将不再支持 这个工具没有windows版本linux/u...
重庆思庄oracle技术分享-oracle bbed安装及配置
duanweifang的博客
06-28 271
重庆思庄oracle技术分享-oracle bbed安装及配置
BBED工具
zuixinnet的专栏
04-17 716
一、BBED工具 1.BBED的安装 oracle 11g中缺bbed包,oracle11g bbed install and example 上传（sbbdpt.o ssbbded.o bbedus.msb，该三个文件拷贝oracle的linux64版本的）文件 $ORACLE_HOME/rdbms/lib/ssbbded.o $ORACLE_HOME/rdbms/lib/s
dissassembling_the_data_block-converted(1).docx
02-14
A Guide to the bbed Block Browser and Editor

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值