当前位置：首页 -> AI编程基础 -> 数据库编程

Oracle BBED工具介绍(六)

2014-11-24 15:17:44 · 作者: · 浏览: 3
标签: Oracle BBED 工具 介绍
00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<32 bytes per line>
BBED> modify /x 62 file 4 block 17 offset 123
Warning: contents of previous BIFILE will be lost. Proceed (Y/N) y
File: /export/home/oradata/orcl/users01.dbf (4)
Block: 17 Offsets: 123 to 634 Dba:0x01000011
------------------------------------------------------------------------
62000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<32 bytes per line>
BBED> revert
All changes made in this session will be rolled back. Proceed (Y/N) y
Reverted file '/export/home/oradata/orcl/users01.dbf', block 17
Warning: contents of previous BIFILE will be lost. Proceed (Y/N)
BBED> dump file 4 block 17 offset 123
File: /export/home/oradata/orcl/users01.dbf (4)
Block: 17 Offsets: 123 to 634 Dba:0x01000011
------------------------------------------------------------------------
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<32 bytes per line>
个人感觉bbed主要用在数据库恢复的时候，比如由于误操作把数据库的字典表的信息改错了，导致数据库不能启动了，此时用bbed在脱机的情况下把字典表的值再改回来。使数据库open。
用modify改完数据之后，block处于corrupt状态，所以要通过sum命令计算并应用checksum值，使block状态恢复正常。
测试：
SQL> select * from bl;
NAME
--------------------
dmm
l
SQL> select dump(1,1016) from dual;
DUMP(1,1016)
-----------------
Typ=2 Len=2: c1,2
BBED> dump file 4 block 17
File: /export/home/oradata/orcl/users01.dbf (4)
Block: 17 Offsets: 0 to 511 Dba:0x01000011
------------------------------------------------------------------------
00a20000 11000000 00000000 00000105 11a70000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
BBED> modify /x 62 file 4 block 17 offset 0
File: /export/home/oradata/orcl/users01.dbf (4)
Block: 17 Offsets: 0 to 511 Dba:0x01000011
------------------------------------------------------------------------
62a20000 11000000 00000000 00000105 11a70000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
BBED> verify
DBVERIFY - Verification starting
FILE = /export/home/