鱼C论坛

 找回密码
 立即注册
查看: 2817|回复: 0

[Oracle] BBED revert verify corrupt命令

[复制链接]
发表于 2013-9-9 08:42:52 | 显示全部楼层 |阅读模式

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

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

x
revert是恢复自bbed 启动以来的所有修改。

BBED> revert dba 1,3315hj
BBED-00202: invalid parameter (3315hj)


BBED> revert dba 1,33145
All changes made to this block will be rolled back. Proceed? (Y/N) y
Reverted file '/u01/app/oracle/oradata/omrep/system01.dbf', block 33145

BBED> sum dba 1,33145 apply
Check value for File 1, Block 33145:
current = 0x86b1, required = 0x86b1

sys@OMREP> select * from srain;

JOB
----------------------------------------------------------------------------------------------------
Srain is dba!
xyuin like oracle!

sys@OMREP> alter system flush buffer_cache;

System altered.

sys@OMREP> select * from srain;

JOB
----------------------------------------------------------------------------------------------------
Srain is dba!
Srain like oracle!

**************************************************************************************************************************
BBED> verify dba 1,33145
DBVERIFY - Verification starting
FILE = /u01/app/oracle/oradata/omrep/system01.dbf
BLOCK = 33145


DBVERIFY - Verification complete

Total Blocks Examined         : 1
Total Blocks Processed (Data) : 1
Total Blocks Failing   (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing   (Index): 0
Total Blocks Empty            : 0
Total Blocks Marked Corrupt   : 0
Total Blocks Influx           : 0
Message 531 not found;  product=RDBMS; facility=BBED

*****************************************************************************************************************************
BBED> corrupt dba 1,33145
Block marked media corrupt.

sys@OMREP> alter system flush buffer_cache;

System altered.

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> revert dba 1,33145
All changes made to this block will be rolled back. Proceed? (Y/N) y
Reverted file '/u01/app/oracle/oradata/omrep/system01.dbf', block 33145

BBED> sum dba 1,33145
Check value for File 1, Block 33145:
current = 0x86b1, required = 0x86b1

sys@OMREP> select * from srain;

JOB
----------------------------------------------------------------------------------------------------
Srain is dba!
Srain like oracle!
undo 命令不能undo 一个corruption,但是revert 命令却可以。

想知道小甲鱼最近在做啥?请访问 -> ilovefishc.com
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

小黑屋|手机版|Archiver|鱼C工作室 ( 粤ICP备18085999号-1 | 粤公网安备 44051102000585号)

GMT+8, 2024-11-25 01:57

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表