设为首页 加入收藏

TOP

使用bbed将属于前一个incarnation的offline的datafile弄成online状态(四)
2015-11-21 01:49:06 来源: 作者: 【 】 浏览:1
Tags:使用 bbed 属于 一个 incarnation offline datafile 弄成 online 状态
---------------------------------------------如下是改kscnbas----------------------------------------------

set offset 484

BBED> set offset 484
        OFFSET          484

BBED> m /x d9bb3600
BBED-00209: invalid number (d9bb3600)


BBED> m /x d9bb
 File: /u01/app/oracle/oradata/test/ten01.dbf (5)
 Block: 1                Offsets:  484 to  995           Dba:0x01400001
------------------------------------------------------------------------
 d9bb3600 00000000 5dc94b34 01000000 98000000 2cb60000 10000000 02000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 0d000d00 0d000100 00000000 00000000 00000000 02004001 00000000 00000000 
 b473877d 21e318f1 05000000 06000000 4cef0f00 00000000 dc300f00 00000000 
 374f2730 d63a0800 00000000 85ec1e30 e7ad0800 00000000 3d7e2730 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 

 <32 bytes per line>

BBED> set offset +2
        OFFSET          486

BBED> m /x 3600
 File: /u01/app/oracle/oradata/test/ten01.dbf (5)
 Block: 1                Offsets:  486 to  997           Dba:0x01400001
------------------------------------------------------------------------
 36000000 00005dc9 4b340100 00009800 00002cb6 00001000 00000200 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000d00 
 0d000d00 01000000 00000000 00000000 00000200 40010000 00000000 0000b473 
 877d21e3 18f10500 00000600 00004cef 0f000000 0000dc30 0f000000 0000374f 
 2730d63a 08000000 000085ec 1e30e7ad 08000000 00003d7e 27300000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 

 <32 bytes per line>

BBED> sum 
Check value for File 5, Block 1:
current = 0xc26e, required = 0xcc7f

BBED> sum apply
Check value for File 5, Block 1:
current = 0xcc7f, required = 0xcc7f

?


SQL> select file#,to_char(checkpoint_change#,'999999999999'),to_char(RESETLOGS_CHANGE#,'999999999999') from v$datafile_header;

FILE# TO_CHA

首页 上一页 1 2 3 4 5 下一页 尾页 4/5/5
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇withgrantoption与withadminoptio.. 下一篇ConsecutiveNumbers

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: