首页 > Linux操作系统 > Linux操作系统 > 利用bbed修改数据
[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博客 ” ,链接:https://blog.itpub.net/24849178/viewspace-714121/ ,如需转载,请注明出处,否则将追究法律责任。