BBED modify undo命令
BBED> modify /c xyu dba 1,33145 offset 8153File: /u01/app/oracle/oradata/omrep/system01.dbf (1)
Block: 33145 Offsets: 8153 to 8191 Dba:0x00408179
------------------------------------------------------------------------
78797569 6e206c69 6b65206f 7261636c 65212c01 010d5372 61696e20 69732064
62612106 06148d
<32 bytes per line>
BBED> d /v dba 1,33145 offset 8153 count 128
File: /u01/app/oracle/oradata/omrep/system01.dbf (1)
Block: 33145 Offsets: 8153 to 8191Dba:0x00408179
-------------------------------------------------------
78797569 6e206c69 6b65206f 7261636c l xyuin like oracl
65212c01 010d5372 61696e20 69732064 l e!,...Srain is d
62612106 06148d l ba!....
<16 bytes per line>
sys@OMREP> select * from srain;
select * from srain
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 1, block # 33145)
ORA-01110: data file 1: '/u01/app/oracle/oradata/omrep/system01.dbf'
***************************************************************************************************************
BBED> undo
BBED> modify /x 537261 filename '/u01/app/oracle/oradata/omrep/system01.dbf' block 33145. offset 8153.
File: /u01/app/oracle/oradata/omrep/system01.dbf (1)
Block: 33145 Offsets: 8153 to 8191 Dba:0x00408179
------------------------------------------------------------------------
53726169 6e206c69 6b65206f 7261636c 65212c01 010d5372 61696e20 69732064
62612106 06148d
<32 bytes per line>
undo命令是回滚最后一次的操作。
BBED> d /v dba 1,33145 offset 8153 count 128
File: /u01/app/oracle/oradata/omrep/system01.dbf (1)
Block: 33145 Offsets: 8153 to 8191Dba:0x00408179
-------------------------------------------------------
53726169 6e206c69 6b65206f 7261636c l Srain like oracl
65212c01 010d5372 61696e20 69732064 l e!,...Srain is d
62612106 06148d l ba!....
<16 bytes per line>
sys@OMREP> select * from srain;
JOB
----------------------------------------------------------------------------------------------------
Srain is dba!
Srain like oracle!
页:
[1]