BBED modify undo命令

湖北佛 · 发表于 2013-9-9 08:39:32

马上注册，结交更多好友，享用更多功能^_^

您需要登录才可以下载或查看，没有账号？立即注册

x

BBED> modify /c xyu dba 1,33145 offset 8153

File: /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 8191  Dba: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 8191  Dba: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!

账号		自动登录	找回密码
密码			立即注册

[Oracle] BBED modify undo命令

马上注册，结交更多好友，享用更多功能^_^