导读:1建站知识在oracle中bbed恢复删除数据实例seo网站优化软件网站seo优化课程。

恢复己删除数据一、创建模拟环境

复制代码 代码如下:

SQL> create table hr.xifenfei (id number,name varchar2(20)) tablespace xff;Table created.SQL> insert into hr.xifenfei values(1,'xifenfei');1 row created.SQL> insert into hr.xifenfei values(2,'xff');1 row created.SQL> commit;Commit complete.SQL> select * from hr.xifenfei;ID NAME———- ——————–1 xifenfei2 xffSQL> select rowid,2 dbms_rowid.rowid_relative_fno(rowid)rel_fno,3 dbms_rowid.rowid_block_number(rowid)blockno,4 dbms_rowid.rowid_row_number(rowid) rowno5 from hr.xifenfei;ROWID REL_FNO BLOCKNO ROWNO—————— ———- ———- ———-AAAHy3AACAAAAISAAA 2 530 0AAAHy3AACAAAAISAAB 2 530 1查询file#，block，后面恢复要用SQL> delete from hr.xifenfei where id=2;1 row deleted.SQL> commit;Commit complete.SQL> select * from hr.xifenfei;ID NAME———- ——————–1 xifenfeiSQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down. 

复制代码 代码如下:

[oracle@localhost ~]$ bbed parfile=/tmp/parfile.cnfPassword:BBED: Release 2.0.0.0.0 – Limited Production on Mon Aug 22 01:52:52 2011Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.************* !!! For Oracle Internal Use only !!! ***************BBED> show allFILE# 2BLOCK# 1OFFSET 0DBA 0×00800001 (8388609 2,1)FILENAME /opt/oracle/oradata/xifenfei/xff01.dbfBIFILE bifile.bbdLISTFILE /tmp/listBLOCKSIZE 8192MODE EditEDIT UnrecoverableIBASE DecOBASE DecWIDTH 80COUNT 512LOGFILE log.bbdSPOOL NoBBED> set dba 2,530DBA 0×00800212 (8389138 2,530)BBED> find /c xffFile: /opt/oracle/oradata/xifenfei/xff01.dbf (2)Block: 530 Offsets: 8170 to 8191 Dba:0×00800212————————————————————————7866662c 000202c1 02087869 66656e66 65690106 80e2<32 bytes per line>BBED> dump /vFile: /opt/oracle/oradata/xifenfei/xff01.dbf (2)Block: 530 Offsets: 8170 to 8191 Dba:0×00800212——————————————————-7866662c 000202c1 02087869 66656e66 l xff,……xifenf65690106 80e2 l ei….<16 bytes per line>BBED> dump /v offset 8160File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)Block: 530 Offsets: 8160 to 8191 Dba:0×00800212——————————————————-0000003c 020202c1 03037866 662c0002 l …<......xff,..02c10208 78696665 6e666569 010680e2 l ....xif网站seo优化培训enfei....<16 bytes per line>BBED> dump企业网站建设 /v offset 8164File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)Block: 530 Offsets: 8164 to 8191 Dba:0×00800212——————————————————-020202c1 03037866 662c0002 02c10208 l ……xff,……78696665 6e666569 010680e2 l xifenfei….<16 bytes per line>BBED> dump /v offset 8162File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)Block: 530 Offsets: 8162 to 8191 Dba:0×00800212——————————————————-003c0202 02c10303 7866662c 000202c1 l .<......xff,....02087869 66656e66 65690106 80e2 l ..xifenfei....<16 bytes per line>BBED> dump /v offset 8163File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)Block: 530 Offsets: 8163 to 8191 Dba:0×00800212——————————————————-3c020202 c1030378 66662c00 0202c102 l <......xff,.....08786966 656e6665 69010680 e2 l .xifenfei....<16 b网站seo优化诊断工具ytes per line>通过尝试，推断出来3c的offsetBBED> modify /x 2cWarning: contents of previous BIFILE will be lost. Proceed? (Y/N) yFile: /opt/oracle/oradata/xifenfei/xff01.dbf (2)Block: 530 Offsets: 8163 to 8191 Dba:0×00800212————————————————————————2c020202 c1030378 66662c00 0202c102 08786966 656e6665 69010680 e2<32 bytes per line>修改3c为2cBBED> sum applyCheck value for File 2, Block 530:current = 0xb1b9, required = 0xb1b9 

关键词标签: 实例 标签