|
马上注册,结交更多好友,享用更多功能^_^
您需要 登录 才可以下载或查看,没有账号?立即注册
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 命令却可以。
|
|