Oracle 块损坏恢复试验

连接本地数据库

[root@localhost ~]# sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on 星期三 8月 8 09:58:03 2018

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

请输入用户名:  SYSTEM
输入口令: 

连接到: 
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> 

创建测试数据

create table test (id number, name char(200));
insert into test values(1, 'alfred 1');
insert into test values(2, 'alfred 2');
insert into test values(3, 'alfred 3');
insert into test values(4, 'alfred 4');
insert into test values(5, 'alfred 5');
insert into test values(6, 'alfred 6');
insert into test values(7, 'alfred 7');
insert into test values(8, 'alfred 8');
insert into test values(9, 'alfred 9');
insert into test values(10, 'alfred 10');
commit;

查询表中每一行对应的文件号和块号

SQL> select blocks from user_tables where table_name = 'TEST';  

    BLOCKS
----------

SQL> select dbms_rowid.rowid_relative_fno(rowid) R_FNO, dbms_rowid.rowid_block_number(rowid) b_no, id from test order by 1,2;

     R_FNO       B_NO         ID
---------- ---------- ----------
         1      43073          1
         1      43073          9
         1      43073          2
         1      43073          3
         1      43073         10
         1      43073          5
         1      43073          6
         1      43073          7
         1      43073          8
         1      43073          4

已选择10行。

使用bbed工具模拟破坏1号数据文件的43073数据块

待续。。。。