導讀: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 

關鍵詞標簽: 實例 標簽