1/oracle/oradata/gname/mssm.dbf (7)
Block: 10 Offsets: 8187 to 8191 Dba:0x01c0000a
------------------------------------------------------------------------
62020668 d5
<32 bytes per line>
BBED> m /x 63
File: /u01/oracle/oradata/gname/mssm.dbf (7)
Block: 10 Offsets: 8187 to 8191 Dba:0x01c0000a
------------------------------------------------------------------------
63020668 d5
<32 bytes per line>
BBED> m /x 64
File: /u01/oracle/oradata/gname/mssm.dbf (7)
Block: 10 Offsets: 8187 to 8191 Dba:0x01c0000a
------------------------------------------------------------------------
64020668 d5
<32 bytes per line>
BBED> d /v
File: /u01/oracle/oradata/gname/mssm.dbf (7)
Block: 10 Offsets: 8187 to 8191 Dba:0x01c0000a
-------------------------------------------------------
64020668 d5 l d..h.
<16 bytes per line>
BBED> undo --回到上一步
BBED> modify /x 63 filename '/u01/oracle/oradata/gname/mssm.dbf' block 10. offset 8187.
File: /u01/oracle/oradata/gname/mssm.dbf (7)
Block: 10 Offsets: 8187 to 8191 Dba:0x01c0000a
------------------------------------------------------------------------
63020668 d5
<32 bytes per line>
BBED> revert --回到最初
All changes made in this session will be rolled back. Proceed (Y/N) y
Reverted file '/u01/oracle/oradata/gname/mssm.dbf', block 10
Warning: contents of previous BIFILE will be lost. Proceed (Y/N) y
BBED> d /v
File: /u01/oracle/oradata/gname/mssm.dbf (7)
Block: 10 Offsets: 8187 to 8191 Dba:0x01c0000a
-------------------------------------------------------
61020668 d5 l a..h.
<16 bytes per line>
真的要改数据了
BBED> show
FILE# 7
BLOCK# 10
OFFSET 8187
DBA 0x01c0000a (29360138 7,10)
FILENAME /u01/oracle/oradata/gname/mssm.dbf
BIFILE bifile.bbd
LISTFILE /u01/bbed/filelist.txt
BLOCKSIZE 8192
MODE Edit
EDIT Unrecoverable
IBASE Dec
OBASE Dec
WIDTH 80
COUNT 300
LOGFILE log.bbd
SPOOL No
BBED> m /x 63
File: /u01/oracle/oradata/gname/mssm.dbf (7)
Block: 10 Offsets: 8187 to 8191 Dba:0x01c0000a
------------------------------------------------------------------------
63020668 d5
<32 bytes per line>
BBED> sum
Check value for File 7, Block 10:
current = 0x5a29, required = 0x5829
SQL> select * from t;
ID NAME
---------- --------------------
1 a
2 b
999 sven
BBED> sum apply --真正应用之前的修改，类似oracle的commit
Check value for File 7, Block 10:
current = 0x5829, required = 0x5829
SQL> /
ID NAME
---------- --------------------
1 a
2 b
999 sven
SQL> conn / as sysdba
Connected.
SQL> startup force
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 79693392 bytes
Database Buffers 201326592 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> conn ms1/ms1
Connected.
SQL> select * from t;
ID NAME
---------- --------------------
1 c
2 b
999 sven
copy块复制命令
BBED> set file 7 block 10 offset 8187
FILE# 7
BLOCK# 10
OFFSET 8187
BBED> d /v dba 999,10 offset 8187
File: /u01/oracle/oradata/gname/mssm.dbf_bak20140704 (999) --备份文件中是a
Block: 10 Offsets: 8187 to 8191 Dba:0xf9c0000a
-------------------------------------------------------
610706a6 ba l a....
<16 bytes per line>
BBED> d /v dba 7,10 offset 8187
File: /u01/oracle/oradata/gname/mssm.dbf (7)
Block: 10 Offsets: 8187 to 8191 Dba:0x01c0000a --当前数据文件中是e
-------------------------------------------------------
65020668 d5 l e..h.
<16 bytes per line>
BBED> copy dba 999,10 to dba 7,10 --copy覆盖
Warning: contents of previous BIFILE will be lost. Proceed (Y/N) y
File: / |