ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 利用bbed修改数据

利用bbed修改数据

原创 Linux操作系统 作者:g644516804 时间:2011-12-29 10:35:41 0 删除 编辑

[oracle@STCS oradata]$ bbed parfile=/oradata/par.txt

Password:

 

BBED: Release 2.0.0.0.0 - Limited Production on Fri Dec 16 16:42:47 2011

 

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

 

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

 

BBED> set dba 4,174 offset 0

        DBA             0x010000ae (16777390 4,174)

        OFFSET          0

 

BBED> find /c lerry

 File: /oradata/ora11/users01.dbf (4)

 Block: 174              Offsets: 8151 to 8191           Dba:0x010000ae

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

 6c657272 79206973 20626566 61756c74 792c0101 106d7920 6e616d65 20697320

 6c657272 79010696 96

 

 <32 bytes per line>

 

BBED> dump /v dba 4,174 offset 8151 count 128

 File: /oradata/ora11/users01.dbf (4)

 Block: 174     Offsets: 8151 to 8191  Dba:0x010000ae

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

 6c657272 79206973 20626566 61756c74 l lerry is befault

 792c0101 106d7920 6e616d65 20697320 l y,...my name is

 6c657272 79010696 96                l lerry....

 

 <16 bytes per line>

 

BBED> modify /c 'test' dba 4,174 offset 8151

 File: /oradata/ora11/users01.dbf (4)

 Block: 174              Offsets: 8151 to 8191           Dba:0x010000ae

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

 74657374 79206973 20626566 61756c74 792c0101 106d7920 6e616d65 20697320

 6c657272 79010696 96

 

 <32 bytes per line>

 

BBED>  dump /v dba 4,174 offset 8151 count 128

 File: /oradata/ora11/users01.dbf (4)

 Block: 174     Offsets: 8151 to 8191  Dba:0x010000ae

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

 74657374 79206973 20626566 61756c74 l testy is befault

 792c0101 106d7920 6e616d65 20697320 l y,...my name is

 6c657272 79010696 96                l lerry....

 

 <16 bytes per line>

 

BBED> sum dba 4,174

Check value for File 4, Block 174:

current = 0x3218, required = 0x2b1e

 

BBED> sum dba 4,174 apply

Check value for File 4, Block 174:

current = 0x2b1e, required = 0x2b1e

 

BBED> quit

 

[oracle@STCS oradata]$ sqlplus / as sysdba

 

SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 16 16:47:59 2011

 

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

SQL> select * from lerry.t1;

 

X

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

my name is lerry

lerry is befaulty

 

SQL> alter system flush buffer_cache;

 

System altered.

 

SQL> select * from lerry.t1;

 

X

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

my name is lerry

testy is befaulty

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24849178/viewspace-714121/,如需转载,请注明出处,否则将追究法律责任。

上一篇: bbed 基础知识
请登录后发表评论 登录
全部评论

注册时间:2011-03-04

  • 博文量
    104
  • 访问量
    231569